SQL Server migration

• karthickmanikandan

  Grasshopper

  Points: 20

  More actions

  April 8, 2008 at 4:55 am

  #71541

  Dear all,

  Can some help me for my following query

  What all the necessary things that has to be kept in mind for the objects when we are migrating from sql server 2000 to sql server 2005.

• Mahesh Bote

  SSCrazy Eights

  Points: 9107

  More actions

  April 8, 2008 at 5:11 am

  #799624

  [font="Verdana"]

  fyi ...

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

  Thanks,

  Mahesh

  [/font]

  MH-09-AM-8694

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  April 8, 2008 at 9:08 am

  #799829

  There's no way for us to list everything to keep in mind. Read the "What's New" in BOL for 2005 and look for keyword changes.

• David-250683

  Hall of Fame

  Points: 3452

  More actions

  April 8, 2008 at 9:10 pm

  #800131

  Use the free SQL Server Upgrade Advisor

  http://www.microsoft.com/downloads/details.aspx?FamilyID=1470e86b-7e05-4322-a677-95ab44f12d75&displaylang=en