Exclude database in Mixed-Mode when generating SQL?

Posts   
 
    
Posts: 37
Joined: 09-Nov-2016
# Posted on: 30-Jan-2018 14:16:14   

Hi,

I am using 5.3 (5.3.2) RTM and have a combination of existing databases and a new one I am creating (so I am using Mixed-Mode). I need the existing databases in the project, because I am generating code to access them.

When I Right-click SQL Server (Sqlclient) and select Generate Database Schema Create Script (DDL SQL) from the context menu there does not seem to by any options to select which databases I actually want to create the SQL for.

The problem is that the generated SQL contains create statements for all databases, which is great for the new one I am designing but not so great for the already existing ones. The script obviously fails when trying to create the existing databases, but it feels weird trying to execute create database statements and assuming (and hoping) they fail. Therefore I am manually editing the script each time.

Is there any way to exclude them?

Best regards Andreas

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39613
Joined: 17-Aug-2003
# Posted on: 31-Jan-2018 11:08:50   

Not at the moment. We'll look into adding this in a future version.

Frans Bouma | Lead developer LLBLGen Pro
Otis avatar
Otis
LLBLGen Pro Team
Posts: 39613
Joined: 17-Aug-2003
# Posted on: 12-Feb-2018 16:01:30   

Implemented in v5.4

Frans Bouma | Lead developer LLBLGen Pro
Posts: 37
Joined: 09-Nov-2016
# Posted on: 12-Feb-2018 16:14:35   

That was quick simple_smile

Thank you!