how to export database from oracle10g to sql server2008

Question

Post reply

how to export database from oracle10g to sql server2008

raaz66

Mr or Mrs. 500

Points: 598
More actions
July 15, 2011 at 6:58 am

#389986

how to export database from oracle10g to sql server2008

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

http://www.microsoft.com/sqlserver/en/us/product-info/migration-tool.aspx#oracle

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

raaz66 (7/15/2011)
how to export database from oracle10g to sql server2008

I have used DTS (in the past) and SSIS to migrate date from Oracle to SQL Server.

The largest was only about 450 GB.

But my experience going from Oracle to SQL is very fast.

My experience in going from SQL Server to Oracle is not so quick using Microsoft ETL Tools.

Regards,

WC

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 3

Welsh Corgi (7/15/2011)
...My experience in going from SQL Server to Oracle....

Now why would anyone ever do that? :hehe:

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

opc.three (7/15/2011)
Welsh Corgi (7/15/2011)
...My experience in going from SQL Server to Oracle....
Now why would anyone ever do that? :hehe:

Ya, I hear ya. 🙂

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/