-
Migrating Oracle Data to SQL SErver
Hi Forum,
I would like to archive all my company's data to an sql server. currently we have all our data stored on a oracle server and going forward we wanna use sql server. I tried using the DTS, but the transfer of data is very very slow. Here i am talking about tables with gigs of data. Could you advise whats the best possible to transfer?
-
I've tried SisSQL Conversion tool, which provide excellent results. It also converts procedures and functions such as java packages.
-
THanx buddy. Shall try that tool tomorow.
-
For large datasets DTS is slow, if you can get data in CSV format (or any other delimited format) then you can use BULK INSERT command to import it.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|