Stored proc to export as INSERT queries

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 2005 Forums

Transact-SQL (2005)

Stored proc to export as INSERT queries

Author

Topic

timclaason
Starting Member

1 Post

Posted - 2007-10-17 : 22:49:35

PHPMyAdmin has functionality to export a database as a series of queries (CREATE TABLE, INSERT INTO...).

Does anyone know how I could do a stored proc (or perhaps an already-written tool that does this for me)?

Thanks in advance.

Kristen
Test

22859 Posts

Posted - 2007-10-17 : 23:37:06

SSMS will do the DDL Create Table etc. stuff for you.

For insert statements see: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=generate+INSERT+statement+script

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources