My first post to the forum so excuse me if there is a FAQ somewhere on the subject.
I'm trying to help a friend who is a long time A5 user migrate some/all of A5 to a MYSQL backend so that he/we can develop a mobile app frontend from the data that's been gathered.
I've read a number of posts and watched a few of the videos of users migrating/upsizing to MYSQL as a backend and I was able to successfully upsize to MYSQL. I have a few questions if anyone could help or point me in the right direction that would be great.
1 - Can anyone confirm that the link between A5 and MYSQL are either read/write? I think it questioned as part of the upsizing genie but I quickly went through the process as a POC and have forgotten?
2 - All of the tables in A5 control panel have a link icon on them as I would suspect, except for one. However this table did migrate as I see a copy of it in MYSQL, how did it lose the link and how do I re-create it?
3 - After the upsizing process is complete and the tables have been linked to MYSQL, will all form development/reports/letters, etc. continue to happen in A5 correct, nothing there changes?
4 - Does it make sense to only upsize the required tables and leave the rest as .DBF?
Thanks for any guidance or answers you supply. Any help is appreciated.
VB,
I'm trying to help a friend who is a long time A5 user migrate some/all of A5 to a MYSQL backend so that he/we can develop a mobile app frontend from the data that's been gathered.
I've read a number of posts and watched a few of the videos of users migrating/upsizing to MYSQL as a backend and I was able to successfully upsize to MYSQL. I have a few questions if anyone could help or point me in the right direction that would be great.
1 - Can anyone confirm that the link between A5 and MYSQL are either read/write? I think it questioned as part of the upsizing genie but I quickly went through the process as a POC and have forgotten?
2 - All of the tables in A5 control panel have a link icon on them as I would suspect, except for one. However this table did migrate as I see a copy of it in MYSQL, how did it lose the link and how do I re-create it?
3 - After the upsizing process is complete and the tables have been linked to MYSQL, will all form development/reports/letters, etc. continue to happen in A5 correct, nothing there changes?
4 - Does it make sense to only upsize the required tables and leave the rest as .DBF?
Thanks for any guidance or answers you supply. Any help is appreciated.
VB,
Comment