Postgres as a Service
Deploy a Managed Postgres Cluster in Minutes! Enterprise-ready and Oracle compatible.
3.4 Data Migration
2. Configure the toolkit.properties file; ensure that connection information for the source and target databases is available in the property file:
10. Invoke Migration Toolkit in –dataOnly mode; include the –truncLoad keyword to resolve foreign key dependencies across tables.The command migrates the specified source_schema to the target_schema. The data is loaded into the locally installed EDB Postgres instance with a database superuser named enterprisedb and the password as password.Please Note: The tables are truncated before attempting the data load.