Product is unusable for existing databases

While the app is visually appealing, it currently has a serious show-stopper if you want to use it to document an existing MSSQL database. It currently has no way to create a primary key on a table and set it as an identity field. That by itself could be worked around as long as you could make the setting in SSMS, but the app also can’t update an existing model. You have to create it from scratch each time you make a change in the actual db. This prevents you from doing anything other than auto-generating your model if you intend to use it in conjunction with the actual db.

Hopefully a fix is forthcoming.

AnoPres about Navicat Data Modeler Essentials