1. Migrating Oracle Visual Builder Classic Instances to Oracle Cloud Infrastructure
  2. Complete the Post-Migration Tasks

4 Complete the Post-Migration Tasks

After you create the instance on Oracle Cloud Infrastructure and import the design-time metadata, you can import the application data of live applications. Lock the live application on the classic instance and import the live data to the new application before republishing it on the new instance on Oracle Cloud Infrastructure.

Topics:

Migrate a Live Visual Builder Application

Any applications on the Oracle Visual Builder Classic instance that are live will need to be staged and published again after they are migrated to the new instance on Oracle Cloud Infrastructure.

Developers can lock a live visual application to prevent changes to live application data, and then import the live data to the new version of the application on Oracle Cloud Infrastructure. After the live data is imported and the application is published, users can be instructed to use the new version of the live app. For users who access a web application, you’ll need to communicate the new URL that replaces the URL they used previously to access their web applications. For mobile applications, you’ll need to rebuild and republish your mobile apps to the app store(s) where you initially published it or use whatever mechanism you used previously to distribute the mobile app. Do this so users can update the mobile app on their device to a version of the app that was built using Oracle Visual Builder on Oracle Cloud Infrastructure.

Export Application Data From the Live Database

You can export all the data contained in your database as CSV files. The export tool creates one CSV file for each of the custom business objects in your database and packages the files as a ZIP archive.

To export the database data as a CSV file:

  1. Open the Oracle Visual Builder Classic instance.
  2. On the Visual Applications home page, open the visual application and open the Business Objects pane in the Navigator.
  3. Click the Options menu in the Business Objects pane and select Data Manager.
  4. Select the Live database in the dropdown list.
  5. Click Export All Data to download a ZIP archive that contains CSV files with the data.

You will import the zip archive into the Live database of the published app on the new instance on Oracle Cloud Infrastructure.

Lock the Live Visual Builder Application

If you are migrating an application that is a live application, you can lock the live application to prevent any users from using the application while you migrate it to your new instance.

To lock an application:
  1. Open the Oracle Visual Builder Classic instance.
  2. On the Visual Applications home page, open the Application Options menu for the live application you want to lock and select Lock.
  3. Click Lock in the Confirm Lock Application dialog box.

    On the Visual Applications home page, the status of the app is now Live Locked.

Users are not able to use the app to edit data while it is locked.

Import the Live Application Data into the New Application

You can populate the database of your new visual app with the live data exported from your application on the Oracle Visual Builder Classic instance.

You can import the archive containing the Live data into the Development, Staging or Live database of your new application, and then include the data when you stage or publish the app. For example, if your app is staged but not yet published, you can import the Live data into the Staging database and then publish the app, making sure that you select Include data from Stage in the Publish Application dialog box.

To import Live data into your application's database:

  1. Open the new Oracle Visual Builder instance on Oracle Cloud Infrastructure
  2. On the Visual Applications home page, open your visual application and open the Business Objects pane in the Navigator.
  3. Click the Options menu in the Business Objects pane and select Data Manager.
  4. In the Database dropdown list, select the database that you want to import the Live data into.

    The options available in the Database dropdown list depend upon if you have staged or published your application. If your application has not been staged, you can only select Development in the dropdown list.

  5. Click Import from file.
  6. Drag the archive with the CSV files into the drop area in the Confirm Import Data dialog box. Click Import.
  7. In the Import from File dialog box, confirm that the data was imported successfully. Click OK.
You can confirm that the data was imported successfully in the Business Objects editor.

Publish the New Application with the Live Application Data

You can publish a staged version of your application from the Home page or from the main menu. After you publish a version of an app it is read-only and can no longer be changed. To make changes to update the app you need to create a new version.

To publish the application:
  1. Open the new Oracle Visual Builder instance on Oracle Cloud Infrastructure
  2. On the Visual Applications home page, open the Application Options menu for the application version you want to publish and select Publish.
  3. For web applications, communicate the URL that end users must now use to access the web application(s) that you have published.
  4. For mobile applications, update the app store with an instance of the app that you have just published so end users can update their installation with the newer version of the app that has been built using Oracle Cloud Infrastructure.