SQL: How do I port sql server database via t-sql scripts

Question

I have to port sql server (2008) database with t-sql scripts. I can generate "create" script per each database object (stored procedure, table) from Sql Server Management Studio (though it looks to take much time)

How do I port data for tables? I'd like to have scripts like that:

INSERT INTO ... VALUES(...)
INSERT INTO ... VALUES(...)
INSERT INTO ... VALUES(...)
...

Can I generate such scripts from Sql Server Management Studio or is there some free 3'rd party utility for that? (I guess there should be).

Thank you in advance!

possible duplicate of Get script of SQL Server data

codingbadger
– codingbadger

2011-06-15 10:25:24 +00:00
Commented Jun 15, 2011 at 10:25 — codingbadger
– codingbadger, Commented Jun 15, 2011 at 10:25

Alex K. · Accepted Answer · 2011-06-15 10:25:19Z

2

The (free) SMSS Tool pack addin can generate insert scripts for a DB.

answered Jun 15, 2011 at 10:25

Alex K.

177k32 gold badges276 silver badges299 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ben Thul · Accepted Answer · 2011-06-15 12:17:50Z

1

If you're going to be doing bulk inserts of data, I'd suggest using bulk insert. You can do the insert from T-SQL, but I prefer to use the bcp command line utility as I can do both the export and import with minimal change to the run line. Oh... and it runs a lot faster than a bunch of insert statements. Have a look at the documentation and see if it fits your purposes.

answered Jun 15, 2011 at 12:17

Ben Thul

32.9k4 gold badges52 silver badges74 bronze badges

Collectives™ on Stack Overflow

SQL: How do I port sql server database via t-sql scripts

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related