Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Ilakshi Rathod : "This tool is just wonderful. I have never seen any tool for DB2. This tool provides very good features which helps in ease us work as well as quick resolution of any errors.".
Jeff Rule: "I have to tell you I am really impressed. I have never had a software company turn around a bug fix like this so fast. I have been doing database work for over 20 years and that has never happened.".

More

Add your opinion

SQL Maestro Group / Products / DB2 / DB2 Maestro / Documentation

DB2 Maestro online Help

Prev Return to chapter overview Next

Copy, Paste and Drag-n-Drop features

DB2 Maestro provides you with an ability of copying database objects within the database or even from one database to another (in this case you should connect to both the source and the destination databases first).

 

To copy an object, just drag the object in a source window (such as Database Explorer, Object Manager, Object Browser) and drop it to the target container in another window. You also can use the Edit | Copy and the Edit | Paste main menu items or the Ctrl+C/Ctrl+V hot keys combinations respectively. Copying several objects at a time is also available.

 

It is also possible to drag and drop objects between Database Explorer, Object Manager, Object Browser and SQL Editor or SQL Script Editor. This works as follows:
 

SQL Editor: after dropping the object you will get a query to retrieve object data (e.g. SELECT * FROM table_name) or the full name of the object if it doesn't contain data (domains, indexes, etc.).
 
SQL Script Editor: after dropping the object you will get its SQL definition if applicable.

 

See also: Database Explorer, Object Manager, and Object Browser

 



Prev Return to chapter overview Next