Reputation: 2319
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
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
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
Reputation: 21776
Use SSMS scripting feature (Rightclick on database->Tasks->Generate Scripts)
or
use SSMS Tools Pack
Upvotes: 1
Reputation: 6159
Here what you have to do:
Upvotes: 109