|
 These settings control
the situation when you select the root node of the
schema tree and command the program
to script the entire schema.
Generate
CREATE/ALTER DATABASE option enables scripting
on the database level itself. When this option is checked and
CREATE scripts are generated for the whole schema, they will start
with CREATE DATABASE statement. When an update script is being
generated, it may include ALTER DATABASE to synchronize names,
filegroups and various options of the two databases. By default it
is assumed that both databases are already in place and their
names, filegroup allocation and properties don't require any
synchronization.
With "Produce
only CREATE DATABASE", the program will only
script database-level information when you select the root node of
the schema: CREATE/ALTER DATABASE, database options, db-level
extended properties and statement permissions. To script tables,
views and other objects you would have to select appropriate
sub-nodes of the schema tree.
Set
database options. Here you can choose
exactly which of the database-level options the program should take
into account generating a CREATE or UPDATE script. The options can
be scripted using either "ALTER DATABASE ... SET ..." syntax or by
calling sp_dboption.
Do not
script users... It may be a common
situation when users defined on a development server and on a
production server are different and do not require synchronization.
This options tells the Diff that when the schema root is selected
for scripting, the SQL for creating or otherwise synchronizing the
users should not be included in the script.
|
