Alpha Video Training
Results 1 to 8 of 8

Thread: MySQL or SQL Server

  1. #1
    Member
    Real Name
    David
    Join Date
    Mar 2013
    Location
    Cambridge, UK.
    Posts
    14

    Default MySQL or SQL Server

    I have had a small amount of experience using MySQL and some experience of using SQL Server. I have had a lot of experience developing desktop applications with MS Access and VBA. As I move to Alpha Five web development I want to either adopt MySQL or SQL Server as a backend database (instead of Access). Initially I will be developing systems for 10-20 users. I also want to keep my costs down to start with. Which backend database would people advise me to adopt and why? Given that I know virtually nothing about using them with Alpha Five, are there any tips or tools that would be worth knowing about? Many thanks in anticipation. David.

  2. #2
    "Certified" Alphaholic glenschild's Avatar
    Real Name
    Glen Schild
    Join Date
    Apr 2000
    Location
    Frome, Somerset, UK
    Posts
    1,525

    Default Re: MySQL or SQL Server

    Hi David

    My own personal preference having used both extensively is MS SQL Server. Most can be achieved using sql express particularly at the level you are considering. Both work well with Alpha so I guess it will come down to personal preference.

    Glen
    Glen Schild



    My Blog


  3. #3
    "Certified" Alphaholic
    Real Name
    Lee Vasic
    Join Date
    May 2010
    Location
    Salt Lake City
    Posts
    1,223

    Default Re: MySQL or SQL Server

    I love MS SQL. Plus if your product grows (Like 200 users) you can upgrade with a license.

  4. #4
    Member
    Real Name
    David
    Join Date
    Mar 2013
    Location
    Cambridge, UK.
    Posts
    14

    Default Re: MySQL or SQL Server

    Thanks for these comments. Are there any advantages to MySQL?

  5. #5
    Member
    Real Name
    Luke
    Join Date
    Dec 2011
    Location
    Northern Virginia, USA
    Posts
    174

    Default Re: MySQL or SQL Server

    I use MySQL because I prefer opensource platforms like Linux, Android, etc. For any app that alpha five can handle either will be fine.

  6. #6
    "Certified" Alphaholic
    Real Name
    Andy Gill
    Join Date
    Jul 2011
    Location
    Barbados
    Posts
    1,029

    Default Re: MySQL or SQL Server

    I find either works great as typical web databases, although MS SQL can offer way, way more (if you need it, that is). MySQL is not very good for heavy administrative tasks, but is simple and fine for web DBs. For smaller intranet stuff, MS Access (JET) works fine as well. MS SQL also allows an easier migration from Access, and if this was your previous experience, then I would recommend MS SQL Express. Also, I tend to use DB views in some instances, and MySQL is not very good with these (performance-wise).
    Last edited by agillbb; 06-08-2013 at 01:40 PM.

  7. #7
    Member
    Real Name
    David
    Join Date
    Mar 2013
    Location
    Cambridge, UK.
    Posts
    14

    Default Re: MySQL or SQL Server

    If MS Access (JET) works OK, what are the reasons for using MySQL or SQL Server in preference? Security? Support for multiple users?

  8. #8
    "Certified" Alphaholic
    Real Name
    Andy Gill
    Join Date
    Jul 2011
    Location
    Barbados
    Posts
    1,029

    Default Re: MySQL or SQL Server

    Exactly. For an app with typically less that say 10 concurrent users, Access is fine. I use it in an intranet application and it works great.
    Make sure and code properly - open your DB connection, get your data and close it quickly. Heavy traffic will eventually cause it to slow down to unacceptable levels, so know your target viewership.

Similar Threads

  1. Painful DbfTransition to SQL SERVER or MYSQL
    By JetLi in forum Application Server Version 11 - Web/Browser Applications
    Replies: 7
    Last Post: 07-06-2012, 10:57 PM
  2. Future of Alpha Five Desktop on Mysql or Sql server
    By JetLi in forum General Questions
    Replies: 12
    Last Post: 04-19-2012, 05:23 PM
  3. Mysql or Sql Server to Native Alpha DBF
    By JetLi in forum Alpha Five Version 11 - Desktop Applications
    Replies: 12
    Last Post: 03-21-2012, 06:39 PM
  4. Mini-training on Navicat for MySQL and SQL Server
    By Steve Wood in forum Announcements
    Replies: 1
    Last Post: 09-29-2011, 11:51 AM
  5. MySQL or MS SQL Server ?
    By Jedt3D in forum Application Server Version 10 - Web/Browser Applications
    Replies: 3
    Last Post: 08-28-2010, 05:47 AM

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
  •