Hello,

Please ignore if this is a beginner question for this group, since I am into web development. I remember seeing data transferred from SQL Server tables into .sql files.

I know how to export a table structure into a .sql file, which can be executed on any other databases to create tables of similar structure. Is it possible to transfer data into .sql file, which will create each record with 'insert' statements that can be executed on any similar table on a different database?

Thanks
-Binoy

In article <B6C793FF-0A83-4C82-9639-A16CF94D4701 (AT) microsoft (DOT) com>, Binoy wrote:
I believe my friend Vyas has a solution for you

http://vyaskn.tripod.com/code/generate_inserts.txt


Also I believe Red Gate software also have a SQL packager tool that does htis and they are IMHO very good.


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
www.konesans.com - for all your consultancy needs