I recently performed a migration exercise for one of my clients wherein they upgraded their SQL Server versions. This has taught me a lot and in this post i shall list some of the post migration steps that need to be performed. I'll also give a list of a few links along the way where these points have been discussed in detail and hence i need not re-invent the wheel by writing them here again.

So here goes my list (since i have provided the links, i have refrained from describing the points in detail). The intent is to enable readers to use this as a quick checklist whenever they perform a migration or upgrade SQL Server instances.

 - Transfer Logins
 - Service Packs, upgrades and hotfixes
 - Run DBCC UPDATEUSAGE on all databases to correct any incorrect row or page counts.
 - Change authentication mode if required
 - Change database compatibility level if required
 - Connection string change in applications
 - Transfer Jobs - Remove @uid parameter
 - Update Statistics - See point 6 in link below (QueryPlan needs to have latest data). Done
   by default anyways.
 - DBCC reindex etc
 - Configure HA
 - Run DBCC CheckDB on all databases to check consistency
 - Enable full text indexing (disabled after upgrade)


Unknown said...

If you would like to take a good deal from this article then you have to apply such techniques to your won webpage.

hhdbsm46wl said...

The newly fashioned plastic Bike Helmet article is then ejected out of the mould. This course of is repeated to fabricate tens of millions of equivalent plastic components. Located in Eastern Pennsylvania, Abtec, Inc. has over 100 years of combined expertise within the design, growth, and manufacturer of customized injection molds and assist tooling. From mildew and half design to prototyping to full production, our team goals to deliver the very best high quality injection molding services and products at the best possible|the absolute best|the very best} value. Bottles are the commonest product manufactured using plastic injection molding.