Export SQL as Insert Statements
Saturday, March 3rd, 2007Sometimes you just want to dump the contents of a database table as a series of insert statements. Many DBMSes can do this, in fact I do it with MySQL all the time. But it seems Microsoft SQL Server Enterprise Manager can’t do it. Oh you can export the create table statement. But that’s it. Why? It seems like a glaring omission. Almost like good old Microsoft is trying to make it as difficult as possible to migrate your data to another DBMS. So stupid. But we will always find a way… so I wrote an ASP script that’ll do what I needed. Here it is for you to use.
[Read More]