Tool to script database records? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Tool to script database records?

Author

Topic

SQLServerDBA_Dan
Aged Yak Warrior

752 Posts

Posted - 2005-08-18 : 15:50:21

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

38200 Posts

Posted - 2005-08-18 : 15:55:36

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

Tara

Kristen
Test

22859 Posts

Posted - 2005-08-18 : 16:06:35

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

SQLServerDBA_Dan
Aged Yak Warrior

752 Posts

Posted - 2005-08-19 : 09:17:45

Danke

Daniel
SQL Server DBA
www.dallasteam.com

mrak
Starting Member

1 Post

Posted - 2006-02-27 : 00:23:48

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 [url]http://www.aris-soft.com/products.html[/url]

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-04-21 : 08:37:06

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 [url]http://www.aris-soft.com/products.html[/url]

I get "The page cannot be displayed error"

Madhivanan

Failing to plan is Planning to fail

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-04-21 : 08:56:56

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources