Home > other >  How can i manage the state of the database to my current branch
How can i manage the state of the database to my current branch

Time:04-29

With my recent changes on one branch, let's name it Branch A, I changed relations between entities, as well as renamed some properties. I created migrations and applied them to our Postgres-Database, good so far. I committed and pushed the migrations to the git repo and created a pull request. Now I'm waiting on the review of a colleague of mine to merge it to the master branch.

Now the problem.

I started to work on the next item and created another branch, Branch B. I created it from the master, so Branch B does NOT have the changes I made with Branch A, but the Database does, as we don't have it into source control. Now I get, of course, errors, as it cannot find the data with the renamed property from Branch A and the not yet renamed property of Branch B. I could drop the database and recreate it with the initial migration, but that's a lot of work and I will lose data.

We're working with .NET 5 and EF Core, the database provider is Postgres.

So, how do I resolve this misery, without having the database added to the source control?

CodePudding user response:

You can try to apply previous migration (from the master) to your already updated database. It'll try to reverse the changes. Check the link below:

https://stackoverflow.com/a/38197891/4777147

  • Related