SQL Compare to script one database

knierim · December 9, 2015 11:14AM

Since Red Gate retired SQL Packager, is it possible to script out the schema for a single database using SQL Compare? I'm guessing I could create a blank database and compare my database to the blank one effectively creating a script that would CREATE all of the objects. Any other way? I need a sql file and not an exe file otherwise I'd try to use the SQL Packager 8 utility.

Thanks,
Greg

Mark J · December 10, 2015 5:38AM

Yep, there's a new /empty2 option you can use: http://documentation.red-gate.com/displ ... ne-/empty2 which means you don't need to set up a blank database yourself.

SQL Compare to script one database

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk