Search code examples
sql-serverentity-framework-coreasp.net-core-2.2postgresql-11

Develop with SQL Server and change to PostgreSQL later

I need to build an application with ASP.Net Core 2.2 MVC, EF Core and use SQL Server Local db during development.

However, when ready to deploy the app, I'd like to include the dependencies of PostgreSQL 11 into the project and point the project to use PostgreSQL rather than SQL Server .

Is this approach a viable approach that I can easily swap one database to another using EF Core or should I start with PostgreSQL from start?

Thank you in advance.

..Ben

Solution

  • It is a viable approach, but you can't use any SQL Server or PostgreSQL-specific features.

    If you intend your program to continue to support both databases, then keep developing in either, but be aware of not using SQL Server specific features.

    If you only indent to use PostgreSQL in the future, then you should develop using it. It is free, so you can easily install a local version for development.