Hi there, I'm a newbie and have just recently bought a license to use the program.
I'm experiencing some issues, probably because I'm still getting to know the program. I've googled and searched the forum but couldn't find anything. Anyways, here it comes:
I'm using the 5.9.2 version built on August 29th.
I'm trying to sync a MSSQL Server 2019 DB (already created) to the LLBL program. I have been able to reverse engineer it. Now I want to play with it (modifying it adding new fields, deleting others, creating tables, etc) but I'm struggling to find a way to persist this changes back to the DB. It's easier when I add things, but when I delete them, I just can't find a way for it to delete the fields or whatever I did on the DB as well! I have tried every possible combination on with the "Sync Relational Model Data" tool. Only once was I able to see one field that I had deleted, to be deleted on the DB. I then went on to repeat the process and it didn't do it. Am I missing something? What would be the correct step-by-step guide to, for example, create a new field on the entity-> persist it to the DB -> then delete it on the entity -> persist on the DB?
If you reverse engineer the model from the relational model data, the source of truth is the relational model , so when you then delete a field in the entity, it'll simply delete the entity from the entity, the unmapped target field will be simply unmapped. You have to switch the Sync Source for the model in the Sync tab to 'model' or 'mixed'. Once you do that, and then delete a field from the entity and sync the relational model, it'll mark the field in the table for deletion. You then have to export a DDL SQL script to export the DDL SQL to delete the field from the database.
I can't reproduce it, works fine here.
You might have set something differently. Please attach a repro case project and precise steps what you're doing so we can try to reproduce it. As this is a public forum, you can attach a new project that produces the problem, or open a new thread in the Helpdesk forum and refer to this thread so only we can see your project file.