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?

0

1 Answer 1

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!

Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.