Hi everyone,

I have an ODBC question. I have two databases on the network. One is running under SQL Server and the other is running under Oracle. There is a schema on the Oracle database that has the exact schema as the SQL Server database (more or less). What I want to do is copy the contents of each table from SQL Server to Oracle. I know there must be a way to do this with a view or a script. I cannot use any tool like Oracle migration or anything else and it has to go over ODBC.

Can someone suggest a way to do this? Could Access be used for something like this? I am afraid I am extremely inexperienced with database stuff.

Thanks. Any help would be greatly appreciated.

Sincerely,

Pankaj

Hi,

I did not have much sleep last night. The obvious choice is the DTS wizard built into SQL Server!

Pankaj

Well, I've loaded data into Oracle from Excel spreadsheets a number of times, but I've done it using the PowerBuilder pipeline utility.

I know you can extract table data from SQL Server and save them into .CSV files. You can set up a PB pipeline with ODBC connectivity to read the files. Then you define your input (Oracle) table in PB(ie. columns, datatypes, scale) then run the pipeline.

The only downside is that you'd have to do one table at a time and you'd have to purchase PB (~$3000). Again, there's probably more streamlined and cheaper ways to go about this, but at least I know this method works.

Regards

Try out the data migration tool offered by SwisSQL (http://swissql.com/data-migration.html)