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

Subscribe to our news:
Partners
Testimonials
Mark Worsnop: "By the way I wanted to say thank you for a good software package. It's a pleasure to work with Maestro as it "just works" and makes my job that much easier".
Ron D.: "I'm still very happy with SQLite Maestro and Data Wizard; makes my HTPC database much easier to manage".

More

Add your opinion

Customers
Download Buy

SQLite Maestro online Help

Prev Return to chapter overview Next

Copy, Paste and Drag-n-Drop features

SQLite 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