On this page you can find the most frequently asked questions regarding
Access-to-MySQL converter. If your question is not answered here, please contact
us at support@convert-in.com
What kind of Microsoft Access data is migrated to MySQL?
Access-to-MySQL converts table definitions with all necessary attributes,
records, indexes and relationships. It does not convert forms, queries,
embedded functions and Visual Basic scripts.
Go to Top
Does Access-to-MySQL require ODBC drivers?
No, Access-to-MySQL converter does not require ODBC drivers.
Go to Top
Why migrate from Microsoft Access to MySQL?
1. Performance. According to many benchmarks MySQL shows one of the best
performances among DB2, Oracle and SQL Server 2000. MySQL is used by lot of
organizations that demand high performance and stability.
2. Cross-Platforming. One of the most advantages of MySQL is its
cross-platform capabilities. You can develop your database on a Windows
laptop and then deploy on Windows or Linux server. It gives you incredible
flexibility when choosing server platform.
3. Multiple users access. Microsoft Access supports data sharing but
it has not enough power to handle many simultaneous users. This application has
been designed as data manager for local use and that is what it is good for.
MySQL is a real client-server database environment that can handle many
simultaneous connections.
4. Security. Although Microsoft Access provides some capabilities to protect
the data, they are optional and it is easy to bypass them. MySQL provides
strong security system and anyone willing to access the data must know MySQL
user name and password.
Go to Top
Does Access-to-MySQL support automation?
Access-to-MySQL converter does not support automation directly. However, there
is console version of the program a2sagent.exe in the installation directory.
It supports command line arguments and can be called from any script. So,
it is possible to write a simple batch script and execute it recurrently using
any Windows scheduler. Please refer to 'Command line' article of the product
documentation for the further information.
Go to Top
