How to migarte sql 2000 database in to sql server 2005

• rai.dharm

  Newbie

  Points: 5

  More actions

  April 30, 2011 at 1:44 pm

  #150217

  I am new in to sql server ,I have database in sql server 2000.

  I need to Migrate this database on another sql server 2005 .32bit computer .

  please help .

  Thanks

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  April 30, 2011 at 1:58 pm

  #1318106

  To assist you in planning your migration read this article and determine which method would be most suitable for your situation.

  http://www.sqlservercentral.com/articles/Administration/2987/

  I would strongly suggest reading the section on the "Upgrade advisor", before starting any actual upgrade work.

  For assistance in identifying modifications to existing stored procedures read this script:

  http://www.sqlservercentral.com/scripts/Compatibility/62093/

  added 2nd url

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]