SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On



How to convert a SQLserver-2005 database into 0racle 10g Expand / Collapse
Author
Message
Posted Wednesday, January 14, 2009 3:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 26, 2009 10:57 PM
Points: 4, Visits: 19
plz tell me the steps to follow for converting SQL database(tables) to oracle(tables).


Post #636098
Posted Wednesday, January 14, 2009 4:10 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 10:53 AM
Points: 1,635, Visits: 4,218
You can use SSIS to transfer the tables across, create a package with your SQL server as source and the Oracle database as a destination.

Not too sure how you would transfer the procedures/functions automaticaly as they may require some re-writing.
Post #636107
« Prev Topic | Next Topic »


Permissions Expand / Collapse