3

I have an ASP MVC-application that uses a SQL server express for and Forms authentication. The server I'm using does not have enough memory to run SQL Server express stably and I was thinking about migrating to SQLite instead.

Is it possible to just migrate the existing aspnetdb-database from SQL Server to SQLite so that all my user accounts will be kept?

murgatroid99
  • 19,007
  • 10
  • 60
  • 95
Freddy
  • 1,705
  • 3
  • 13
  • 16

1 Answers1

1

These shall help you perform such task:

  1. SQLite Converter Tools
  2. SQL Maestro (This one's not free though)
  3. A good migrating tool project from Code Project
  4. SO: convert sql-server *.mdf file into sqlite file

So, I guess that if such tools exist, it will then be possible to keep your data.

For security, perform a backup from your DB first!

Community
  • 1
  • 1
Will Marcouiller
  • 23,773
  • 22
  • 96
  • 162