Have Geek Brain

Defining Import / Export Tables Using SQLServer Management Studio

How do I import / export table definitions from my dev database to a production database (recreate the entire database). I have Sql Server 2005, Sql management studio with power wrapper.

Thanks in advance.

+2


a source to share


2 answers


You can make tables or an entire database.

For the table, go to the SSMS dev object explorer: right-click the table, click "Script Table As", then "Create To", then "clipboard" or "file". Paste the clipboard or open the file in a production SSMS query window and click f5

to run the script.



For the database, go to your SSMS Object Explorer: right-click the database, select Tasks, then Generate Scripts, then use the wizard to select all the objects to include (triggers, roles, schemas, stored procedures, tables, and etc.) save this to a file and then open the file in an SSMS query window and click f5

to run the script.

+3


a source


You can generate the SQL required to recreate the database by right-clicking the database node in the Studio Studio Object Explorer and choosing Script Database As | Create for | ....



0


a source






More articles:


All Articles