Sign up for more way of working content

What's this?

Way of Working.

Activity: Database migration

1 minute read

Way of Working Title Image

The typical starting point for a new Codebots application.


A database migration is a typical starting point for a new application on the Codebots Platform. The steps described next will migrate your legacy database to a new application architected using microservices.

Before you start

You will need a copy of the database. If the database type you are migrating from is not yet supported, try exporting your database to a database schema in standard SQL.

Details

Level of difficulty

Moderate

Stage

Migrate

Suggested time

60 mins, depending the complexity of the security and administration you will be implementing.

Participants

  • Product owner
  • Business analyst

Materials

  • The Codebots Platform

Steps

  1. Create a new app on the platform and choose new legacy migration.
Image
  1. Inspect the Entity Diagram as described and repair the database if needed.
  2. Setup the security groups using the Security Diagram and lock down the Application Programming Interface (API).
  3. Setup the CRUD administration pages in the application using the Interface Diagram.
  4. The last step is to migrate any extra business logic and the process to follow is described in the justification. The business logic of the legacy database can usually be found in multiple locations including:

    • Forms (such as Microsoft Access forms).
    • Stored Procedures.
    • Views.
    • Custom Code.

Justification

There are some code analysis tools that could prove helpful to find the important sections of the code, but in our experience using automated tools to migrate between languages is not efficient due to the inescapable truth: garbage in, garbage out. So, roll up your sleeves and try to understand the code. Follow the process of Activity: Reverse Engineering Requirements and look at using extensions to cover the business logic. If the business logic is not covered by a extension, then you will need to create custom code.

Last updated: 04 March 2021


Related articles