Copy data & objects from SQL SERVER to Oracle

  • Hi,

    We are in the process of copy the database including data from SQL Server to Oracle.

    Can you please let us know what is the best way of doing this process.


    Mail ID :

    Phone No : 305-816-3261



  • You would do well to script the database DDL and then ensure it conforms to Oracle standards. Not sure, but I doubt the DTS tools will generate Oracle compliant statements.

    For moving the data, it would be like any other item. Move each table. Again, not sure DTS will script this easily for all tables at once.

    Steve Jones

Viewing 2 posts - 1 through 1 (of 1 total)

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