Exporting SQL Server data to .sql file -- sql server dts

binoy
7/14/2004 11:53:02 AM

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

Allan Mitchell
7/14/2004 8:37:55 PM

[quoted text, click to view]

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

sql server dts : Exporting SQL Server data to .sql file