Sync database view

Posts   
 
    
chi
User
Posts: 3
Joined: 01-Oct-2019
# Posted on: 01-Oct-2019 20:54:19   

I recently migrated from v4.2 to v5.6. A new database view was created and I tried to perform a sync with the database to model the new view into LLBLgen Pro. However, even though I had selected the new view in the list it was not shown in the log or in the project explorer.

Any help would be appreciated.

Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 01-Oct-2019 21:21:43   

Does it show in the Catalog Explorer?

If yes, then all you need to do is to reverse engineer it to an entity or a TypedView, and then you would be able to see it in the project Explorer.

chi
User
Posts: 3
Joined: 01-Oct-2019
# Posted on: 02-Oct-2019 13:54:19   

I found a solution.

  1. In the Project Explorer Entities folder. I had to right click the folder and click Reverse Engineer View to Entity Definition.
  2. In the Project Explorer Typed Views folder. I could also right click the folder and click Reverse Engineer Views to Typed Views.

Is there a way for the Sync to do this automatically like in v4.2?
p.s. I inherited the v4.2 project and haven't working on LLBLGen Pro prior to migrating to v5.6.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39568
Joined: 17-Aug-2003
# Posted on: 02-Oct-2019 15:01:06   

Yes, in the project settings (right click the project node in project explorer -> Settings) go to 'Database First Development', then check the checkbox of 'Add new elements after relational model data sync'

Frans Bouma | Lead developer LLBLGen Pro