I’m using a backup database to do some testing. This database already has data in it, but I would Like to add some additional data to it, possibly through a use rinterface and scripts. If everything works well, I want to add the data that I added to backup database to another database. I don’t want to have to do an export or Bulk Copy. It seems like to many steps. What I would rather have is just an insert statement the would crate the data.
The following links are for script that generate insert statements:
This one is very simple, but I needed to change nvarchar(…)s to nvarchar(Max).
Here are some more links generate insert script for sql server
http://vyaskn.tripod.com/code/generate_inserts.txt
http://www.nigelrivett.net/SQLTsql/sp_CreateDataLoadScript.html
http://www.nigelrivett.net/SQLTsql/sp_CreateDataLoadScript.html