Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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.

like image 427
Michael Avatar asked Mar 31 '14 19:03

Michael


People also ask

Can I use MySQL instead of SQL Server?

No, MySQL is not the same as SQL server. Both of these are relational database management systems offered by different vendors.

Is MySQL Workbench better than SQL Server?

MySQL WorkBench has a broader approval, being mentioned in 17 company stacks & 33 developers stacks; compared to Microsoft SQL Server Management Studio, which is listed in 8 company stacks and 19 developer stacks.

What is SQL Server database project?

Solution. SQL Server Data Tools (SSDT) is a development tool from Microsoft for building SQL Server relational databases in Visual Studio. In an SSDT Project you can design database objects for SQL Server, but also Azure SQL DB and Azure SQL Data Warehouse.

Is MySQL Workbench same as server?

Server is the main thing - this is where your database storing/query processing etc happens. MySQL Workbench is just a client interface (a GUI) to interact with the server. Without the server running, you cannot connect to any database in Workbench, and hence achieve nothing.


1 Answers

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

like image 54
Michael Avatar answered Sep 17 '22 20:09

Michael