PDA

View Full Version : Migrating from SQL 2005 to SQL 2008


DiscipleDOC
10-30-09, 10:39 AM
I have a project that I will be working on for the next several weeks. I'm about to buy a PowerEdge 310 and install SQL Server 2008 on the Win Serv 2K8.

I will need to migrate an already existing database to the new server.

I'm doing a lot of research on this, because I do not want any hidden caveats. This DB is proverbially the "meat and potatoes" of my company.

Any links/suggestions that you may have will be greatly appreciated.

ViN86
10-30-09, 10:51 AM
Shouldn't it be a simple Export/Import procedure?

Just don't take down your old one til you're sure your new one is up :lol:

Here's a nice link:
http://www.packtpub.com/article/moving-a-database-from-sql-server-2005-to-sql-server-2008-in-three-steps

DiscipleDOC
10-30-09, 11:15 AM
Shouldn't it be a simple Export/Import procedure?

Just don't take down your old one til you're sure your new one is up :lol:

Here's a nice link:
http://www.packtpub.com/article/moving-a-database-from-sql-server-2005-to-sql-server-2008-in-three-steps

Thanks....that is exactly what I need. ;)

crainger
11-01-09, 03:32 AM
You'll be k DOC.

LovingSticky
11-01-09, 05:15 AM
Simple Attach/Dettach is not enough. To use version 10 (SQLSRV 2008) functionality, you have to change Compatibility Level as well, in DB Properties/Options.