Merging two databases

To merge two databases on the source Adaptive Server into one database on the target Adaptive Server, use the following procedure.

Set up and migrate the first database.
After migrating the first database, rename the target database so that it has the same name as the second source database.
Set up and migrate the second database.

You cannot migrate the database data for the second database because the users, roles and other database data already exist on the target database.