Upgrade from sql 2000 to sql 2005

• balaji.ganga

  SSCrazy

  Points: 2280

  More actions

  September 9, 2010 at 11:29 pm

  #142686

  Hi All,

  Some of the application database server running on sql 2000. They plan to upgrade from 2000 to 2008.

  Client will not give time time. So we have to follow the below methods

  1) take a backup from sql 2000

  2) restore those backup to sql 2008

  3) Some of the DTS Packages migrated into SSIS package.

  My Question Is..

  a) Is it proper way for upgradation method

  b) suppose i follow this method.. Any problems comes in future

  c) If problem comes.. what is an alternate method?

  Could you pls suggest me

  Thanks & Regards

  Balaji.G

• homebrew01

  SSC Guru

  Points: 55548

  More actions

  September 10, 2010 at 5:22 am

  #1219085

  Upgrading has been covered many times. You could search this site for "2000 2008 upgrade" and you will get a lot of information. Then maybe you can post more specific questions based on what you've learned.

• WayneS

  SSC Guru

  Points: 95460

  More actions

  September 10, 2010 at 8:04 am

  #1219178

  This is covered in the SQL Server 2008 Upgrade Technical Reference Guide. It's called a side-by-side upgrade.

  Wayne
  Microsoft Certified Master: SQL Server 2008
  Author - SQL Server T-SQL Recipes

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2