13. Migrating to a Different DBMS

PROBLEM

There are circumstances where an application needs to be migrated to a different database management system (DBMS). For example:

SOLUTION

If an application is using standard JPQL and/or SQL, the application can be deployed to a different DBMS by changing the database connection. In the case of Skyway Builder Standard Edition you can also change JPA providers.

HOW IT WORKS

A Skyway data access object determines the database it's going to use by the configured DB connection. The underlying database can be changed by creating a new DB connection and reconfiguring the data access objects to use the new DB connection.