Here is question from Jaynir

Could u please help me out on the real time scenarios that most of the DBAs face? Could you please highlight the probable issues that could arise during migration from 2000 to 2005?

Probable issue that could arise during migration:

1)Unexperienced DBA handling the migration process without creating proper documentation.

2)During migration of DTS package to SSIS,all activexscript task involved in COM object should be rewritten in script task in SSIS

3)When there is no team work with Network team during switching server to new one.

Here is what I do During migration of SQL 2000 to SQL Server 2005

1) Create proper documentation (show manager how good you are ) with failover plan as well

2) Install SQL Server 2005 on new server with necessary patches and Service packs.

3)Migrate DTS packages with COM object and associated database to SSIS and test in new environment and delete database after you are successful with testing.

4) Backup all database  and restore in new server in Norecovery mode

5) Take last transactional log backup all database and restore in new server 

5a) Migrate all DTS packages to SSIS packages. 

6)Tell your network guys to switch the DNS  name or Server name  so that application will see same Server name and I.p address

7) Make sure all applications are working fine  and update stats

Jaynir,

It is good to post here so everyone can share.Isn't it?