Easy Interface for SQL
January 12, 2006 4:38 AM Subscribe
What is the best alternative interface for an SQL server?
I am converting several databases from Access to mySQL. Unfortunately, Access doesn't interface natively with mySQL, creating problems.
Are there any tools available with a very Access-like interface that will work with mySQL? I've looked at many query builders, but haven't found much in the way of something that would work for me to give to my end users. These are people who don't know how to compose SQL, but still need to query the database.
I am converting several databases from Access to mySQL. Unfortunately, Access doesn't interface natively with mySQL, creating problems.
Are there any tools available with a very Access-like interface that will work with mySQL? I've looked at many query builders, but haven't found much in the way of something that would work for me to give to my end users. These are people who don't know how to compose SQL, but still need to query the database.
You can use it through Access as nkyad suggests. Otherwise, you can try MySQLFront or CocoaMySQL for Mac. MySQLFront changed developers when version 3.0 came out. I still run 2.5 because I find it much easier to use. If you can find an older copy, I would recommend that.
posted by yerfatma at 5:44 AM on January 12, 2006
posted by yerfatma at 5:44 AM on January 12, 2006
DBDesigner is a great tool, with a special attention paid to MySQL dbs.
Also works with any ODBC db.
FOSS (Free, Open Source Software).
posted by unixrat at 6:18 AM on January 12, 2006
Also works with any ODBC db.
FOSS (Free, Open Source Software).
posted by unixrat at 6:18 AM on January 12, 2006
I realize this isn't a complete answer to your question, but MdbToMySQL XP is a great software tool for converting Access files to SQL text files for import into MySQL.
posted by owen at 7:55 AM on January 12, 2006
posted by owen at 7:55 AM on January 12, 2006
This thread is closed to new comments.
posted by nkyad at 4:54 AM on January 12, 2006