Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bryan42
Starting Member
28 Posts |
 Posted - 2007-03-27 : 11:07:19
|
| What's a good way to download five SQL Server 2005 databases from production to my laptop for development work with Visual Studio? Our application code is under source control, but to have a current development environment I must keep downloading these databases. Four databases are small, but one will need to be trimmed to about 10% of actual size to fit on my laptop's hard drive.Looking at options in the Management Studio by right-clicking on each database, I see options to export the data, create a backup. Or, am I making this too hard and the easiest way would be to download some backups of the database created by the maintenance plan and use those to restore them on my laptop? |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
bryan42
Starting Member
28 Posts |
Posted - 2007-03-27 : 11:45:54
|
| Yes, SQL Server 2005 and Visual Studio 2005. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2007-03-27 : 11:48:41
|
| Have you started the services yet?SQL Server is going in direct competition with you for resources..Anyway, just dump the databases, zip them and copy them..For the one you want to reduce to 10%, you're gonna have to do it, AND Worry about RI....how big is this database?Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
bryan42
Starting Member
28 Posts |
Posted - 2007-03-27 : 12:36:01
|
| The big database is 37GB. My laptop has just under that amount free on the hard drive, so 10% should be fine. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-03-27 : 12:42:24
|
| Is the 37G data and log and does it have single data and log files? If so maybe you can copy the .mdf and attach it and it will create a small .ldf hopefully.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Best way to download DBs to laptop