CODEWITHSUNDEEP
mysql.netvisual-studio-2013
Michael
Michael

Reputation: 1605

MySql Equivalent of Sql Server Database Project

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.

Upvotes: 12

Views: 5013

Answers (2)

Vasu Inukollu
Vasu Inukollu

Reputation: 130

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.

Upvotes: 4

Michael
Michael

Reputation: 1605

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

Upvotes: 3

Related Questions