41.11 Table's Utilities

HoneyMonitor gives you some tools to do utility operations on tables, like copy a table or move it from a database to another.

41.11.1 Copy Table Wizard

The Copy Table Wizard allows you make a copy of a table, i.e. re-create that table with another name in the same database or in another database; the destination database must exist.

To open the Wizard (Fig. 41.91) click on the ''Database Objects / Tables / Table's Utilities'' or use the popup menu of the Server Objects List (chap. 16).

See Also:

•  41.11.2: Move Table Wizard
•  41.1: Create Table Wizard
•  41.10: Table's Maintenance
•  41.9.4: Partition's Maintenance

To copy a table:

1. choose the origin database;
2. choose the origin table;
3. choose the destination database;
4. choose the destination table name (by default, the same name as the origin);
5. click on the ''Execute'' button.

Note: A complete copy will be done (structure and data).

41.11.2 Move Table Wizard

The Move Table Wizard allows you to move a table from a database to another (of the same filesystem); the destination database must exist.

To open the Wizard (Fig. 41.91) click on the ''Database Objects / Tables / Table's Utilities'' or use the popup menu of the Server Objects List (chap. 16).

See Also:

•  41.11.1: Copy Table Wizard
•  41.1: Create Table Wizard
•  41.10: Table's Maintenance
•  41.9.4: Partition's Maintenance

To move a table:

1. choose the origin database;
2. choose the origin table;
3. choose the destination database;
4. choose the destination table name (by default, the same name as the origin)
5. click on the ''Execute'' button.

Note: A complete move will be done (structure and data).

---

Copyright © 2007 - 2009 HoneySoftware - All Rights Reserved

Submit feedback on this topic.