Data Migration Problem (Oracle 8.0 to SQL 2000)

• shamgodz

  Grasshopper

  Points: 13

  More actions

  July 27, 2002 at 7:43 am

  #105022

  Dear all,

  Recently i have a problem with some migration of data from oracle to sql.

  Scenario.

  Database in Oracle is transfered to SQL Server.

  Transfer has been successful and daily transaction resumed.

  After few days of transaction, user realise that some data is gone and upon verifying my QC discovered that few tables has not been fully migrated over.

  So now, my engineer do another data migration from oracle to sql server. This time, he verified that all the table is sucessfuly copied to sql server.

  But now, the problem is what happened to the new data that is inserted to the previous SQL Server database?

  How should i do about it?

  My engineer told me that he had manually copied the new tables to the new SQL Server database. But from my understanding, this is wrongly done. He can't manually select the row and copy n paste to the new SQL database.

  I need your expertise to advise.

  Yours Urgently.

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  July 31, 2002 at 6:33 pm

  #433760

  Depending on the amount of data its not impossible to copy/paste, though I'll admit its not the preferred technique. Normally when I move something I'll record counts of all tables being moved, then count again when the move is complete. That might get you started.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  Connect with me on LinkedIn