Copy data & objects from SQL SERVER to Oracle

• vduggaraju

  SSCommitted

  Points: 1643

  More actions

  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

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737868

  More actions

  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