Asp Forum
Home
|
Login
|
Register
|
Search
Forums
>
comp.lang.ruby
Using ruby to transfer and clean data between databases
Richard Dowden
10/24/2007 12:12:00 PM
Hi all,
I have some data in an access database and I want to move this to my new
SqlServer2005 database. However the schema of the database has changed
significantly, it's been normalised and various tables have been added,
so the data won't fit in exactly without first being 'cleaned' so to
speak.
I was just wondering whether you think I could write some kind of ruby
script to automate some of it, whether anyone has done something
similar, or if there's a better way of doing this.
Fairly open question I know, but I want to know how others would go
about doing this before I embark upon it.
Cheers,
Daf
--
Posted via
http://www.ruby-...
.
3 Answers
Robert Klemme
10/24/2007 2:27:00 PM
0
2007/10/24, Felix Windt <fwmailinglists@gmail.com>:
> > -----Original Message-----
> > From: list-bounce@example.com
> > [mailto:list-bounce@example.com] On Behalf Of Richard Dowden
> > Sent: Wednesday, October 24, 2007 5:12 AM
> > To: ruby-talk ML
> > Subject: Using ruby to transfer and clean data between databases
> >
> > Hi all,
> >
> > I have some data in an access database and I want to move
> > this to my new
> > SqlServer2005 database. However the schema of the database has changed
> > significantly, it's been normalised and various tables have
> > been added,
> > so the data won't fit in exactly without first being 'cleaned' so to
> > speak.
> >
> > I was just wondering whether you think I could write some kind of ruby
> > script to automate some of it, whether anyone has done something
> > similar, or if there's a better way of doing this.
> >
> > Fairly open question I know, but I want to know how others would go
> > about doing this before I embark upon it.
> >
> > Cheers,
> > Daf
> > --
> > Posted via
http://www.ruby-...
.
> >
>
> That seems more like a job for MS SQL Data Transformation Services. While
> you could certainly just select row by row from Ruby, build the new
> datastructure and insert it, MS SQL should come with all the tools necessary
> built in unless you have somewhat strange or outrageous transformation
> requirements.
I was going to write the same. Additional info: DTS allows you to do
arbitrary transformations using a scripting language. Last time I
looked JavaScript and VisualBasic were supported. Since this is
integrated into DTS I'd say this is probably a better choice.
Kind regards
robert
Richard Dowden
10/24/2007 2:47:00 PM
0
Ok, I think i'll be looking into doing that then. I believe DTS is
called 'Integration Services' in SQL server 2005 correct? I think I'll
need to install it off the cd as I can't find it in it's start group.
Thanks for the help.
Daf
--
Posted via
http://www.ruby-...
.
Venkat
10/25/2007 5:56:00 AM
0
"Richard Dowden" <daffy_dowden@hotmail.com> wrote
news:f8c3573c257ff063776df780a05c111d@ruby-forum.com...
> Ok, I think i'll be looking into doing that then. I believe DTS is
> called 'Integration Services' in SQL server 2005 correct? I think I'll
> need to install it off the cd as I can't find it in it's start group.
Try Business Intelligence Development Studio :-)
Integration Services (SSIS) is designed in Visual Studio like BIDS (Business
Intelligence Development Studio) unlike DTS which can be done in Enterprise
Manager of SQL Server 2000.
http://msdn2.microsoft.com/en-us/library/ms1...
Anyway you would be better served in
news://msnews.microsoft.com/microsoft.public.sqlserver.dts
or
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sql...
-Venkat
Servizio di avviso nuovi messaggi
Ricevi direttamente nella tua mail i nuovi messaggi per
Using ruby to transfer and clean data between databases
Inserendo la tua e-mail nella casella sotto, riceverai un avviso tramite posta elettronica ogni volta che il motore di ricerca troverà un nuovo messaggio per te
Il servizio è completamente GRATUITO!
x
Login to ForumsZone
Login with Google
Login with E-Mail & Password