[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 198
  • Last Modified:

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

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);
0
jormillan
Asked:
jormillan
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
there is actually no direct way, but can be done with the following procedure


http://vyaskn.tripod.com/code/generate_inserts.txt
0
 
floyd99Commented:
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

0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now