Re: How to copy table from oracle database to sqlserver database ?

From: cr_announce <announce_at_campaign-runner.com>
Date: 30 Aug 2004 07:15:38 -0700
Message-ID: <baf23049.0408300615.33579f98@posting.google.com>

jewelk_at_free.fr (Cyril) wrote in message news:<cd38c3d6.0408100615.6371b40e_at_posting.google.com>...
> Hello,
>
> I need to copy a table from an 8i oracle database to a sqlserver 2000 database.
>
> Is it possible to use the command "COPY FROM ... TO ..." ?
> So, what is the correct syntax ?
>
>
> Thanks for your help
>
> Cyril

If your options include using 3rd-party tools, CampaignRunner can help you here. You can transfer data easily between Oracle, SQL Server or DB2.

Otherwise, the best option would be to extract the data from Oracle into a delimited file, and then to use SQLServer's bcp tool to load it into SQLServer. The Oracle's documentation on sql*loader and Books Online for SQLServer will provide the details on the commands that you would need.

Good luck! Received on Mon Aug 30 2004 - 09:15:38 CDT