Is it possible to somehow transfer the MySql database to the Sql database that is in Visual studio?

Question

MySQL

I have a MySql database that I created in Workbench, I use it in my C# application and I want the database to be built into the application itself now. Can I somehow build this database into the application without rewriting the entire database, triggers, etc. in T-sql manually?

Answer 1

First, MySQL can be embedded into an application. This is probably the easiest way to solve your problem.
Second, mysqldump will give you the SQL of your database. The table structure and data can be transferred in this way. Triggers are unlikely, there is a MySQL-specific dialect, they will need to be at least corrected.