Table of Contents Previous Next


7 Migration Toolkit Command Options : 7.1 Offline Migration : 7.1.1 Executing Offline Migration Scripts

You can use the edb-psql command line (on Advanced Server) or psql command line (on PostgreSQL) to execute the scripts generated during an offline migration. The following example describes restoring a schema (named hr) into a new database (named acctg) stored in Advanced Server.
1.
Use the createdb utility to create the acctg database, into which we will restore the migrated database objects:
3.
Use the \i meta-command to invoke the migration script that creates the object definitions:
4.
If the -offlineMigration command included the ‑singleDataFile keyword , the mtk_hr_data.sql script will contain the commands required to recreate all of the objects in the new target database. Populate the database with the command:

7 Migration Toolkit Command Options : 7.1 Offline Migration : 7.1.1 Executing Offline Migration Scripts

Table of Contents Previous Next