title: EF Core - Do SQLServer migrations apply to SQLite?
body: <p>I am having a simple project where I use initially SQL Server as backend with EF Core and Code-First approach (following this tutorial: <a href="https://docs.microsoft.com/en-us/ef/core/get-started/aspnetcore/new-db" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/ef/core/get-started/aspnetcore/new-db</a>) </p>
  
  <p>Now I want to switch the implementation to SQLite. I thought I could just run the initial migration for database creation from SQL Server and apply it to SQLite. Seems it doesn't work correctly: eg. auto-increment on primary key is not applied, then I see some inconsistencies (sqlite complaining about <code>'int'</code> which should be <code>'INTEGER'</code>), etc.</p>
  
  <p>So, does this mean that migrations are back-end dependent? If yes, shouldn't they be created in a nested folder then (eg. <code>./Migrations/SQLServer</code>)?</p>
  
  <p>Could anybody explain a bit more how this works?</p>
  
  <p>Note: Sorry, I am new to EF Code-First and migrations... thank you!</p>