如何使用vb.net在SQL Server上安装新实例 [英] How to install new instance on SQL Server using vb.net

问题描述

我的应用程序可以通过sa密码创建新实例(例如MyInstance)并将数据库附加到该实例吗?

如果可能的话，请给我vb.net代码.

非常感谢.

Hi,
Is there nay way that my application could create a new instance (say MyInstance) and attach my DB to that, with sa password?

Please give me vb.net code for it if possible.

Thanks a lot.

推荐答案

不太实际-SQL Server需要大量的设置，用户需要做出很多决定. > 此外，扩散SQL Server实例是一个非常糟糕的主意-如果没有别的，它就消除了使用SQL Server的主要优势-多用户访问.如果您在每个PC上编程安装新实例，则每个PC将使用一个单独的数据库，没有共享信息.有很多简单，快捷的方法可以做到这一点.

Not really practical - SQL server needs a fair amount of setup, with quite a few decisions needing to be made by the user.
Besides, it is a very bad idea to proliferate SQL server instances - if nothing else, it removes the main advantage of using SQL Server - multiuser access. If you program installs a fresh instance on each pc, then each pc will use a separate database, with no shared information. There are much simpler, quicker ways to do that.

这篇关于如何使用vb.net在SQL Server上安装新实例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！