Script table + data

Jordan_B

I'm wondering if there's a quick way to script a table and its data without doing a full-blown compare against an empty folder...

I'm thinking like in SSMS, right-click the table, Script Table As > Create to > File ... but also include the script to insert all the rows into the new table.


Is this a feature in SQL Compare or Data Compare that possibly I've overlooked?

AlessandroAlpi

hi @Jordan_B,
not by design. But you can automate the process using the command lines as described here:

• SQL Compare command line
• Sql Data Compare command line