Vote for insertXpress
insertXpress automatically generates INSERT scripts for Microsoft SQL databases. If you need to transfer data between similar tables in different databases, then insertXpress can help you do this.
An insertXpress INSERT script contains all of the data that you have selected from the source database. Just run it on the target database and it inserts the data automatically. You can append the transferred data, replace the existing data with it, or use it to update existing data (matched using the identity field).
A single insertXpress INSERT script, generated all at once, can contain data from several databases on several servers. insertXpress generates scripts from tables or views or a combination.