InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 12:40:34 GMT20http://www.sqlservercentral.com/Forums/Topic436058-1160-1.aspx[i]- IMO this post is placed in the wrong forum (discuss content posted by BockWoody ??)[/i]- Start with MS SQL2005 upgrade advisor (analysis your sql2000 db)- fix the problems it detects in your sql2000-db- Keep in mind to test your applications when modifying the sql2000 db problems. They should be perform at sql2000 side !- determind the path for migration : * permare user id's to be migrated (especialy sqlusers) * backup / restore * detach / attatch- DBCC CHECKDB (0) WITH ALL_ERRORMSGS, DATA_PURITY; (and if it finds issues, fix thenm !)- run full maintenance (rebuild index / sp_updatestats / dbcc updateuseage)- determine when you are going to switch db_level to 90. * and then switch it a the negotiated point in time.- test your applications thoroughly !Prepare DTS migration ... SSIS development may be your biggest issue !Mon, 24 Dec 2007 00:17:36 GMTALZDBAhttp://www.sqlservercentral.com/Forums/Topic436058-1160-1.aspxWhat is the way move a database from sql2000 to sql 2005!Sun, 23 Dec 2007 16:15:26 GMTapierre1