We are considering using a data modeler tool for two specific requirements:
Reverse Engineering for Existing MS SQL Database Tables:
- We need the ability to reverse engineer existing MS SQL database tables.
- Our database runs on SQL Server 2019.
- The tool should allow us to analyze and understand the structure of our existing database.
Design and SQL Script Generation for New MS SQL Database:
- We also want the tool to support designing new MS SQL databases.
- It should be able to generate SQL scripts based on our data model.
- These scripts will help us create the necessary database objects.
If such features are available in the data modeler tool, please provide details on how we can utilize them.