What I need to do is dump out the structure AND data of an MSSQL database as SQL scripts (DDL and a series of Insert statements). The first is easy, the second is not supported within enterprise manager, and seems rather harder than I imagined, especially as mySQL has this very useful technique built in.

Any pointers on tools/code that could help would be much appreciated, note in our instance we have are using GUID keys and Blob fields extensively, so a basic int/varchar dump wont do the necessary. Assuming there is something out there that will help, then a really nice feature would be the ability to dump in SQL format for different targets - Oracle, DB2, MSSql and mySQL would be a good starting point.