nV News Forums

 
 

nV News Forums (http://www.nvnews.net/vbulletin/index.php)
-   Software Development (http://www.nvnews.net/vbulletin/forumdisplay.php?f=53)
-   -   Migrating from SQL 2005 to SQL 2008 (http://www.nvnews.net/vbulletin/showthread.php?t=140699)

DiscipleDOC 10-30-09 10:39 AM

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.

ViN86 10-30-09 10:51 AM

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 :lol:

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

DiscipleDOC 10-30-09 11:15 AM

Re: Migrating from SQL 2005 to SQL 2008
 
Quote:

Originally Posted by ViN86 (Post 2114104)
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/movi...in-three-steps

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

crainger 11-01-09 03:32 AM

Re: Migrating from SQL 2005 to SQL 2008
 
You'll be k DOC.

LovingSticky 11-01-09 05:15 AM

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.


All times are GMT -5. The time now is 05:13 AM.

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