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:
2. Connect to the new database with edb-psql:
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: