ASP.Net and mysql realted query?

[AKV]

I've an application developed in ASP.net and Mysql as DB. now how do i deploye the mysql db to the production Server.

[Tamayi M]

Hi

There are really a number of ways to do this. To simplify your life, I would recommend SQLyog. They have a community edition which can gives a very nice GUI where you can backup databases or even synchronize database servers etc

http://www.webyog.com/en/

Dont forget to install your mySQL .NET connectors etc on production server.

[mishravijay]

You can use a freeware version of SQLyog tool from http://www.webyog.com/.

1. You have to first register both you production server and the development server.

2. Make a connection to both servers

3. Create a blank database on prodction server (in case there is no database on production server).

3. Right click on the production server database and select the 'Copy databases to different Host/DB...'