Copy Database Objects From One Database to Another
There are several methods for copying database objects and the correct authorization must be set up to create an object in the destination database.
Functions or External Procedures cannot be copied from one database to another. If
the specified database contains only functions or procedures and copying is done at
the database level,
No objects in database appears in the status bar.
When copying a table, only the table structure is copied. No data is copied.
Use the following procedures to copy objects from one database to another or copy objects.
To copy objects from one database to another using drag and drop
1 Select one or more specific objects from the grid area.
To select multiple objects, hold
Ctrl, and click with the left mouse button.
2 Hold Alt, and click with the left mouse button. Drag the objects from the grid area to the destination database, and then release the mouse button.
3 If confirmation of copy operations is requested on the options screen, click Copy or Copy All on the confirmation screen to complete the operation.
To copy objects using a dialog box
1 Do one of the following:
2 Click File>Copy Objects.
3 Do one of the following:
4 To complete the operation, click Copy or Copy All.