SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 SQL Server Database to Script?
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

davidshq
Posting Yak Master

USA
119 Posts

Posted - 11/19/2005 :  01:52:46  Show Profile  Visit davidshq's Homepage
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)

USA
7020 Posts

Posted - 11/19/2005 :  02:52:52  Show Profile
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
Go to Top of Page

davidshq
Posting Yak Master

USA
119 Posts

Posted - 11/19/2005 :  11:38:56  Show Profile  Visit davidshq's Homepage
Thanks.

- http://www.civilwarsearch.com/
- http://www.thehungersite.com/
- http://www.grid.org/
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000