You can also use the SQL Server utility DTS to move the data and you can schedule it as a job, depending on what you need.

Dave

Kid Playa <[Email Address Removed] wrote:
The way I have done it is by creating a flat file of my Oracle data. Then,
use MS-SQL-Server tool to import the data into SQLServer.
2) Write a query to combine all the records in one line break by blank line
(you could see in your data file after each rec) and write it to new
tempTable
3) Update the table base on new tempTable data.
Good luck.

Norbert


>From: "Brian Zelli"

>To: "LazyDBA.com Discussion"
>Subject: Exporting to SQL Server
>Date: Thu, 26 Feb 2004 14:22:52 -0500
>
>Can you export oracle data and have it imported by Sql Server? We know
>you can OLE DB it and connect but can you just export?
>
>ciao,
>Brian
>
>Brian J. Zelli
>Database Administrator
>Adelphia
>(716)558-8109
>brian.[Email Address Removed] today's cartoon: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these
>terms:http://www.lazydba.com/legal.html
>

_________________________________________________________________
Get a FREE online computer virus scan from McAfee when you click here.
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963


--------
Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these terms:http://www.lazydba.com/legal.html


---------------------------------
Do you Yahoo!?
Get better spam protection with Yahoo! Mail
Oracle LazyDBA home page