Migrate from sql 2000 to sql 2005

[Badgers]

Hi,

We are planning to migrate our 2000 sql dbs to 2005. The platforms we use are asp, .net 1.1 and .net 2.0.

Does anyone know of any issues which may arise which arenot documentated in the general guides ?


Thanks

 

[ptheriault]

It's hard to say if any issues will arise from migrating to SQL 2005 without review all of you code. You will have to migrate you system to a test database and test everything! I have not experienced any issues with the systems I've migrated.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

I agree. A full test plan is needed for each database/application which is being upgraded.

The only way to know for sure is to migrate a test system and do a full regression test.

Every enviroment is different and you may be using features or commands which we aren't using.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog