playground

.
Create

SQL Server was too expensive, migrated to Postgres

For this project, I had created a SQL Server RDS instance because I'm familiar with this database. But, apparently 1GB of RAM ain't enough for SQL Server, so i was paying a lot for extra processing (at least for me, it's a lot of money). Upgrading to 2GB of RAM wasn't particularly cheap either, so I opted for Postgres and kept 1GB RAM. Let's see how it goes before putting more effort into reducing costs. This project is still small, so the migration was fairly simple with a C# program that would connect to both SQL Server and Postgres, read all tables and transfer all the data. The postgres database and tables creation was done manually with EF Migrations.

1
0

Comments (0)

This post has no comments yet.