Generating Inserts in SSMS
Hi, there are situations when you need to generate data scripts to insert that data into another database, and you do not want to do an SSIS package. There is an easy - but not so obvious - way to do it.
The first screens in the wizard are the same as when you generate the schema (CREATE TABLE) scripts. We are going directly to the screen where the setting is, we do not waist your time.
Step 1 - Select the "Generate Scripts" from the Database menu.
Step 2 - Open the "Advanced" screen.
Once you reached the following screen in the wizard, click on Advanced button.
Step 3 - Select the "Data Only" or "Schema and data"
And that's it, pum!!! you have generated the scripts for the selected tables.
I hope this tip has been useful for you.
Hasta la vista