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

Here's a nice link:
http://www.packtpub.com/article/movi...in-three-steps

**DiscipleDOC** · 10-30-09, 11:15 AM

Quote:

Originally Posted by ViN86

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

Here's a nice link:
http://www.packtpub.com/article/movi...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.

10-30-09, 10:39 AM	#1
DiscipleDOC Join Date: Dec 2002 Location: Alabama, Planet Earth Posts: 5,933	Migrating from SQL 2005 to SQL 2008 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.

10-30-09, 10:51 AM	#2
ViN86 Registered User Join Date: Mar 2004 Posts: 15,486	Re: Migrating from SQL 2005 to SQL 2008 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 Here's a nice link: http://www.packtpub.com/article/movi...in-three-steps

11-01-09, 03:32 AM	#4
crainger Join Date: Aug 2004 Location: Coffs Harbour, NSW, Australia Posts: 29,535	Re: Migrating from SQL 2005 to SQL 2008 You'll be k DOC.

11-01-09, 05:15 AM	#5
LovingSticky plenty of work, no games Join Date: Sep 2007 Posts: 559	Re: Migrating from SQL 2005 to SQL 2008 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. __________________ Q9550@3.4 + Asus P5Q Premium + 16GB RAM + 2xVelociraptor 300GB + 4xWD Black 1TB RAID-5 on Adaptec 5805 + PoV GTX580 + Dell 3008WFP + Windows 7 x64 Xbox 360 Elite + Kinect + Onkyo receiver + Acoustic Energy Aelite 1/3/center speakers + 46" FullHD Samsung TV