SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Tool to script database records?		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

SQLServerDBA_Dan
Aged Yak Warrior

USA
751 Posts
Posted - 08/18/2005 :  15:50:21  Show Profile  Reply with Quote
Is there a tool out there that will script the database records into "insert" statements?

I have a very tiny table (200-300 records) that needs to be sent to a very non-technical client and was hoping that I could find something that would script the data into a statement like so:

insert into tablex (col1, col2, col3) values ('data', 123, 'more')


Thanks,

Daniel
SQL Server DBA
www.dallasteam.com

tkizer
Almighty SQL Goddess

USA
35017 Posts
Posted - 08/18/2005 :  15:55:36  Show Profile  Visit tkizer's Homepage  Reply with Quote
http://vyaskn.tripod.com/code.htm#inserts

Tara
Go to Top of Page

Kristen
Test

United Kingdom
22191 Posts
Posted - 08/18/2005 :  16:06:35  Show Profile  Reply with Quote
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53420 (for N rows of data)
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73884
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73608

http://www.clrsoft.com/Content.aspx?Panel=ScreenShot

http://vyaskn.tripod.com/code.htm#inserts

http://www.nigelrivett.net/SQLTsql/sp_CreateDataLoadScript.html

Kristen
Edited by - Kristen on 06/20/2007 11:46:07
Go to Top of Page

SQLServerDBA_Dan
Aged Yak Warrior

USA
751 Posts
Posted - 08/19/2005 :  09:17:45  Show Profile  Reply with Quote
Danke

Daniel
SQL Server DBA
www.dallasteam.com
Go to Top of Page

mrak
Starting Member

1 Posts
Posted - 02/27/2006 :  00:23:48  Show Profile  Reply with Quote
Here is another tool that does the same and is integrated into SQL Server Management Studio: Aris-Soft Data Scriptor AddIn for SQL Server Management Studio http://www.aris-soft.com/products.html
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22469 Posts
Posted - 04/21/2008 :  08:37:06  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
quote:
Originally posted by mrak

Here is another tool that does the same and is integrated into SQL Server Management Studio: Aris-Soft Data Scriptor AddIn for SQL Server Management Studio http://www.aris-soft.com/products.html

I get "The page cannot be displayed error"

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11741 Posts
Posted - 04/21/2008 :  08:56:56  Show Profile  Visit spirit1's Homepage  Reply with Quote
or you can use the ssms tools pack add in which does the same thing
since it looks we're promoting stuff...

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000