Hello Everyone,

We have an application running under VFP8. The number of users and remote connections have increased and the database is not stable which is creating concerns for the user. We are planning to convert the database to MYSQL. (We were thinking about SQL Server too but the server is a Linux box and MYSQL is our best choice). I have worked with SQL Server, Oracle and Informix databases but I'm new to MySQL, so here are my questions in that regard:

1- Will the conversion of the database from VFP to MySQL resolve the database consistency problems?

2- Is MySQL stable?

3- What is the best way to do the conversion?

4- I know that MySQL doesn't support the logical fields, are there any other type conversion issues that you may know?

5- For those of you who have had this experience, what is the hardest part of the conversion?

6- Will the database conversion require a lot of code changes?

7- Does anybody know of other solutions?

Many Thanks in Advance,
Bianca