BullZip MS Access to MySQL
As a database administrator of a large business company I need to provide using PHP and MySQL to query and display the data function for the customers. So sometimes I need to convert Microsoft Access databases (.mdb) to mySQL databases. BullZip MS Access to MySQL which was published by BullZip. provided me great help indeed. If you have the same requirement just as me. BullZip MS Access to MySQL is an ideal solution for you absolutely! Following is the detailed introduction of this powerful and useful databases converter.
BullZip MS Access to MySQL is a program to move MS Access databases to MySQL server. Depending on our privileges on the target MySQL server, we can either export MS Access data into new database, or overwrite the contents of an existing MySQL database. We can also choose to export to a mySQL dump file first, and then import it to the server later. The program offers a simple 3-step wizard interface. When we start the program it will run us through a wizard. The wizard will ask us all the necessary questions to setup the database transfer. In the first step we are asked to supply the file name of the Microsoft Access Database to convert. If our Access database requires us to log in we can specify a user name, password and a system database. We can simply select the database, specify the mySQL server details and we are ready to go.
This version is designed for single database conversion, an additional Pro version for bulk conversions is also available. The main features and functions of BullZip MS Access to MySQL include: Wizard interface. Transfer data directly from one server to another. Create a dump file - We will have the choice of placing the result in a dump file instead of transferring it directly to another MySQL database. Select tables to transfer - We can specify exactly which tables we want to transfer to the destination database. Just check the box in front of each table name you want to transfer and click next.
After answering all the questions in the wizard we can press Finish. The transfer will now run until all the selected tables are transferred. When the transfer is done we will see a small report telling us how much data was transferred. The settings of the wizard can be saved in an .ini file. Select fields to transfer. This will only create the tables in the destination table and leave them empty. Transfer password protected databases. Supports both shared security and user-level security. Optional transfer of indexes - Here we can specify if we want to transfer the indexes of the Access database to MySQL. Optional transfer of records - We can also select not to transfer any records. Optional transfer of default values in field definitions - In both Access and MySQL fields can have default values.
When creating the tables in MySQL the program can preserve the default values specified in the Access field definition. Also auto number properties of a field can be transferred if we check the Auto number properties box. Identifies and transfers auto number field types. Command line interface. Easy install, uninstall and upgrade. The latest version of Access-to-MySQL is 3.3 and the newest features of it include: Support for Microsoft Access 2007 databases (accdb and accde). Setup program modified for better Vista support. Boolean fields are represented as 0 and -1. This is a change from 0 and 1. Empty strings are now transferred as a zero length string instead of a NULL value. support for decimal and currency fields. Reads precision and scale from the source field. Support for password protected Microsoft Access databases. Both shared security and user-level security is supported and much more.
In addition, BullZip MS Access to MySQL provides a free trial for us. It is a standalone software and does not need any extra software and hardware requirement. BullZip MS Access to MySQL does not contain any adware or spyware, so we can use it safely and undisturbed. It works with most recent variants of Windows and its current version is 126.96.36.199.
Overall, BullZip MS Access to MySQL is a very nice, easy to use and full-functions applications to convert an Access database to mySQL. The developer of this software wanted to ensure ease of use for the average home user with its simple, clean, great looking interface, but included features for even the most demanding, experienced users. It is an ideal solution for database administrator and software designers. With all these features, simple interface, excellent usability and free trial - why are you still reading? Download the free trial now and experience what powerful and effective it is at once! If you feel this utility is helpful indeed, introduce it to your friends please!
BullZip MS Access to MySQL enables you to convert a MS Access database to MySQL server format and export the tables to your MySQL database server. You can choose the tables and columns to include and also select to transfer indexes and table records. A step-by-step wizard will guide you through the process.
* Wizard interface.
* Transfer data directly from one server to another.
* Create a dump file.
* Select tables to transfer.
* Select fields to transfer.
* Transfer password protected databases.
* Supports both shared security and user-level security.
* Optional transfer of indexes.
* Optional transfer of records.
* Optional transfer of default values in field definitions.
* Identifies and transfers auto number field types.
* Command line interface.
* Easy install, uninstall and upgrade.
The license of this software is Freeware, you can free download and free use this database management software.