12

I am trying to find a way to put MySql database versioning under source control. In the past, working with SQL Server, I have used the "SQL Server Database Project" project type in Visual Studio.

Is there any way to make that project type work with the MySql .Net Connector?

If not, are there any other ways of creating a MySql database project in .Net?

UPDATE:

I found dbForge which has Database Projects in the Professional edition. It's does everything I need it to. Enables us to move the schema into source control, enables us to generate scripts for updating to a new version or rolling back to an old version, etc. The UI is almost an exact duplicate of a visual studio database project.

I'm still going to leave this question open for a while though in case anyone knows of a free alternative.

Improve this question
2
  • Take a look at this: dbv.vizuina.com Commented Mar 31, 2014 at 19:30
  • I doubt there's going to be much in Visual Studio for this, but surely there must be database project development tools available for MySQL somewhere? Isn't there a MySQL Workbench application or something of that nature? Putting the resulting structure into source control wouldn't be any different. Commented Mar 31, 2014 at 19:32

2 Answers 2

Reset to default
4

Did you try Skeema? If you are familiar with Microsoft Dacpac for SQL Server, you will appreciate this tool.

https://github.com/skeema/skeema

You need run two commands.

skeema diff --> To generate the differences. skeema push --> make changes.

Skeema is documented well.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

3

I ended up going with dbForge. It's not free but it works very well.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.