With modelDBA, you can easily make the changes you need to the database directly using the user interface. modelDBA can handle all the changes you’d expect. Add, rename or drop tables. Add, alter or drop columns and constraints. You don’t need to worry about the SQL required, it’s all taken care of for. That time you would have spent looking up the correct SQL syntax (again) can be better spent elsewhere.
It doesn’t matter if your change would have been a one-liner on the command line, or if it would have required ten SQL commands (ever tried to change the type of a primary key column referenced by five other tables? Not fun). modelDBA takes care of it all for you.
When you save changes, they’re stored locally in modelDBA at first. You’re able to review them directly in the live database diagram. When you’re happy with the changes, you can click apply to have them persisted to the database.
If at any time you decide not to implement a change you made, you can cancel it, and the database diagram will revert to the state it was in before you made the change. This allows you to play around with different table designs. You can try out and compare multiple different table structures and apply the one you like.
No more SQL scripts
You make the changes you need using the interface, modelDBA handles the rest. No copying and pasting a SQL script. And you definitely don’t need to “forward engineer” your database. You just need to click ‘Apply’ to have the changes updated in your database.
Try out the latest version of modelDBA for free here.