How to generate scripts to recreate table using SQL Server Management Studio [Schema and data]?

sql-server ssms sql-server-2008
user763554 picture user763554 · Nov 23, 2012 · Viewed 61k times · Source

I have a table in a local SQL server database. I want to recreate this table in a hosted database.

What I want to do is to have a script that when run against the hosted database, this table is recreated with all the data, etc.

How do I create this script using SQL Server Management Studio? Thanks.

Answer

Mohammed Swillam picture Mohammed Swillam · Nov 23, 2012

1- Open SQL server Management Studio.

2- Right click on the DB that contains your desired table.

3- Select "Tasks => Generate Scripts...".

4- Follow on the wizard, and choose the objects that you want to generate scripts for (Tables, Views, Stored Procedures, etc... ).

5- From the next step, click on "Advanced", and for the node that is labeled "Types of data to script" choose "Schema and data".

enter image description here

6- Save your script and smile :)

Related questions

SQL Server 2008: how do I grant privileges to a username?

I need to be able to establish an ODBC connection through SQL Server authentication. In SSMS how do I grant permission for a user to be able to have ALL RIGHTS on a specific database? is there a way to …

Read More
How to drop all tables in a SQL Server database?

I'm trying to write a script that will completely empty a SQL Server database. This is what I have so far: USE [dbname] GO EXEC sp_msforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT all' EXEC sp_msforeachtable 'DELETE ?' When I run …

Read More
The request failed or the service did not respond in a timely fashion?

I have the following error while I connect to SQL Server 2008 Management Studio with Windows authentication. "The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details." …

Read More