Post reply

Copy data & objects from SQL SERVER to Oracle

  • October 22, 2001 at 2:04 pm

    #104578

    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.

    Thanks

    Mail ID : Vduggaraju@prcnet.com

    Phone No : 305-816-3261

    venkatesh


    venkatesh

  • October 22, 2001 at 2:19 pm

    #419183

    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

    steve@dkranch.net

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

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