|
An easy way to generate
SQL for the whole schema or specific parts of it is just to drag
the relevant nodes of the schema tree to any text editor
understanding OLE drag-n-drop. Several nodes of the schema tree can
be selected by holding Ctrl
or
Shift
keys, as
usually.
The SQL code dropped into
the target window depends on whether you are viewing one or two
databases, on the combination of Shift, Control and Alt keys and on
the target window itself. This might sound complicated, but in fact
the logic was designed to be very simple and intuitive, so most of
the time you are getting just the right kind of SQL with minimal
mental efforts. And all the time you are dragging the data, one of
the special drag cursors indicates the operation to be
performed.
One
database is open, there is no comparison.
When you drag&drop, the resulting script would either CREATE or
DROP the selected objects. By default, CREATE statements would be
generated. Holding any of the SHIFT, CTRL or ALT key switches to
DROP statements:
|
Keys
|
Cursor
|
Action
|
|
|
|
Generate
CREATE statements
|
|
[Shift],
[Ctrl] or [Alt]
|
|
Generate
DROP statements
|
Comparing
two databases. When you are viewing
the merged results of comparing two databases, the drag&drop
can produce the CREATE, DROP or the difference SQL for the selected
item(s). Besides, you can choose either of the databases for
CREATE/DROP or choose the direction of synchronization for diff
scripts. This gives you 6 combinations:
|
Keys
|
Cursor
|
Action
|
Reversed
action
(with
[Shift] key pressed)
|
Cursor
|
|
|
|
Generate
CREATE statements from the
left-hand database
schema
|
Generate
CREATE statements from the
right-hand database
schema
|
|
|
[Ctrl]
|
|
Generate
difference script to be applied to
right-hand DB
to synchronize it with the
left-hand one.
|
Generate
difference script to be applied to
left-hand DB
to synchronize it with the
right-hand one.
|
|
|
[Alt]
|
|
Generate
DROP statements from the
left-hand database
schema
|
Generate
DROP statements from the
right-hand database
schema
|
|
Dropping
to Code Viewer window. If there is no
connection selected in the Target combo box, the drag&drop
operates as described above. Otherwise, the currently selected
Target is taken into consideration. Note that certain combinations
in the table below are grayed out. It means that sending that kind
of SQL to that target connection does not make sense and/or might
not work (like applying "CREATE" SQL to either
of the DBs
being compared):
|
Keys
|
Cursor
|
Action
|
Reversed
action
(with
[Shift] key pressed)
|
|
|
or
|
Generate
difference script to be applied to the DB
selected in
the Target combo-box to synchronize it with the
other database.
|
Generate
difference script to be applied to the
other DB
to synchronize it with the
selected one.
|
|
[Alt]
|
or
|
Generate
DROP statements from the database
selected in
the Target combo-box
|
Generate
DROP statements from the
other database
|
|
[Ctrl]
|
or
|
Generate
CREATE statements from the
other database
schema.
|
Generate
CREATE statements from the
selected database
schema
|
When some SQL is dropped
to the CodeView without
a selected
target, the selection is made automatically, if
possible:
|
Operation
|
New
target
|
|
or
|
Left-hand database
|
|
or
|
Right-hand database
|
|
