Exporting Data from SQL Server 2005 to Oracle 10

microsoft.public.sqlserver.tools

18 Jan 2007 4:50 PM

Paul W

I am attempting to use the SQL Server Export Data tool to export data from
SQL Server 2005 to an Oracle 10g database. I have already used this
successfully to export to a SQL Server 2000 database.
My problem is that on the step of the wizard where you select the tables to
transfer, it appears to want to create all of the tables first. The tables
already exist and I just want it to append the rows of data to the Oracle
table data. I do not want SQL Server to create the tables for me.

All the options (when selecting Edit Mappings) are greyed out. Does anybody
have any ideas what I need to do or do I have to let it create the tables for
me? This is not feasible and I see no reason why I should not be able to just
select to Append the data.

Any help would be greatly appreciated.

Thanks,

Paul