Dear Readers: HWS has recently started a new project for the students of engineering ====> The Engineering Projects


Write at HWS !!!

Guest Posting

Thursday, February 3, 2011

Transfer MS Access Database To MySQL


Transferring database from one system to another is always a headache regardless of how big or small the migration scale is. Therefore, database managers, generally, look out for a simple tool which can perform export and import operations with all the variations involved. If you’re planning to migrate data from Access to MySql, you’d probably have a lot methods in mind to port databases. Before implementing any of them, try MS Access to MySQL. It is an ingeniously simple utility to quickly port Access database to user-defined MySql database.  While it supports a wide range of database formats, including, MDB, MDE, ACCDB, and ACCDE, it shows MySql database hierarchy to choose the destination database path. Furthermore, password protected (encrypted) databases can also be exported on the fly without having to decrypt them.
It allows two transfer modes - Direct transfer and Dump file creation. In direct transfer mode, you need to enter the host address, port, DB username and password along with DB name where data has to be directly ported, optionally, you can choose a local location to create SQL dump file for importing it later.

It has a simple wizard with 3-4 steps for transferring data. In the first step specify source database, second step refers to choosing transfer type. Depending upon the type, it will ask you to choose options in latter steps. In direct transfer mode, enter the all required information for establishing connection, specify DB name, and pick out the storage engine.
ss_destinationdatabase
In the last step of direct transfer, it will ask you to choose some database transfer-related options, such as, Transfer indexes and records, Include column list in INSERT, create tables, and so on. Depending upon the requirements, select the appropriate options and click Run Now to begin the process.
ss_options
Creating Sql Dump file needs nothing except specifying the target location where you want to save the Sql file. After the transfer is completed, it is recommended to thoroughly verify the the database migration including all the included tables with indexes to prevent any conflicts in the future. It works on Windows XP, Windows Vista, and Windows 7.

Download MS Access to MySQL

About the Author

I am XEO Hacker, the founder of Hack With Style (HWS). I am blogging since 2009 before that I just search things and now I am sharing my knowledge through this plateform.I'm also a freelance writer on topics related to Website Hacking,Website Optimization (SEO), blogger customizations and making money online.
In 41 people's circles

Subscribe To Get FREE Tutorials!


Respected Readers:
As a 21 year old student, the only income I rely on is my pocket money. Bearing the running costs of HWS Blog has become really difficult. We educate thousands of bloggers a week with our tutorials. To help us go forward with the same spirit, a small contribution from your side will highly be appreciated.

0 comments:

Confused? Feel free to ask

Your feedback is always appreciated. I will try to reply to your queries as soon as time allows.
Note:-
Please do not spam Spam comments will be deleted immediately upon my review.

Regards,
XEO Hacker

Post a Comment

Twitter Delicious Facebook Digg Stumbleupon Favorites More

 

Recent Posts

Join Me On Facebook

700+ Followers

Followers


meet women in Ukraine contatore visite website counter
DMCA.com

Recent Comments

Follow Me On Twitter

1112+ Followers