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.
No, MySQL is not the same as SQL server. Both of these are relational database management systems offered by different vendors.
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.
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.
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.
I ended up going with dbForge. It's not free but it works very well.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With