OpenDBDiff
A database comparison tool for Microsoft SQL Server 2005+ that reports schema differences and creates a synchronization script. (by OpenDBDiff)
ModelSync
A C# model class and database schema comparison, SQL diff scripting library (by adamfoneil)
| OpenDBDiff | ModelSync | |
|---|---|---|
| 2 | 1 | |
| 541 | 6 | |
| 0.4% | - | |
| 4.2 | 4.3 | |
| 4 months ago | 4 months ago | |
| C# | C# | |
| GNU General Public License v3.0 only | MIT License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
OpenDBDiff
Posts with mentions or reviews of OpenDBDiff.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-11-25.
-
compare 2 db schemas and automatically generate scripts
I use OpenDBDiff in prod (not the client but the underlying dlls). It has pretty good configuration to include/exclude types of objects
- Migra: Like Diff but for PostgreSQL Schemas
ModelSync
Posts with mentions or reviews of ModelSync.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-11-25.
-
compare 2 db schemas and automatically generate scripts
Something like this? https://github.com/adamfoneil/ModelSync. Not sure if it will suit your needs. Plus it might need some extra work to use?
What are some alternatives?
When comparing OpenDBDiff and ModelSync you can also consider the following projects:
migra - Like diff but for PostgreSQL schemas
sqlcup - Get sqlc up and running in no time by having boilerplate CRUD statements generated for your database.
sqldef - Idempotent schema management for MySQL, PostgreSQL, and more
tusker - PostgreSQL migration management tool
SQLMonitor - SQL Server monitor, manages sql server performance, monitor sql server processes and jobs, analyze performance, analyse system, object version control, view executing sql query, kill process / job, object explorer, database shrink/log truncate/backup/detach/attach.