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 |
|
davidshq
Posting Yak Master
119 Posts |
 Posted - 2005-11-19 : 01:52:46
|
| I was wondering if there is any easy way (or software) to take a currently existing database (in this case a SQL Server Express db) and export it to a script which could then be used to recreate the database? Or even to create and recreate select tables from that db?David.- http://www.civilwarsearch.com/- http://www.thehungersite.com/- http://www.grid.org/ |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-11-19 : 02:52:52
|
| Connect to the database server with SQL Server Enterprise Manager, open the Databases list, right-click on a database, select All Tasks, and then select Generate SQL Script... In the Generate SQL Scripts dialog box you can select some or all of the database objects to create scripts for.CODO ERGO SUM |
 |
|
|
davidshq
Posting Yak Master
119 Posts |
|
|
|
|
|
SQL Server Database to Script?