Alpha Video Training
Results 1 to 9 of 9

Thread: Upsizing and MYSQL questions...

  1. #1
    Member
    Real Name
    AM.Papa
    Join Date
    Jan 2019
    Posts
    14

    Default Upsizing and MYSQL questions...

    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,

  2. #2
    "Certified" Alphaholic
    Real Name
    David Kates
    Join Date
    Apr 2008
    Location
    Unionville, ON
    Posts
    7,728

    Default Re: Upsizing and MYSQL questions...

    When you develop either a web or mobile app the table links in the control panel are not part of the process. Think of Alpha and MySQL as 2 separate entities.
    You'll build an AlphaDAO Connection String (Web Control Panel / Tools) to your MySQL database and use that connection string when building List Controls etc. in your app.

    The only reason you used the Control Panel Table Links is to link your desktop application to your MySQL database.

    By default, your AlphaDAO Connection String will be read/write. The same goes for the Table Links.

    You'll need to fully test your existing desktop application with your MySQL tables. MySQL and DBF are completely different and there is no guarantee that Alpha will behave the same with one as with the other.

    Any table you'll need in your web / mobile app you will need in MySQL. Do not use DBF tables in your web / mobile app... they are from another era and do not belong in current development.

  3. #3
    Volunteer Moderator Peter.Greulich's Avatar
    Real Name
    Peter Greulich
    Join Date
    Apr 2000
    Location
    Boston, MA
    Posts
    11,644

    Default Re: Upsizing and MYSQL questions...

    I forget how the upsize genie works and I'm not even sure I understand your questions. This is a dbf desktop application or a dbf web application? I assume it's the former.

    Alpha's desktop has never been optimized for SQL, but you can work with it. If you convert the dbf to MySQL you can use active link tables (which are still really dbf tables linked to the MySQL tables). Is that what the upsize genie does - create active link tables? Anyway, the AL tables will read/write to the MySQL backend. Will your forms/reports all work the same way? More or less, I guess. I had a few hybrid apps quite a ways back and there were certain things such as queries that had to be customized for the MySQL/active link paradigm. So it wasn't 100% a fluent conversion. I did have to customize a lot of stuff. Should you convert all the tables or just some? I don't know. I guess in your case, i would only convert the ones you need for mobile. After you gain some experience with it you can decide what you want to do about the rest.

  4. #4
    Member
    Real Name
    AM.Papa
    Join Date
    Jan 2019
    Posts
    14

    Default Re: Upsizing and MYSQL questions...

    Thanks for the reply's.

    The web app will probably be designed in PHP/Dreamweaver and leverage MYSQL so there would be no direct interaction with A5 only MYSQL.

    You'll build an AlphaDAO Connection String (Web Control Panel / Tools) to your MySQL database and use that connection string when building List Controls etc. in your app.

    The only reason you used the Control Panel Table Links is to link your desktop application to your MySQL database.
    Yes I think I understand the link portion of the process and was able to successfully create the ODBC connection and the tables do appear to be linked to MYSQL, updates in A5 do update the MYSQL tables as was tested. So, if this is a link to MYSQL and it is a read/write connection when designing a form is the data in A5 .dbf or on MYSQL which would utilize a connection string? Can it be used either way?

    Should you convert all the tables or just some?
    Great point Peter, as we design the front end we'll need to sit down and discuss what need to be migrated.

    The plan is to allow all the development to continue in A5, forms, reports, etc. just using MYSQL as the backend.

    When I look at the Control Panel I see that all the tables have the "link" icon except for one. That table somehow "lost" the link and I don't see an option for adding it back in the menu, however the table did migrate to MYSQL. Do you guy's know how to add that back?

    VB,

  5. #5
    Volunteer Moderator Peter.Greulich's Avatar
    Real Name
    Peter Greulich
    Join Date
    Apr 2000
    Location
    Boston, MA
    Posts
    11,644

    Default Re: Upsizing and MYSQL questions...

    You can just select an individual table when you run the genie, I believe. it's sorta coming back to me now.

  6. #6
    Member
    Real Name
    AM.Papa
    Join Date
    Jan 2019
    Posts
    14

    Default Re: Upsizing and MYSQL questions...

    So just a couple of screen shots ...

    Link vs non-linked table
    SNAG-0012.jpg

    Menu on linked table
    SNAG-0010.jpg

    Menu non-linked table
    SNAG-0011.jpg

    I only see a "Workspace Genie" not a Table genie...?
    SNAG-0013.jpg

  7. #7
    Member
    Real Name
    AM.Papa
    Join Date
    Jan 2019
    Posts
    14

    Default Re: Upsizing and MYSQL questions...

    I found the way to re-link the table... I had to re-create it.

    SNAG-0014.jpg

  8. #8
    Member
    Real Name
    Doron
    Join Date
    Dec 2011
    Location
    NJ, USA
    Posts
    174

    Post Re: Upsizing and MYSQL questions...

    Hi ampapa,

    Make sure in each table you have a primary key and an index for that primary key under MySQL. Have that primary key as an integer. Just so you know MS has a free version as well which is called MS SQL Express. I like it better then MySQL.

    Regards,

    Doron
    The Farber Consulting Group, Inc.

    Main Web Site: http://www.dFarber.com
    Alpha AnyWhere Development

  9. #9
    "Certified" Alphaholic
    Real Name
    Gregg Schmidt
    Join Date
    Mar 2001
    Location
    Milwaukee
    Posts
    1,388

    Default Re: Upsizing and MYSQL questions...

    Hi AM.Papa,

    I've converted many dbf tables to MySQL.
    I typically export the data to a spreadsheet, which then
    gives me the opportunity to easily insert a column to use as primary key (I typically call it seq).
    I use ms sql Express and MySQL, but prefer MySQL because triggers, dates, stored functions, and
    stored procedures are in my opinion, much easier to deal with.

Similar Threads

  1. Upsizing
    By nkelson in forum Windows Desktop Applications
    Replies: 2
    Last Post: 10-13-2016, 11:03 AM
  2. Questions on MySQL connections
    By Sparticuz in forum Mobile & Browser Applications
    Replies: 2
    Last Post: 06-19-2015, 03:13 PM
  3. Access to SQL Microsoft upsizing wizard - any good?
    By Malcolm in forum Application Server Version 11 - Web/Browser Applications
    Replies: 3
    Last Post: 03-23-2013, 12:48 PM
  4. 2 newbie questions: MySQL and print-to-file
    By LaurenW in forum Alpha Five Version 9 - Desktop Applications
    Replies: 5
    Last Post: 07-10-2008, 05:49 AM
  5. Questions on using mysql tables vs alpha5v8 tables
    By randbo in forum Application Server Version 8
    Replies: 6
    Last Post: 03-20-2007, 01:51 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •