{"repo":"rebus-org/migr8","free":true,"listed":false,"github":"https://github.com/rebus-org/migr8","clone":"git clone https://github.com/rebus-org/migr8.git","description":":seedling: Short'n'sweet SQL Server/PostgreSQL/MySQL schema migration library","language":"C#","stars":44,"topics":["sql","sql-server","c-sharp","database","migrations","migration-tool"],"license":"MIT","category":"databases-storage","readme_excerpt":"Migr8 First you install the appropriate Migr8 package - if you're using SQL Server, you will probably Install-Package Migr8 -ProjectName YourApp and if you're using PostgreSQL, you be all Install-Package Migr8.Npgsql -ProjectName YourApp and then you will be good to go :) Let's migrate Execute the migrations - either in a dedicated command line app, or - my favorite - whenever your app starts up, just before it connects to the database: and then, elsewhere in the calling assembly, you define these bad boys (which happen to be valid T-SQL): In the example above, I've created two migrations which will be executed in they order indicated by their sequence number . Branch specifications Since you will most likely not be the only one developing things in your application, you might have adopted a git flow -inspired branching model, where each developer will create a branch to work in. For example, two developers working in the feature/first-cool-thing and feature/next-cool-thing branches might need to create the next migration. In the old days, one of them would be the unfortunate one to last integrate migration 3 back into master, it would be necessary to change the migration to be number 4 and probably execute the other developer's migration manually. Luckily, they chose to use Migr8 to evolve their database, so they just go ahead and create and which will NOT BE A PROBLEM AT ALL, because they remembered to set the branchSpecification to the names of their branches. Migr8 will u","default_branch":null,"files":null,"tree":[],"storefront":"/r/rebus-org","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/rebus-org/migr8/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}