Develop with SQL Server and change to PostgreSQL later

asp.net-core-2.2 entity-framework-core postgresql-11 sql-server

Question

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

1
1
2/4/2019 5:56:40 AM

Accepted Answer

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.

1
2/4/2019 5:56:56 AM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow