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 |
|
aggiekevin
Starting Member
14 Posts |
 Posted - 2007-08-29 : 23:54:00
|
| Howdy all,I am still relatively new to SQL Server and what I need to do is script out my database schema so that I can put it on my laptop (so I can continue developing while out of town). I have just backed up the db in the past and copied it to my local machine, but the backup file is ~2GB now and since I don't need all the data I would rather not spend the time copying that large of a file. How can I script out my entire database and then run the script on another machine to set everything up? I've looked online and some of the explanations I have found were confusing. So if anyone knows a simple way or a link to a good, clear tutorial I would be most appreciative.Thanks! |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-08-30 : 00:06:30
|
use SQL Server Management Studio, right click on your database, Script Database
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
aggiekevin
Starting Member
14 Posts |
Posted - 2007-08-30 : 01:07:45
|
| Wow, that was simple. Worked like a charm...thanks! |
|
|
|
|
|
|
Scripting out the DB schema