Way of Working

Activity: Database migration

01 March 2021 • 1 minute

Written by Jordi Kitto

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.


Level of difficulty




Suggested time

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




  1. Create a new app on the platform and choose new legacy migration.


  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.


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.

Jordi Kitto

Written by Jordi Kitto

Software Developer

Jordi developed this very site you’re on right now! And when he’s not working on this site, he is showing off his latest Apple products to everyone in the office, or working on his side hustle