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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,654 questions
0 comments No comments
{count} votes

Accepted answer
  1. CathyJi-MSFT 21,081 Reputation points Microsoft Vendor
    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 100.8K Reputation points MVP
    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.