Migrating data between different types of databases is not a trivial task. In this article, we will compare several ways of converting from SQL Server to PostgreSQL.

Microsoft SQL Server is a great database engine, but it has drawbacks in some cases.

Free Microsoft SQL Server Express can be used successfully for small databases.

Limitations of SQL Server Express:

• 1GB maximum memory used by the database engine.
• 10GB maximum database size.
• 1MB maximum buffer cache.
• CPU the lesser of one (1) socket or four (4) cores (number of SQL user connections NOT limited).

For large databases, you may need to get the paid version of the MSSQL Server, starting with the Standard edition license. The cost of the SQL Server depends on the number of users and the size of the database.

If you can’t even afford a standard SQL Server license, PostgreSQL is an alternative.

PostgreSQL is completely free, so the license cost is the main advantage of PostgreSQL over Microsoft SQL Server.

#data migration #data conversion #data synchronization #pandas