You are here: Home > Linux > Database > Database Engines > MDB Tools

MDB Tools for Database on Database Engines 0.6pre1

MDB Tools is an apps for Database Engines on Database, by Brian Bruns. The MDB Tools project is a effort to document the MDB file format used in Microsoft's Access database package, and to provide a set of tools and applications to make that data available on other platforms.

Publisher:
Brian Bruns
Language:
Version:
0.6pre1
Run on OS:
Probably All
License:
LGPL (GNU Lesser
Price:
File type:
.tar.gz
File size:
614 KB
Updated on:
Aug 19, 2015
Reviews:
Check Reviews
Rating:
Softmenu rating: 6/10
Advertisement

MDB Tools 0.6pre1 Reviews - by Softmenu Linux Editor

MDB Tools is an app for Database under linux. With version 0.6pre1 of MDB Tools, you can have your jobs better done than any more.

Advertisement

Apps Description - by Publisher

Apps description is given by Brian Bruns - the apps publisher/developer, and it is made no changes by softmenu.

Apps Full Description see below:

The MDB Tools project is a effort to document the MDB file format used in Microsoft's Access database package, and to provide a set of tools and applications to make that data available on other platforms.

Specifically, MDB Tools includes programs to export schema and data to other databases such as MySQL, Oracle, Sybase, PostgreSQL, and others.

Also, included is a SQL engine for performing simple SQL queries. The 0.5 release includes an updated GUI interface (screenshot is available here). A sparse but functional ODBC driver is included as well.

MDB Tools currently has read-only support for Access 97 (Jet 3) and Access 2000/2002 (Jet 4) formats. Access 2000 support is a recent addition and may not be as complete as Jet 3 support.

Write support is currently being worked on and the first cut is expected to be included in the 0.6 release.

Requirements:

?glib 2.0
?readline
?bison
?flex
?unixODBC
?Gnome 2.0
?libglade
?wordexp



MDB Tools is composed of three libraries, a set of command line utilities and a graphical interface.

LibMDB

libmdb is the lowest level library. It handles the details of reading from and writing to the MDB file format. Atop this library sits all the other functionality of MDB Tools.

A complete description of libmdb will be available in the forthcoming MDB Tools Programmer's Guide. For now you can look at the utility programs for a general idea of how to use the API, it's fairly straightforward.

Command Line Utilities

MDB Tools comes with a set of command line utilties that allow mdb files to be used in shell scripting, extraction to another database, and similar functions. Each program is documented in its man page. A brief synopsis follows.

mdb-tableslist tables in the specified file
mdb-schemagenerate schema DDL for the specified file
mdb-exportgenerate CSV style output for a table
mdb-verdisplay the version of the specified file
mdb-headersupport for using MDB data in C
mdb-parsecsvsupport for using MDB data in C
mdb-sqlcommand line SQL query tool

LibMDBSQL (the SQL Engine)

LibMDBSQL is an SQL engine which provides a subset of the SQL query language to access MDB databases. It is used with the ODBC driver, by the mdb-sql utility, and by the query window in gmdb2.

LibMDBODBC

LibMDBODBC is an ODBC driver that works with the unixODBC driver manager to allow MDB Tools to work with such programs as PHP and Perl (via DBD::ODBC). At the time of this writing, the breadth of coverage for the driver is rather limited. If you have specific problems with it, please contact the list and they can most likely be resolved.

The ODBC driver relies on LibMDB and LibMDBSQL.

Gmdb2

Gmdb2 is a graphical interface to the functionality of MDB Tools. Its interface resembles that of access with a tabbed interface to each of the object types in the database (tables, queries, forms, etc...). Additonally, it sports an SQL Query window, and a file debugger useful for developers or anybody interested in examining the dark secrets of the MDB file format.

Supported Operating System:

Probably All

Running requirements

Need not extra requirement except the OS environments mentioned above.

Limitations

Please check the license above, if this is a freeware, it will be no limitation, else it may have the days or times limitation, please read the specifications attached with the download file carefully.

Tested virus free - MDB Tools has been tested to be a safe app on Aug 19, 2015.

Advertisement

Linux Programs Searches Related to MDB Tools

Bookmark or share this page to your friends

copy softmenu.org bookmark
copy softmenu.org bookmark
copy softmenu.org bookmark

MDB Tools Related Apps for Linux

MdbToMySQL XP

MdbToMySQL is a tiny utility for all those programmers migrating a Microsoft Access database to MySQL. It's free! Just select the .MDB file and choose the tables to export.MdbToMySQL ...

MDB2SQL

MDB2SQL automates Microsoft SQL Server support for Microsoft Access-based applications without the need to rewrite your existing code. MDB2SQL can quickly and cost-effectively convert your Access (.

MDB2SQL Professional

This software will automate Microsoft SQL Server support for Microsoft Access-based applications without the need to rewrite your existing code.MDB2SQL can quickly and cost-effectively ...

SysTools Access Recovery

Access Database Recovery recovers readily database of MS Access and provide complete recovery solution of database. For privacy point of view mostly users gives password protection to their database.

WebToolbox - 70+ Tools for Safari

OVER 70 TOOLS IN ONE APP! ULTIMATE VALUE!******* LIMITED TIME SALE 50% OFF*******Ever wish you could get more out of the Safari browser for iPhone/iPod Touch? Now you can! WebToolbox ...

MDB Viewer Plus

view and edit .mdb files MDB Viewer Plus enables you to view and edit the content of .ACCDB and .MDB files without the need to have Microsoft Access installed. It provides ...

Latest Apps Topic