I have a need to dump a fairly significant number of Microsoft SQL Server databases to .sql files. I have a Unix background, and am used to using tools like mysqldump and pg_dump for MySQL and PostgreSQL respectively.
Is there an equivalent program that will do this. I'm well aware of the regular backup utilities – and I can't use them because I wish to do content search/replace on the SQL itself when importing these databases onto new servers. Thanks!
Best Answer
Have you considered using SSIS yet?
SSIS does the transofrmation of the data BEFORE loading it into the target system, hence avoiding a lot of read/write on the target system.
You can generate a SSIS package via sript or .NET code also.
Get started here: http://msdn.microsoft.com/en-us/library/ms141026.aspx