question

Naina avatar image
Naina asked

Database team tasks for SQL Server 2008 Migration

Hello,

Please let me know, what are the Database Team Tasks involved during SQL Server 2008 Migration.

I want to know all steps involved including running Upgrade Advisor, as i need to provide Effort Days involved by Database Team.

Kindly help me on this.

Thanks Naina

sql-server-2008sql
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock avatar image sp_lock commented ·
If you are unsure what is needed, I would take @Grant up on his offer... If you haven't dont it before or you are warey then getting an expert consultant is advisable!
1 Like 1 ·
Grant Fritchey avatar image
Grant Fritchey answered

I'm not going to give you a full project plan including all the estimated times, etc. unless you want to pay for consulting.

However...

You first need to determine what type of upgrade you're performing, in-place or side-by-side. I find the side-by-side, where you leave your existing server alone and install 2008 on a new server to be both safer in the event there is a problem during the upgrade, and easier. But not all businesses can support it.

Run the Upgrade Advisor Deal with any issues that must be addressed prior to upgrading Preferably do the full upgrade process on a test server and validate that the application(s) can run against 2008, prior to hitting production. Assuming 2000 as the source, find all DTS packages. You can either just plan on upgrading them all to SSIS or you can get DTS Exchange which will automate your processes considerably in this area. Backup the existing database Use restore or offline/copy/attach/online to get the database to 2008 (unless you're doing an in place upgrade) Once the database is online, update all statistics, backup, again, to a different location, change the compatibility level, validate users and logins (orphaned users problem) and you're off.

That's a rough overview of the process we've been following.

2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

TimothyAWiseman avatar image TimothyAWiseman commented ·
Grant has a good answer, but I would like to add the recommendation to upgrade the test servers first. This will let you become comfortable with the process (and see very roughly how long it takes) before you touch production. If you can't do that for some reason, get a separate system where you can walk through the upgrade process before touching production.
1 Like 1 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
I agree, but I thought I said that.
0 Likes 0 ·
Kev Riley avatar image
Kev Riley answered

migrating from ? Previous versions, Oracle, A.N.OtherDB? Guessing previous version as you mention Upgrade Advisor - so what version/edition

MSDN link for upgrading

Migrating from other products, try this

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.