Migrating from a Local DB to MySQL DB

Navigation
0

I'm developing an ASP.NET WEB page with MVC and I made all the model, control and display settings in Visual Studio 2017 and it created a Local BD by SQL Server LocalDB to store the data but there is an automated function that migrates the table for a MySQL DB?

    
asked by anonymous 01.03.2018 / 12:27

1 answer

0

Install the MySql connector in your project. Download it through the official website: MySql Connector

In your web.config file, add the property below the close of the appSettings property. This property sets its Connection String in the project. Example:   <connectionStrings> <add name="nomedasuastringdeconexao" connectionString="Database=nomedoseudatabase;Data Source=localhost;User Id=seuUsuario;Password=suaSenha;pooling=false" providerName="MySql.Data.MySqlClient" /> </connectionStrings>

    
01.03.2018 / 22:09
Forbidden 403 - City Hall Curitiba Notice: Undefined offset: 2 in C: \ wamp64 \ www \ angelamodas \ adm \ panel \ pages \ editProduct.php on line 103