Wednesday, October 27, 2010

Exporting from SQLServer to SQL insert script

The problem:
Export data from an MS SQL server to an SQL script of insert statements

It appears that there is no built in option for performing such a simple a task. After all, SQL is the common protocol for SQL based databases.

What i did manage to find is a script (stored procedure) for SQLServer 2000 and SQLServer 2005
The original post and instructions are available here.

Good luck

No comments:

Post a Comment

Please do not post spam on this blog, Spam sites will be reported to google.
thank you kindly.