If you are planning a move to SQL Server 2008, although this process can apply for many Database Migrations, perhaps this Microsoft Project Migration Template could help? * There are perhaps steps that I’ve missed out, or you know of an existing template that’s even better – by all means share with us below in the comments. There’s a whole bunch of existing project templates for each SQL Server related project probably that we could dig up. My approach here is to ensure that I delve well into the domain of Project Management as a DBA must/should do from time to time.
A quick nota bene at this planning stage of a project is that you should not skip the time estimations…which in turn lead to the analysis of the critical path. There might be a point where you have to pool resources with another team-member or pull in a consultant to ensure project delivery timelines are met. Somewhere along the critical path of the project you might want to take this proactive step to mitigate deadline risk. In this way, whole project planning with respect to time estimations is a predecessor to accomplishing this task.
And sorry, for the notes sometimes being in FR, I just tend to mix up the sources/references often enough. This template has a little bit of history. While migrating databases in early 2005 for the Artificial Insemination [of cows] Centre of Quebec (CIAQ) Mathieu Noel (his profile on linkedin.com) helped me out greatly while writing this document. This version has been retouched about three times so far, with the most recent being for a bid to a project here. I have to also admit, that I am pressured by the necessity for Personal Development Units (need 20, and this article gives 30 apparently) to maintain the PMP certification before my b-day deadline in a few days. I figure this is the best way to help out the DBA community and keep that certification going at the same time.
