Go Back   nV News Forums > Software Forums > Software Development

Newegg Daily Deals

Reply
 
Thread Tools
Old 10-30-09, 10:39 AM   #1
DiscipleDOC
 
DiscipleDOC's Avatar
 
Join Date: Dec 2002
Location: Alabama, Planet Earth
Posts: 5,993
Default 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.
DiscipleDOC is offline   Reply With Quote
Old 10-30-09, 10:51 AM   #2
ViN86
 
Join Date: Mar 2004
Posts: 15,486
Default 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
ViN86 is offline   Reply With Quote
Old 10-30-09, 11:15 AM   #3
DiscipleDOC
 
DiscipleDOC's Avatar
 
Join Date: Dec 2002
Location: Alabama, Planet Earth
Posts: 5,993
Default Re: Migrating from SQL 2005 to SQL 2008

Quote:
Originally Posted by ViN86 View Post
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.
DiscipleDOC is offline   Reply With Quote
Old 11-01-09, 03:32 AM   #4
crainger
 
crainger's Avatar
 
Join Date: Aug 2004
Location: Coffs Harbour, NSW, Australia
Posts: 29,559
Send a message via AIM to crainger
Default Re: Migrating from SQL 2005 to SQL 2008

You'll be k DOC.
crainger is offline   Reply With Quote
Old 11-01-09, 05:15 AM   #5
LovingSticky
plenty of work, no games
 
LovingSticky's Avatar
 
Join Date: Sep 2007
Posts: 559
Default 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
LovingSticky is offline   Reply With Quote
Reply


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -5. The time now is 09:08 AM.


Powered by vBulletin® Version 3.7.1
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 1998 - 2014, nV News.