Points to be considered before migrating to MS SQL Server 2005 from MS SQl 2K

• TK SAHU

  SSC Veteran

  Points: 272

  More actions

  August 17, 2006 at 5:48 am

  #172191

  Hi,

  I am in the process of migrating MS SQL server 200 Db to MS SQL Server 2005. Which points should I considered before migrating? Does anybody have a list, which MS SQL 2005 does not support like *= or =* joins etc which was there in MS SQL 2K.

  Thankx in advance.

• August 21, 2006 at 8:00 am

  This was removed by the editor as SPAM

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  August 21, 2006 at 9:54 am

  #655930

  sql server 2005 comes with an upgrade adisory wizard - run  this against your 2000 databases. DTS is likely to be your biggest conversion problem.

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/