MySQL Forums
Forum List  »  MySQL for Visual Studio

Re: Saving Visual Studio 2010 express pages as MySQL
Posted by: Francisco Alberto Tirado Zavala
Date: July 28, 2015 10:43AM

hello Lynn.

Do you want to migrate your current Application to use MySql instead of MS Sql Server or any other database server?

If that's the case, what you need to do is:
- Install Connector/Net or add it using nugget to your project. MSI: https://dev.mysql.com/downloads/connector/net/, Nugget Package: https://www.nuget.org/packages/MySql.Data/
- Add a reference to Connector/Net assembly in your project.
- Update or add a valid MySql connection string that will be used by your application.
- Validate that the MySql database has the same schema (tables, stored procedures, etc) that your current Database has.
- Verify that the syntax in the query or queries that you have in your application is valid for MySql.
- Run your application and test it to look for bugs.

You don't need to update or change your current controls or pages, but you must update the way your application access or write the data.
If you are not doing a migration between database servers, please share more details about what you're trying to do it.

Thanks for your time.

*** My opinions do not necessarily reflect the opinions of my employeer ***
MySql Windows Experience Team

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Saving Visual Studio 2010 express pages as MySQL
708
July 28, 2015 10:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.