No SchemaSpy videos yet. You could help us improve this page by suggesting one.
Based on our record, StreamSets should be more popular than SchemaSpy. It has been mentiond 2 times since March 2021. We are tracking product recommendations and mentions on various public social media platforms and blogs. They can help you identify which product is more popular and what people think of it.
If you would like to take a look at https://streamsets.com/ the Data Collector product can handle this for you as well as dynamically generate the target tables. It has a number of functions to handle your JSON no matter the complexity. However, given the dynamic nature it may benefit to touch base so please feel free to chat or message me. Source: almost 2 years ago
StreamSets offers a free tier and free option for training. You can build, run, and manage your pipelines in one place. Source: over 2 years ago
If you don't need a tool where you can edit an ERD, try SchemaSpy it generates a nice HTML report of all tables, columns and creates an ER diagram based on declared foreign keys. I have never used it with SQL Server, but with Oracle and Postgres it also extracts the comments for tables and columns. I think that relies on the JDBC driver returning them properly, not sure if the MS driver does that (using the... Source: over 2 years ago
Terraform - Tool for building, changing, and versioning infrastructure safely and efficiently.
DbSchema - DbSchema - Visual Database Design & Management Tool
Puppet Enterprise - Get started with Puppet Enterprise, or upgrade or expand.
ERBuilder - ERBuilder is a data modeling software that provides all the features you would expect from a professional database modeling tool such as reverse engineering, generating DDL scripts and databases, generating data, comparing models & databases and more
Packer - Packer is an open-source software for creating identical machine images from a single source configuration.
DBeaver - DBeaver - Universal Database Manager and SQL Client.