Ways to Copy and Relocate a Database

Database locations can be moved, for example when a disk fills or is swapped out. You can also copy an entire database. Any location in the original database can be moved to a new location in the new database.

To do this in VDBA, use the Duplicate Db menu. For the detailed steps for performing this procedure, see the online help.

You can also accomplish this task using the relocatedb command. For more information see the Command Reference Guide.

Example: Copy a Database to a New Database

The following series of operations copies the empdata database to a new database, empdev:

1. In a Database Object Manager window in VDBA, select a database (empdata).
2. Choose Database, Duplicate Db.

   The Duplicate Database dialog appears.

3. In the New Database edit control, enter the name of the new database (empdev).
4. Click OK.

Example: Copy a Database to a New Database and Use New Locations

The following example copies the empdata database to a new database, empdev, and specifies the new locations—empdat1 and empdat2—for the existing ii_database and edata locations:

1. Follow Steps 1–3 in the Example: Copy a Database to a New Database.
2. Enable the Reassign Location check box.

   The locations that are currently being used by the empdata database (ii_database and edata) are displayed in the Initial Location column.

3. In the New Location column, double-click on the location to be changed and select the new location from the drop-down list box that appears.

   For example, double-click on the ii_database location in the New Location column and select empdat1. Change the edata location to empdat2.

4. Click OK.

Example: Copy a Database to a New Database and Swap Contents of Locations

The following example copies the empdata database to a new database, empdev, and swaps the contents of the locations ii_database and loc1 in the new database:

1. Follow Steps 1–3 in Example: Copy a Database to a New Database.
2. Enable the Reassign Location check box.

   The locations that are currently being used by the empdata database (ii_database and loc1) are displayed in the Initial Location column.

3. In the New Location column, double-click on the location to be changed and select the new location from the drop-down list box that appears.

   For example, double-click on the ii_database location in the New Location column and select loc1. Change the loc1 location to ii_database.

4. Click OK.