Store MySQL database in source control

Question

Our company mainly develops in .NET with MSSQL, although there are some products that were built on PHP with MySQL. We develop in Visual Studio and save all our data in TFS Source Control. Now, by default, there is a database project for MSSQL, but for MySQL there are none. Now I have the aspect that we are not the first people trying to store a MySQL database under TFS SC. So I searched Google for some solutions or best practices, but I did not find much useful information.

Now we can say that we are creating our own template for the MySQL project. With a predefined directory structure and free files for each item TABLE, KEYS, PROC ect. When deployed, let it create one large script and deploy it to the MySQL database on the command line.

The above solution is not perfect for me, and so I was looking for other solutions. Perhaps there are some programs or well-known solutions that are better than the one I had in mind. I would appreciate it if any of you could tell me or share with me your knowledge or ideas.

Answer 1

Install the mysql.net connector and add the database.

Adding a database: Add a new item → Add a local database → Select a database → New connection → select datasource = Mysql databsae and enter a username and password.

Everything else is like SQL Server.