SQL Compare to script one database

knierim

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

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.