Two databases

Posts   
 
    
florisotto
User
Posts: 4
Joined: 04-Aug-2021
# Posted on: 04-Aug-2021 08:49:17   

Hello,

I'm not sure if this is the correct section to put this question but here we go;

We currently have a llblgen project which generates code for our MSSQL database. Now we are building a separate MySql database which contains a different set of tables as the MSSQL database.

What is the recommended approach for using these two databases with llblgen? Have a single llblgen project with two relational model data, or have two single llblgen projects? I ran into an issue that entities need to be mapped to both databases when adding the MySql database to our existing llblgen project. But that won't be the case for us, as we have separate tables in the databases that don't correspond with eachother.

Kind regards, Floris Otto

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39760
Joined: 17-Aug-2003
# Posted on: 04-Aug-2021 09:10:06   

Every project has 1 entity model which can be mapped to multiple databases (and types). This means that if you add meta-data for multiple database types, the entities have to be mapped to both.

So if your mysql database has different tables representing different entities than the ones in the SqlServer database, I'd create a new project for the mysql database, as they're separate from the mssql database.

Frans Bouma | Lead developer LLBLGen Pro
florisotto
User
Posts: 4
Joined: 04-Aug-2021
# Posted on: 04-Aug-2021 13:59:30   

Thanks for your reply Otis!