Export database or tables to insert into statment

• Morten Cyren

  SSC Veteran

  Points: 261

  More actions

  November 5, 2004 at 8:18 am

  #163062

  Is this possible?

  I Want to export some tables to a sql script that insert into all values of the data in one table.

  //Morten

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  November 5, 2004 at 8:24 am

  #529113

  See if this helps:

  http://www.karaszi.com/sqlserver/info_generate_script.asp

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• Thomas-142793

  SSC Enthusiast

  Points: 151

  More actions

  January 31, 2006 at 12:57 pm

  #618000

  Try http://www.sqlscripter.com

  -Thomas