March 26, 2003 at 12:50 am
Hi,
I wrote a tool which allows me to quickly export data out of Oracle and into MS SQL Server. I have also used it to move data out of Access. INSERT scripts are generated which you can run to import the data.
I welcome your comments for improvement. I am a developer, not a DBA, so I might unknowingly be doing this the hard way! If I am, please let me know.
You can download the tool from:
http://www.ottosoft.com/prod_datachameleon.asp
Just unzip it and browse the help file to get started.
Thanks - Ken
March 26, 2003 at 3:04 am
Ken, it looks pretty cool and I'll have a better look at it later. However, just a note, you can set up a linked server from SQL Server to Oracle and grab the data from there. Or you can use DTS and set up a package that will transfer it for you. I think many DBAs would prefer that way since they know DTS and can use their existing knowledge.
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply