Showing posts with label export. Show all posts
Showing posts with label export. Show all posts

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