I am doing this thread so others can see what they might run into doing an backend change over.
I have a fairly large aplication that uses a .dbf backend. I have 165 tables that take up 1.5gb. Since I have been seeing everthing going to the web I figured I would start by changing my backend to sql before I would start making a web application. I went with mysql. Setting up mysql went without a hitch.
I figured I would do a test run to see how everthing would work once I made the change. I made a backup of my complete app and used the "Database upsize genie"
I would say most of my problem getting the genie to work were problems with my database. The major problems were I had bad data in my tables. Problems were multi records with a key field that should have had only one record per key that I had anywhere from 2 to 3 records. Date fields that the user messed up when inputing the date where 1997 turned out to be 0197 and other date problems.
I have now been able to get my application upsized without any error messages after starting fresh with the genie and deleting the sql datebase after every error message. What I am seeing now is I have a number of forms that will not open up and get different error message about not finding a file. I have not started yet into looking as to why I have these problems. I figured I would see a large decrease of time doing querys which I have not seen. I have not run any speed tests but it seems to be slower that before.
My application for lookups uses a dialog where as you type what you are searching for you have a box below with the suggestions that are close to what you are looking for and you then select from the short list what record you are wanting. In opening these there the dialogs are blank and as I type I am not getting any suggestions. I have not looked into yet as to what this problem is or how I can fix this yet.
I will update with more info as I learn it.
I have a fairly large aplication that uses a .dbf backend. I have 165 tables that take up 1.5gb. Since I have been seeing everthing going to the web I figured I would start by changing my backend to sql before I would start making a web application. I went with mysql. Setting up mysql went without a hitch.
I figured I would do a test run to see how everthing would work once I made the change. I made a backup of my complete app and used the "Database upsize genie"
I would say most of my problem getting the genie to work were problems with my database. The major problems were I had bad data in my tables. Problems were multi records with a key field that should have had only one record per key that I had anywhere from 2 to 3 records. Date fields that the user messed up when inputing the date where 1997 turned out to be 0197 and other date problems.
I have now been able to get my application upsized without any error messages after starting fresh with the genie and deleting the sql datebase after every error message. What I am seeing now is I have a number of forms that will not open up and get different error message about not finding a file. I have not started yet into looking as to why I have these problems. I figured I would see a large decrease of time doing querys which I have not seen. I have not run any speed tests but it seems to be slower that before.
My application for lookups uses a dialog where as you type what you are searching for you have a box below with the suggestions that are close to what you are looking for and you then select from the short list what record you are wanting. In opening these there the dialogs are blank and as I type I am not getting any suggestions. I have not looked into yet as to what this problem is or how I can fix this yet.
I will update with more info as I learn it.
Comment