Hi,
1.
---
NEW FUNCTIONALITY FOR SCHEMA:
Right click on schema node provides three new functionalities
- Copy tables
- Copy table(s) from the list
- Paste table(s)
"Copy tables" provides copying all tables from the schema.
"Paste table(s)" on target schema will create new table(s) in target schema.
New table(s) in target schema can be created with the same or new name(s).
If name of source table exists in target schema then dialog for table
name change will pop up and suffix for name should be added.
Copy table(s) from the list provides copying selected table(s) from
one or more schema on same or different server(even not connected -
connection will be done automatically).
NEW FUNCTIONALITY FOR TABLES
Right click on table node provides three new functionalities
- Copy table
- Copy table with optional select clause
- Copy table(s) from the list
"Copy table" provides copying of one table.
With "Copy table with optional select clause" provides copying table
with filter option
if only some data from the table should be included in new table.
"Copy table(s) from the list" has the same functionality as the "Copy
table(s) from the list" in schema.
Paste table(s) has to be done on target schema.
With Copy-Paste functions all table characteristics will be copied,
that includes table definitions, constraints and data.
Best regards
Vladimir Kokovic
Belgrade, Serbia, 21.October 2012
