Copy Database Objects From One Database to Another - Teradata Administrator

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:

In the grid area, select one or more specific objects.

In the database tree, select the database containing the objects to copy.

2 Click File>Copy Objects.

3 Do one of the following:

If this procedure is started by selecting one or more specific objects, define the destination database for the copy operation.

If this procedure is started by selecting a database, define the destination database for the copy operation, and then select the objects to copy.

4 To complete the operation, click Copy or Copy All.