June 21, 2010 at 10:25 am
Greetings all. I'm kind of new to 2008, and I've never done this, so I thought the newbie section is appropriate. I just got a new laptop at work, and I need to transfer everything from my old one, including my testing SQL 2008 database. Once I have 2008 installed on the new machine, can I simply copy and past the contents of "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL" into the same location on the new machine? That seems a little to simple. I have create scripts for all the views and procedures, so I am mainly only concerned about building the tables without having to script all of them. Thank you.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
June 21, 2010 at 10:29 am
Is it just databases? Meaning do you have jobs, other server/instance level stuff?
You don't want to copy over master typically since it has local paths and machine specific settings, including the instance name.
The way you move databases is to detach them, copy the md/ldf/ndf files, and attach them.
For logins, search sp_help_revlogin and use that to script them, then run the script on the new laptop.
If you have packages, other stuff, it gets more complicated. I might backup msdb and restore it on the new instance. It depends here on what you have configured.
June 21, 2010 at 1:03 pm
Thanks Steve. Nothing but tables for this database.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply