| Deletions are marked like this. | Additions are marked like this. |
| Line 1: | Line 1: |
|
* Survey of [http://www.antipope.org/charlie/linux/shopper/158.databases.html open-source databases] principally examines MySQL, PostgreSQL, and I''''''nterBase. * [http://debianlinux.net/databases.html#tools list] of database management tools. * [http://dev.mysql.com/ MySQL] * [http://www.fabforce.net/dbdesigner4/ DBDesigner 4] GUI for MySQL (GPL) * [http://www.quest.com/toad_for_mysql/index.asp Toad for MySQL] (free trial) * [http://www.navicat.com/ Navicat] GUI for MySQL (free trial) * [http://www.ilovejackdaniels.com/php/mysql-cheat-sheet/ cheat sheet] * [http://www.postgresql.org/ PostgreSQL] * [http://www.vitavoom.com/postgresql.html Comparisons] vs. MySQL, I''''''nterBase, Oracle. * [http://firebird.sourceforge.net Firebird] is based on I''''''nterBase. * [http://db.apache.org/derby/ Apache Derby] nee Cloudscape * Berkeley DB by [http://www.sleepycat.com/ Sleepycat] (now purchased by Oracle) |
* Survey of [[http://www.antipope.org/charlie/linux/shopper/158.databases.html|open-source databases]] principally examines MySQL, PostgreSQL, and I''''''nterBase. * [[http://debianlinux.net/databases.html#tools|list]] of database management tools. * [[http://dev.mysql.com/|MySQL]] * [[http://www.fabforce.net/dbdesigner4/|DBDesigner 4]] GUI for MySQL (GPL) * [[http://www.quest.com/toad_for_mysql/index.asp|Toad for MySQL]] (free trial) * [[http://www.navicat.com/|Navicat]] GUI for MySQL (free trial) * [[http://www.ilovejackdaniels.com/php/mysql-cheat-sheet/|cheat sheet]] * [[http://www.postgresql.org/|PostgreSQL]] * [[http://www.vitavoom.com/postgresql.html|Comparisons]] vs. MySQL, I''''''nterBase, Oracle. * [[http://firebird.sourceforge.net|Firebird]] is based on I''''''nterBase. * [[http://db.apache.org/derby/|Apache Derby]] nee Cloudscape * Berkeley DB by [[http://www.sleepycat.com/|Sleepycat]] (now purchased by Oracle) |
| Line 16: | Line 16: |
| * The [http://www.orafaq.com/faqodbc.htm Oracle ODBC Connectivity FAQ] contains an entry on [http://www.orafaq.com/faqodbc.htm#ACCESSATTCH attaching to an Oracle table in MS-Access] | * The [[http://www.orafaq.com/faqodbc.htm|Oracle ODBC Connectivity FAQ]] contains an entry on [[http://www.orafaq.com/faqodbc.htm#ACCESSATTCH|attaching to an Oracle table in MS-Access]] |
| Line 19: | Line 19: |
| * [http://mdbtools.sourceforge.net/ mdbtools] runs under Linux ([http://sourceforge.net/projects/mdbtools on sourceforge) | * [[http://mdbtools.sourceforge.net/|mdbtools]] runs under Linux ([http://sourceforge.net/projects/mdbtools on sourceforge) |
| Line 21: | Line 21: |
| * [http://savage.net.au/Ron/html/msaccess2rdbms.html Msaccess2rdbms] is a Perl script | * [[http://savage.net.au/Ron/html/msaccess2rdbms.html|Msaccess2rdbms]] is a Perl script |
| Line 23: | Line 23: |
|
* [http://www.bigprof.com/mya/index.php AccessMyWizard] converts between Access and MySQL databases (free trial) * [http://data-conversions.net/access-to-mysql-pro-converter.html Access2MySql] and [http://data-conversions.net/access-to-postgresql-pro-converter.html Access2postgreSQL] shareware tools * [http://www.dqwest.com/mdbartisan.htm MDB Artisan] is a commercial tool with a free trial * [http://www-128.ibm.com/developerworks/db2/library/techarticle/alazzawe/0112alazzawe2.html ODBC Export] from Access (here, to DB2) * No help in the [http://www.kayodeok.btinternet.co.uk/favorites/kbofficeaccesshowto.htm Access How-To articles] |
* [[http://www.bigprof.com/mya/index.php|AccessMyWizard]] converts between Access and MySQL databases (free trial) * [[http://data-conversions.net/access-to-mysql-pro-converter.html|Access2MySql]] and [[http://data-conversions.net/access-to-postgresql-pro-converter.html|Access2postgreSQL]] shareware tools * [[http://www.dqwest.com/mdbartisan.htm|MDB Artisan]] is a commercial tool with a free trial * [[http://www-128.ibm.com/developerworks/db2/library/techarticle/alazzawe/0112alazzawe2.html|ODBC Export]] from Access (here, to DB2) * No help in the [[http://www.kayodeok.btinternet.co.uk/favorites/kbofficeaccesshowto.htm|Access How-To articles]] |
Survey of open-source databases principally examines MySQL, PostgreSQL, and InterBase.
list of database management tools.
DBDesigner 4 GUI for MySQL (GPL)
Toad for MySQL (free trial)
Navicat GUI for MySQL (free trial)
Comparisons vs. MySQL, InterBase, Oracle.
Firebird is based on InterBase.
Apache Derby nee Cloudscape
Berkeley DB by Sleepycat (now purchased by Oracle)
- IBM's DB2 now has a free, but not open source, version.
The Oracle ODBC Connectivity FAQ contains an entry on attaching to an Oracle table in MS-Access
Exporting a schema and data from a Microsoft Access database:
mdbtools runs under Linux ([http://sourceforge.net/projects/mdbtools on sourceforge)
Msaccess2rdbms is a Perl script
http://www.experts-exchange.com/Databases/MS_Access/Q_21680204.html and http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/465757 touch on this topic.
AccessMyWizard converts between Access and MySQL databases (free trial)
Access2MySql and Access2postgreSQL shareware tools
MDB Artisan is a commercial tool with a free trial
ODBC Export from Access (here, to DB2)
No help in the Access How-To articles