General_9
General_9

Reputation: 2319

Generate script in SQL Server Management Studio

If I have a table with data in a database in SQL Server, how can I generate a script that will create the table and add the data too?

If I right click on the table then select Script Table As > Create to > File, that generates a script to just create the table without the data. What I need is a script that creates the table and adds the data that is already existing in the table or 2 separate scripts, one that creates the table and one that adds the data.

Upvotes: 45

Views: 92080

Answers (4)

Peter
Peter

Reputation: 1

Be aware that generating scripts (schema and data) does not export duplicate ROWS

Do a test (only need 2 columns and half a dozen rows) - I wondered what was happening - in the end it turned out to be a good thing in this instance

Upvotes: 0

KKDev
KKDev

Reputation: 160

Here You can see step by step process of Generate script in SQL Server Management Studio :

Step 1: Right Click on Your Database --> Select Task-->Generate Script..

Step 2: Select Next in Script Wizard

Step 3: Select Script Entire Database

Step 4:Choose Your File Name

and Finish

Now you can use your script file.

Upvotes: -1

Oleg Dok
Oleg Dok

Reputation: 21776

Use SSMS scripting feature (Rightclick on database->Tasks->Generate Scripts)

or

use SSMS Tools Pack

Upvotes: 1

Alex
Alex

Reputation: 6159

Here what you have to do:

  1. right click the database (not the table) and select tasks --> generate scripts
  2. Next --> select the requested table/tables (from select specific database objects)
  3. next --> click advanced --> types of data to script = schema and data
  4. next and finish

Upvotes: 109

Related Questions