December 2, 2009 at 1:03 pm
Hi,
I have a bunch of SQL Server tables and Views and I want to export them to Oracle database.
Could anyone please tell me how I can achieve this using SSIS or DTS or any other means, with a list of steps?
Thank You,
Best Regards,
SQLBuddy
December 2, 2009 at 1:13 pm
First result from google shows:
download.microsoft.com/download/6/9/d/69d1fea7-5b42-437a-b3ba-a4ad13e34ef6/OracleSSIS.docx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 2, 2009 at 1:51 pm
Hi Jason,
Thank you very much. You are always so quick in your response.
I really appreciate your help.
Thank You,
Best Regards,
SQLBuddy
December 3, 2009 at 9:58 am
Hi,
That article is for sending data from oracle to SQL server.
But my problem is that I have to send table and also views (Definition- not view data) from SQL Server to an existing oracle schema. Also I have around 300 tables and 300 views. I don’t know how to transfer all these tables and views all at once using SSIS or any other tool?
Could anyone please help me with this?
Thank You,
Best Regards,
SQLBuddy.
December 3, 2009 at 10:06 am
Your best bet will be to research and find a tool that can do schema comparisons between the two platforms (i.e. redgate has one that will compare SQL databases for you).
Or the alternative would be to script out your objects and correct any syntax for use within Oracle to recreate your objects in the oracle db.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply