Is it possible to migrate a database in SQLserver to SQLlite using EF Core?

Question

Hey guys, I'm following the dotnet beginner tutorial series: https://www.youtube.com/watch?v=moRmKo3nrN4 In this video he states he has already written context and model classes, which leads me to believe he didn't migrate it over. However, it's the same DB he used in the previous 3 videos. The video is also a year old, so I'm not sure if EF Core made it possible to migrate an SQL Server DB to SQLlite. Any help would be appreciated

Answer 1

Hi @christopher.fernandez ,Welcome to Microsoft Q&A.

In Entity Framework Core (EF Core), you can migrate a database from one supported database engine (such as SQL Server) to another supported database engine (such as SQLite) by using database migrations.

But you may need to read this document before migrating:SQLite EF Core Database Provider Limitations.

You can also refer to this link:EF Core - Do SQLServer migrations apply to SQLite?.

Best Regards,

Jiale

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.