Create a database script.

[prw]

I'm trying to use SQLCompare to create a script of a current database but don't appear to be able to get it to work to produce the script as one script rather than all the objects as an individual script for each object.

There doesn't appear to be any option to make this possible ?

[james.billings]

Thanks for your post.

If you're using the "make scripts" option, this is to create a set of scripts that represent a database for further comparisons.

If you compare to a blank database, then it will generate one script to create all the objects; but the database needs to exist to begin with. There's nothing to stop you editing the generated script to include the create database command at the beginning though.

Depending on what you're trying to achieve, you may also want to look at SQL Packager - this can generate an .exe you can run to create a database.