Consistent and Reliable
Makes database deployments consistent and reliable by ensuring your database always matches your application.
dbmgr
An opinionated database migration and management tool for Microsoft .NET that utilizes convention over configuration.
What is dbmgr?
An open source database script runner and generation tool built to simplify database management for Microsoft .NET applications. dbmgr is a tool you use in your deployment and development activities; it's not part of your application.
Automation Ready
It enables deployment pipelines to manage database schema, programmability and data changes using direct SQL.
Legacy Modernization
Facilitates getting your database under control, and thus will assist in modernization of legacy applications.
Developer Friendly
Database and code are in one package, versioned using standard SCM tooling, making it easier to detect and debug database problems.
Use Plain SQL
No need to learn another language to manage your database. Use plain SQL to manage both the database schema and code.
Actively Maintained
Growing and dedicated support community.
dbmgr extends typical database migration concepts to include clean management of database code and management procedures.
Unlike many migration tools, it is especially suited for legacy applications that involve procedures and business logic still in the database.
Tame your database!
Features
- Built using 100% Microsoft .NET native code
- Wide automation support, including Octopus, AzureDevOps, and TeamCity
- Works with all standard SCM tools, such as Git & Subversion
- Lightweight and simple packaging; can be used in cloud and on-premise deployments.
- Advanced dependency resolution features
- Support for blue/green deployments
Get Started!
Install
Extract the binaries into a directory.
Ensure the system PATH is set to this directory.
SET PATH=%PATH%;C:\dbmgr
Connect
To use the standard database connectivity parameters, use the command line and specify the individual parts of a standard connection string. These will be interpreted by the database provider.
C:\dbmgr --db Northwind --host (local) --opt1 true
Generate a change script
Deploy your database changes.
C:\dbmgr -g "my first change"
Deploy your changes
Deploy your database changes.
C:\dbmgr -m
More Documentation
dbmgr has a host of features and options. If you are interested in learning more, review our documentation.
Download
The dbmgr tool is 100% open source.
For the laywers
The source code of the tool itself is licensed under GNU AGPLv3.
All output of the tool is fully-owned by your organzation (generated database scripts).
Need a little more help taming your legacy database?