How do i update synchronise the schema of a project after updating my database

Posts   
 
    
gemfore
User
Posts: 35
Joined: 30-Jul-2010
# Posted on: 09-Dec-2010 19:03:40   

I appreciate this is a real novice question but since upgrading to 3.0 im having difficulty updating my project automatically with by db.

So say for example i've deleted a table, and/or added fields to another? how do i tell the project in this new designer to say automatically update / sync like i used to in 2.6?

Thanks Gemfore

MTrinder
User
Posts: 1461
Joined: 08-Oct-2008
# Posted on: 09-Dec-2010 21:39:14   

Expand the "Relational Model Data" node in the explorer tree view, right click the database in question, and select "Refresh Relational Model Data.."

Or did you mean something more involved...?

Matt

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39908
Joined: 17-Aug-2003
# Posted on: 10-Dec-2010 19:06:18   

Also check the settings in the project properties, there are settings which define whether new fields should be added etc.

Frans Bouma | Lead developer LLBLGen Pro
gemfore
User
Posts: 35
Joined: 30-Jul-2010
# Posted on: 14-Dec-2010 11:24:36   

Thanks for your reply but when i do that it only appears to give me the option to generate an export script?

Sorry if i'm being a bit slow here, but i'm i right in assuming that this updates the db to match the project and not the project to match the db?

MTrinder
User
Posts: 1461
Joined: 08-Oct-2008
# Posted on: 14-Dec-2010 20:39:51   

Have you, inside the project, made changes to the entities which would require schema changes to the database? The designer does this when it detects that the entity schema is out of sync with the db schema.

Matt