>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?

No. They are problem of your DB design.

>2- Is MySQL stable?

Vesrsion 4.1 is stable, 5.0 was releases last fall

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

Using CursorAdaptor

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

Use Bit fields instead of logical

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

No hardest part. It depend on your knowledge

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

May be it depand how you wrote you existing application

>7- Does anybody know of other solutions?

Yes there are a lot of solution. One of them is optimizing of existing DB or re-architecturing it in proper way

>Many Thanks in Advance,
>Bianca