0

Is there any SQLite Administration Tool which provides System.Data.SQLite encryption support other than SQLite Expert Professional?

I'm asking this because the SQLite Expert Professional app throws errors when trying to create foreign keys.

Improve this question

3 Answers 3

Reset to default
2

SQLite2009 Pro Enterprise Manager - it's free and works for my system.data.sqlite encrypted databases (pick 'Compatible with ADO.NET provider' when entering db key) http://sqlite2009pro.azurewebsites.net/

My manager of choice is the FireFox SQLite Manager extension, but this doesn't support encryption yet...

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

3 Comments

Thank you Jim for the answer. I have tried SQLite 2009 Pro Enterprise Manager and it is not compatible with the encryption within the latest System.Data.SQLite that I'm using (1.0.94). It always throws the "file is encrypted or not a database" error.
It does that with me too - I click OK then it brings up a window allowing me to type in the encryption key and select the type (ADO.NET provider seems to work)
As of 2020 it looks dead as a doornail.
1

https://sqlitestudio.pl/index.rvt?act=download

i have found this one really helpful as well as free and very very convinient...

Improve this answer

Comments

-1

You can try DataDevelop it uses the current System.Data.SQLite library that supports encryption via Password either in clear-text or binary.

Improve this answer

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.