Portable SQL version as SQLite

ImDevA 21 Reputation points
2022-08-18T12:16:16.777+00:00

Hello.

Does Microsoft's have portable SQL version similar as SQLite?

I view that have LocalDb into SQL Express version, but i think that is only for development and not to create a portable .net software with portable database.
And the version of SQL Compact Edition for which it's deprecated.

Thanks

SQL Server | Other
0 comments No comments
{count} votes

Answer accepted by question author
  1. CathyJi-MSFT 22,401 Reputation points Microsoft External Staff
    2022-08-19T07:11:36.717+00:00

    Hi @ImDevA ,

    As far as I know, the answer is No.

    SQL server is different from SQLLite. Refer to the blog Differences between SQL and SQLite to get details.


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


1 additional answer

Sort by: Most helpful
  1. Erland Sommarskog 128.7K Reputation points MVP Volunteer Moderator
    2022-08-18T22:01:29.35+00:00

    You could bundle localDB with your application, but it will make setup a little more complicated.

    Then again, I am under the impression that Windows comes with SQLite, but maybe I'm confused.


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.