Understanding Database Migration

If you want to migrate all configuration data and transaction data, you can use the native database utilities, export and import (or data pump) for Oracle (Performing a Full Accela Database Migration – Oracle), or backup and restore for SQL Server (Performing a Full Database Migration – SQL Server).


You can use this approach even if you do not want to include transaction data in your migration. If you do not have a lot of transaction data, it may be easier to delete the transaction data in your target database than it is to use scripts to only migrate configuration data.

After migrating configuration data, perform the post migration steps (Post Migration).