In this blog, we are going to learn the procedure to migrate a SQL Server database in an ASP.NET MVC application to MySQL and PostgreSQL.

All three, Microsoft SQL Server, MySQL and PostgreSQL, are relational database management systems (RDBMS). MSSQL is developed and maintained by Microsoft, whereas MySQL and PostgreSQL are open-source software. MySQL is maintained by Oracle.

PostgreSQL is an advanced, enterprise-class, and open-source object relational database management system (ORDBMS) that supports both SQL and JSON querying. It provides good performance along with low maintenance.

Reasons to choose MySQL

The following are reasons for someone to choose MySQL for their database needs:

• It needs less operational storage space.
• As it is open-source software, it is free to use.
• It allows the database files to be accessed and manipulated by different processes at runtime.

Reasons to choose PostgreSQL

• It is open-source software and free to use.
• It supports a concurrency management system. This allows you to access and manipulate multiple processes at the same time.

These are some of the reasons for developers to choose or migrate from MSSQL to MySQL or PostgreSQL. Let’s proceed with the steps involved in the migration process.

Prerequisites

In this blog, I am using Visual Studio to develop my application. Be sure that these necessary software packages are installed in your machine:

• Visual Studio 2019 (16.4.6 or higher)
• SQL Server 2017
• MySQL Workbench 8.0
• MySQL Community Server 8.0
• pgAdmin 4

#asp.net mvc #sql #web #database #mysql #postgresql #productivity