Upgrade from SQL 2000 to SQL 2008

Question

Post reply

Upgrade from SQL 2000 to SQL 2008

Minaz Amin

SSChampion

Points: 11052
More actions
December 22, 2011 at 6:08 am

#391188

Hi,
We are planning to upgrade from SQL 2000 to SQL 2008 Db as well as DTS packages.
Do let me know the issues I will face and waht will be the smooth methode for it.
"More Green More Oxygen !! Plant a tree today"

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

There's a whitepaper from the SQL Server team.

Also check out this article:

http://blogs.msdn.com/b/john_daskalakis/archive/2010/01/07/9945117.aspx

For DTS:

http://www.simple-talk.com/sql/ssis/dts-to-ssis-migration/

How painless and smooth it will be, that depends on your system 🙂

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

SQlLogic SSCrazy Eights Points: 9686 More actions · Answer 2

You can download this

http://www.microsoft.com/download/en/details.aspx?id=15220

This is good documentation from Dell

http://www.dell.com/downloads/global/solutions/public/white_papers/SQL_2000_SQL_2008_Migration_Guide.pdf

You can download SQL Server 2008 Upgrade Advisor tool which is very useful tool.

You can download tool from

http://www.microsoft.com/download/en/details.aspx?id=11455

EdVassie SSC Guru Points: 60472 More actions · Answer 3

It can be good to decouple the DTS to SSIS upgrade from the SQL 2000 to SQL 2008 upgrade.

If you install the 'SQL 2005 Backward Compatibility' component for SQL 2008 and the 'DTS Designer Component' then you can edit and create new DTS packages in SQL 2008. The best way to transfer DTS packages between SQL 2000 and SQL 2008 is the 'DTS Backup 2000' freeware component as this transfers the DTS Designer layout and annotations, while all other methods loose this information.

Using DTS on SQL 2008 should not be considered as a permanent solution, as SQL 2012 has no suppotr for DTS packages, but it will allow you to do the SSIS conversion at a timescale convenient to you. It is also worth considering the PragmaticWorks SSIS conversion routines, as this can make the job a lot easier.

Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

johnitech.itech Hall of Fame Points: 3252 More actions · Answer 4

:hehe:

Ok i will share with these Links

1-

http://blogs.msdn.com/b/chkoenig/archive/2008/12/01/upgrading-from-sql-2000-2005-to-2008.aspx

2-

http://community.spiceworks.com/topic/85995-how-to-upgrade-from-sql-2000-to-sql-2008

😀

Minaz Amin SSChampion Points: 11052 More actions · Answer 5

Thank you all.

"More Green More Oxygen !! Plant a tree today"