Hi Sankhadeep,
Let me confirm I fully understand your request:
- You have your Outsystems data model created;
- Your Outsystems data model is different than your legacy system's data model;
- Your ultimate goal is to move some tables from your MySQL legacy system to Outsystems;
- At this point you want to replicate your Outsystems' model into MySQL.
Is that correct?
In my previous post I assumed your Outsystems database was running on MS SQL Server. If your are running on top of Oracle you cannot use MySQL workbench since it is not supported. So, let me break it down.
MS SQL Server
If your target database is running on top of MS SQL Server I recommend you to use MySQL Workbench. The documentation has a very comprehensive how-to. You can find there even the data type mappings between the two RDBMS. With MySQL workbench, as shown in the documentation, you can generate the DDL from your source database into MySQL format. In the end you'll be able to generate a mirrored Outsystems model into your MySQL database.
Oracle
For Oracle you can use migration workbench available with SQL Developer. I could not find a how-to as for MySQL workbench but the mechanics are the same.
NOTE: You may have better options, the tools I described are just one of the options. I have used both in the past on a few projects and both are really powerful.