Populating tables without comparing
I'm sure this has been asked before but I can't seem to find it. I'm often in a situation where I have a local copy of a database, and I want to generate a script that will populate another copy of the database with the data I have locally. But I don't want to have to restore a dummy database and compare the tables in the two databases to get the script.
I'd like to be able to point to the table and say "Give me a script that generates the data in this table." How would I do that with SQL Data Compare?