且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在同一台机器上与其他用户共享 SQL LocalDb?

更新时间:2023-12-02 11:48:46

问题是 LocalDB 作为当前用户拥有的进程运行,这意味着每个用户都运行自己的 LocalDB 实例.这就是使其零配置且非常易于使用的原因.不幸的是,这也意味着很难拥有一个共享的 LocalDB 实例.我遇到了类似的问题,只是改用 SQL Express 来处理我在开发中需要多个用户访问的数据库.

The problem is that LocalDB runs as a process owned by the current user, meaning each user runs their own instance of LocalDB. This is what makes it zero configuration and very easy to work with. Unfortunately, it also means it's difficult to have a shared LocalDB instance. I was running into a similar issue, and just switched to using SQL Express for a db I needed accessible by multiple users in development.