Generate a script in SQL Server 2005 with data

Question

Generate a script in SQL Server 2005 with data

How can I generate a script in SQL Server 2005 with data in a table?

+5

sql-server sql-server-2005 sql-server-2005-express

Bj patel Aug 3 '12 at 9:55

source share

4 answers

Bridge · Answer 1 · 2012-08-03T10:03:26+0000

Unfortunately, the script data parameters along with the schema were not displayed until SQL Server 2008, so I think you are stuck with third-party options.

The SSMS Tool Pack has an insert insert option
Narayana Vyays Kondreddy has an excellent generate insert script I have been using for several years

NG. · Answer 2 · 2012-08-03T10:51:59+0000

. :
http://blog.sqlauthority.com/2007/11/16/sql-server-2005-generate-script-with-data-from-database-database-publishing-wizard/

AmrMohallel · Answer 3 · 2013-07-13T03:22:05+0000

, , , script, .

, :

script (RightClick on Database > Tasks > > script )
(RightClick on Database > Tasks > Backup)

, :

script
[ ] > > .

, SQL Server 2005.

Jenond · Answer 4 · 2016-09-20T02:44:18+0000

Right click on the database. Then select "Tasks-> Generate Scripts" See image here

Then select the table or tables that you need to insert the script to create. see image here

Now click Next and click "Advanced" and select "Data Types in Script". see image here

Finally, next, next, you will get all your data in the insert scripts. Bye!

Generate a script in SQL Server 2005 with data

More articles: