We help IT Professionals succeed at work.

How do I export data from my tables to a sql file(syntax)?

jormillan
jormillan asked
on
I have always use Sybase products and there is an excellent feature in ASA/ASE "Save Rows as...", this allow you to save your data in SQL syntax so you can insert rows directly from the file. I have not seen an option where I can directly save my rows in sql syntax. I am relatively new in MS SQL Server can anyone please tell how can I save the rows from my table in sql syntax?

i.e:  INSERT INTO balance VALUES ('0099', 2500);
       INSERT INTO balance VALUES ('0099', 2520);
       INSERT INTO balance VALUES ('0089', 2870);
       INSERT INTO balance VALUES ('0087', 4890);
Comment
Watch Question

AneeshDatabase Consultant
CERTIFIED EXPERT
Top Expert 2009

Commented:
there is actually no direct way, but can be done with the following procedure


http://vyaskn.tripod.com/code/generate_inserts.txt
Commented:
easy.  use the Database Publishing Wizard.  this lets you extract data out into sql scripts. great for moving a 2005 database back to 2000 !

http://www.codeplex.com/sqlhost/Wiki/View.aspx?title=Database%20Publishing%20Wizard&referringTitle=Home

Explore More ContentExplore courses, solutions, and other research materials related to this topic.