MS Access, MS SQL 2005 and MySQL differences?

Discussion in 'OT Technology' started by gubment cheese, May 3, 2009.

  1. gubment cheese

    gubment cheese New Member

    Joined:
    Jan 19, 2004
    Messages:
    10,113
    Likes Received:
    0
    Location:
    South Bend
    I need to find someone to restore a database appliation for me that was written in Access with some reporting being done out of MS SQL 2005.

    I have talked to a guy who is good with MySQL, but not too familiar with MS. How different are the languages? I have also considered getting some training and learning MS SQL 2005...how easily could that knowledge be transferred to MySQL? Is there any type of formal traning for MySQL?
     
  2. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    The difference in the SQL part of things isn't that different. If you're the access database doesn't have forms then you can actually use the migration tool to put it into MS SQL.
     
  3. gubment cheese

    gubment cheese New Member

    Joined:
    Jan 19, 2004
    Messages:
    10,113
    Likes Received:
    0
    Location:
    South Bend
    the access database using lots of forms. i am thinking of doing just that - taking the tables (which already exist) and rebuliding the forms (that don't exist anymore) in a different program.
     
  4. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    Depending on the complexities of the form (how it manipulates the data), that could be a problem without the vba code behind the form. But sometimes a form is straight forward.
     

Share This Page