Hello! I'm in the process of migrating our ERP solution from Oracle Forms to Oracle APEX. As part of this migration, I'm exploring the possibility of deploying our application on the cloud.
I'm considering setting up a development environment and a production environment on the cloud for our ERP solution. Each client's ERP instance will be hosted in their own workspace, connecting to their respective databases through a database link (dbLink).
I'm testing exporting the development app and importing it to each company's app in their own workspace. It worked because the dbLink redirects to the specific database depending on the workspace. Is this the correct way to handle development to production, by importing the entire app and replacing the older app with the new script? I tried exporting just a page, but it failed. According to the documentation, it seems that it's not possible with different workspace and application IDs.