Script table + data
Jordan_B
Posts: 1 New member
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?
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?
Tagged:
Answers
not by design. But you can automate the process using the command lines as described here:
CTO @ Engage IT Services s.r.l.
Database Administrator and Team Leader
Microsoft MVP - Data Platform
Staff member of getlatestversion.it community
personal website | blog