I'm looking for a way to export SQL Server 2008 (Express or otherwise) databases to CREATE/INSERT statements. ÃÂ I've seen a million threads (give or take) with instructions for creating large (often illegible) TSQL scripts for the task. ÃÂ However, I'm hoping that this isn't the only way by which to do it. ÃÂ I have need to regularly back up the data from existing MS SQL Server DBs (which are used by some of our standard apps) to various other MySQL and PostgreSQL databases (which are used by PHP and Rails web front ends). ÃÂ I need to export them from MS SQL Server 2008 to a general format (i.e. INSERT statements) and perform regex edits on the file as necessary.
FYI, I've written a few applications that connect to the various DBs over ODBC, etc. and transfer the data row by row. ÃÂ You can image how painful this process is...
I realize that there are many tools that do this. ÃÂ However, most of them approach the issue from the standpoint of migration, and not that of regularly scheduled backups. ÃÂ Also, this tool will need to eventually be distributed so having to purchase a license for the migration app for each person/group simply isn't feasible.
Anyway, if you guys have a quality, straightforward solution to this issue, it would certainly be appreciated.
View Complete Post