Frequently asked questions about MyDB Converter
Q: When converting a database from Access to MySQL, will MyDB Converter carry over the indexes set in each table in Access?
A: Yes, MyDbConverter supports Access indexes and will carry over the indexes embedded within each table of the Access database to MySQL.
Q: Are there any constraints on number of fields or number of records in the conversion process? I have some fairly large tables.
A: There is no limitation to the number of fields or the number of records.
Q :I want to convert MS Access tables into MySQL which is running on Linux. Is your product designed to connect from windows box to Linux server?
A: You can convert your MS Access DB to MySQL running on Linux by following these steps:
Run MyDB Converter on the windows Machine and select to convert from Access to MySQL.
In the "Connect to MySQL server" step, provide the connection information as follows:
- Host: The IP of the Linux machine if you are connecting via a LAN or the URL of the MySQL server if you are connecting through the internet.
- Port Number: The port number that MySQL Accepts the connections on, (use the default value for most cases).
- Your user name and password, please note that the this user account must have the appropriate privilege.
- Select the target MySQL database.
You can test the previous steps with the demo version as well.
Q:What is Synchronization and why is it important?
A: Synchronization is a new feature in MyDbConverter3.0. Synchronization enables you to merge any changes made within the Access database into the existing target MySQL database. Synchronization is strongly recommended if you would like to import Access tables into an existing MySQL database whilst leaving the existing data and structure untouched.
Q: I'm trying to convert a (local) Access database to a (remote) MySQL database. What value (and its format) should I enter into the "Host" field when connecting to MySQL? Do I need to change the port number?
A: For a remote connection to MySQL server you should consider the following:
- First, You should make sure that the remote server you are trying to connect to allows remote connections. Some server disable remote connections for security reasons.
- If your server allows remote connections, ask for the exact connection info: Server name, user name, password and port number used.
- And finally, make sure that you have enough privileges to Create/Drop tables or databases as required by the conversion process.
Q: I have previously created a scheduled task to run periodically. How can I disable, delete or edit this task?
A: Simply open the window’s control panel, select the scheduled tasks item and double click on the task you want to edit. This will open the task properties window where you can change the task settings.
Q: I am using windows 2000/XP. The task is created successfully but it doesn't run?
A: You may need to supply you windows user name and password. In case of windows XP or windows 2000 the windows task scheduler will not run the task unless you supply a user name and password (Windows account) in the task properties window.
If you have any other questions, please contact our support team at:
support@softguru.net
|
