August 4, 2005 at 1:53 pm
I need to transfer table structures from Oracle 9i to SQL Server 2000. What is the best means to accomplish this? In a test environment, I have used the DTS wizard to generate and import of 2 Oracle tables. I save this to a local package instead of running it immediately. I then remove Transform Data Task and the Workflow Completion. This leaves me with 2 connections (1 to Oracle and 1 to SQL Server) and Execute SQL Task, which creates the table in SQL Server. This is great but I want to be able to run this DTS monthly and have any structure changes in the Oracle table populate into my SQL Server. The above DTS that I described will not pick up the latest changes that occur in Oracle. I am looking for another way. It would be great if it can be done in DTS.
August 8, 2005 at 8:00 am
This was removed by the editor as SPAM
August 8, 2005 at 11:31 pm
Microsoft has a tool to handle such request, Search Microsoft SQL Server website.
September 14, 2005 at 7:07 pm
I hope that this late reply can help someone:
SQL Server Migration Assistant for Oracle V2.0 Beta
http://go.microsoft.com/?linkid=3978512
Download this Oracle to SQL Server 2005/2000 Migration Toolkit (9/6/2005).
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply