|
10-30-09, 12:39 PM
|
#1 |
|
|
Modded Word Warrior
Join Date: Dec 2002
Location: Alabama, Planet Earth
Posts: 25,874
    |
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.
__________________
Original translation: "The fool says in his heart, 'no, God'" Psalm 53:1 QFmfT™   ____________________________________________ ***Gaming Desktop*** ASUS Rampage II Extreme X58 · Intel Core i7 920 · *Modded* CoolIT Domino ALC · Corsair Dominator 6GB (Tri-Channel) · BFG GTX 285 SLI· WD 150 GB VelociRaptor · 2 x WD 1TB 32 MB Cache · Dell UltraSharp 2408WFP Monitor · Thermaltake Element V · Windows 7 Ultimate(64 bit) ***Work Laptop*** Dell Vostro 1720 · Windows 7 Ultimate(64 bit)· GeForce 9600m · 4GB RAM · 500GB Seagate Momentus 7200.4 HD PS3 username: DiscipleDOC Steam username: DiscipleDOC |
|
|
|
|
10-30-09, 12:51 PM
|
#2 |
|
Buzz Aldrin, A Real Hero
Join Date: Mar 2004
Posts: 15,415
|
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
__________________
My Rig... Mobo DFI LanParty LT P35 | CPU Intel C2D E8400 @ 3.6GHz on 1.26V | Mem 2x2048 OCZ Titanium DDR2-800 | Vid eVGA 9800GT | HDD WD 640GB - WD 1TB | PSU PC Power and Cooling 1000W | Cooling Thermalright Ultra eXtreme 120 | O/S Windows 7 Ultimate RTM, Slackware64 | Display Dell 2407 | Case Lian Li PC-V1000W Server/Work Rig... Mobo eVGA X58 LT | CPU Intel Core i7 950 | Mem OCZ 3x2GB DDR3-1600 | Vid eVGA GTS 250 | HDD 1TB WD Black | PSU PC Power and Cooling 750W | OS CentOS 64-bit LG 42" 1080p/120Hz - 360 - PS3 - Wii Gears of War 2, Demon's Souls, GTA:IV, Killzone 2, Resistance 2 |
|
|
|
| Sponsored Links - Guests Only | ||
|
|
|
10-30-09, 01:15 PM
|
#3 | |
|
Modded Word Warrior
Join Date: Dec 2002
Location: Alabama, Planet Earth
Posts: 25,874
|
Re: Migrating from SQL 2005 to SQL 2008
Quote:
__________________
Original translation: "The fool says in his heart, 'no, God'" Psalm 53:1 QFmfT™ ____________________________________________ ***Gaming Desktop*** ASUS Rampage II Extreme X58 · Intel Core i7 920 · *Modded* CoolIT Domino ALC · Corsair Dominator 6GB (Tri-Channel) · BFG GTX 285 SLI· WD 150 GB VelociRaptor · 2 x WD 1TB 32 MB Cache · Dell UltraSharp 2408WFP Monitor · Thermaltake Element V · Windows 7 Ultimate(64 bit) ***Work Laptop*** Dell Vostro 1720 · Windows 7 Ultimate(64 bit)· GeForce 9600m · 4GB RAM · 500GB Seagate Momentus 7200.4 HD PS3 username: DiscipleDOC Steam username: DiscipleDOC |
|
|
|
|
|
11-01-09, 05:32 AM
|
#4 |
|
I'm a Lagomorph.
Join Date: Aug 2004
Location: Coffs Harbour, NSW, Australia
Posts: 33,092
|
Re: Migrating from SQL 2005 to SQL 2008
You'll be k DOC.
__________________
 Credit Card, You can use it to open more then just a womans legs! ^_^ -|MagNuS| |
|
|
|
11-01-09, 07:15 AM
|
#5 |
|
plenty of work, no games
Join Date: Sep 2007
Posts: 549
|
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.6 + Asus P5Q Premium + 16GB RAM + 1xOCZ SSD 256GB + 4xWD Black 1TB RAID-5 on Adaptec 5805 + MSI GTX280 SuperOC + Dell 3008WFP + Windows 7 x64 Xbox 360 Elite + Onkyo receiver + Acoustic Energy Aelite 1/3/center speakers + 46" FullHD Samsung TV | PS3 Slim |
|
|
|
 |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
|
|
