DbSchema is a powerful database management and design tool for Azure Synapse. It offers features such as visual schema design, team collaboration with GIT, schema deployment and HTML schema documentation.
Watch the step-by-step video tutorial below:
For written documentation, please continue reading...
Open DbSchema, then click "Connect to Database" on the Main Screen and choose your database system. DbSchema will automatically download the required JDBC driver.
First, you will need the Dedicated SQL endpoint from your Synapse workspace.
Once connected, DbSchema will reverse-engineer your database schema, creating a visual layout of your tables and relationships.
If you need more detailed connection information, read the Connection Dialog
If you experience connection problems, check your firewall and antivirus settings, as they might be blocking the connection. More information on enabling Firewall Connections is available if needed.
If you encounter connection errors, enable logging for diagnostics by following the instructions here.