Hello coders, this blog post provides information about conversion of MS Access Database to MySQL database. First of all, here is a brief overview of the need to migrate .mdb file to .sql file.
- Microsoft Access is used as Database Management System (DBMS) for Windows Desktop Applications. Now, suppose that you have created a similar application on Web and you want to use same database as used in Windows Application.
- You can not use the database created in Microsoft Access on Web Server as it is. You have the following options for using the same database for your Web Application.
Now, we will explain how to migrate .mdb file (MS Access database) to .sql file.
- Microsoft Access is used as Database Management System (DBMS) for Windows Desktop Applications. Now, suppose that you have created a similar application on Web and you want to use same database as used in Windows Application.
- You can not use the database created in Microsoft Access on Web Server as it is. You have the following options for using the same database for your Web Application.
- Using Microsoft SharePoint – MS Access can be used on SharePoint to build Web Database Applications.
- Migrating MS Access database to Web based database, i.e, MySQL, MS SQL Server or others. This post discusses about this method.
Now, we will explain how to migrate .mdb file (MS Access database) to .sql file.
