sethreno / Schemazen
Licence: mit
Script and create SQL Server objects quickly
Stars: ✭ 273
Projects that are alternatives of or similar to Schemazen
Mithril Data
A rich data model library for Mithril javascript framework
Stars: ✭ 17 (-93.77%)
Mutual labels: schema, database
Squid
🦑 Provides SQL tagged template strings and schema definition functions.
Stars: ✭ 57 (-79.12%)
Mutual labels: schema, database
Localtower
Manage your Ruby On Rails models, relations, and migrations from a simple UI.
Stars: ✭ 401 (+46.89%)
Mutual labels: schema, database
Trilogy
TypeScript SQLite layer with support for both native C++ & pure JavaScript drivers.
Stars: ✭ 195 (-28.57%)
Mutual labels: schema, database
Sleekdb
Pure PHP NoSQL database with no dependency. Flat file, JSON based document database.
Stars: ✭ 450 (+64.84%)
Mutual labels: schema, database
Squasher
Squasher - squash your old migrations in a single command
Stars: ✭ 1,260 (+361.54%)
Mutual labels: schema, database
Goose
A database migration tool. Supports SQL migrations and Go functions.
Stars: ✭ 2,112 (+673.63%)
Mutual labels: schema, database
Pgquarrel
pgquarrel compares PostgreSQL database schemas (DDL)
Stars: ✭ 274 (+0.37%)
Mutual labels: schema, database
Scenic
Scenic is maintained by Derek Prior, Caleb Hearth, and you, our
contributors.
Stars: ✭ 2,856 (+946.15%)
Mutual labels: schema, database
Versionpress
Git-based version control for WordPress. Whoa!
Stars: ✭ 2,479 (+808.06%)
Mutual labels: database, version-control
Eralchemy
Entity Relation Diagrams generation tool
Stars: ✭ 767 (+180.95%)
Mutual labels: schema, database
Space Cloud
Open source Firebase + Heroku to develop, scale and secure serverless apps on Kubernetes
Stars: ✭ 3,323 (+1117.22%)
Mutual labels: database, mssql
Neo4j Graphql
An optimized neo4j query resolver for Facebook's GraphQL
Stars: ✭ 60 (-78.02%)
Mutual labels: schema, database
Dapper.fsharp
Lightweight F# extension for StackOverflow Dapper with support for MSSQL, MySQL and PostgreSQL
Stars: ✭ 145 (-46.89%)
Mutual labels: database, mssql
Enumdb
Relational database brute force and post exploitation tool for MySQL and MSSQL
Stars: ✭ 167 (-38.83%)
Mutual labels: database, mssql
Postguard
🐛 Statically validate Postgres SQL queries in JS / TS code and derive schemas.
Stars: ✭ 104 (-61.9%)
Mutual labels: schema, database
Mongoke
Instant Graphql for MongoDb (active branch is golang, rewrite in process)
Stars: ✭ 203 (-25.64%)
Mutual labels: schema, database
Schema Zen - Script and create SQL Server objects quickly
Schema Zen has three main commands:
script
SchemaZen.exe script --server localhost --database db --scriptDir c:\somedir
This will generate sql scripts for all objects in the database in a directory structure that looks something like:
c:\somedir\
data
foreign_keys
procedures
tables
views
props.sql
schemas.sql
create
SchemaZen.exe create --server localhost --database db --scriptDir c:\somedir
This will create a database named db from the sql scripts in c:\somedir.
compare
SchemaZen.exe compare --source "server=dev;database=db" --target "server=qa;database=db" --outFile diff.sql
This will compare the databases named db
between dev
and qa
and
create a sql script called diff.sql
that can be run on qa
to make it's
schema identical to dev
.
See SchemaZen.exe help [command]
for more information and options on each command.
Download
The latest release can be downloaded here
Contributing
Pull requests are welcome and appreciated. See contributing.md for guidelines.
Chat
If you've found Schema Zen helpful you can buy me a coffee to say thanks. Cheers!
Note that the project description data, including the texts, logos, images, and/or trademarks,
for each open source project belongs to its rightful owner.
If you wish to add or remove any projects, please contact us at [email protected].