以编程方式安装名为Instance的Sql server 2005 [英] Installing Sql server 2005 named Instance programmatically

问题描述

我在Visual Studio 2010中开发了一个桌面应用程序，并在后端使用了MS Sql Server Express 2005。现在我正在为我的项目创建一个设置。我希望在安装软件时，在机器上安装一个命名的Sql Server实例，并在其上附加数据库文件。我查了一些文章，但找不到完整的解决方案。



如果有人可以帮我这方面的话。



先谢谢。



再见

Hi,

I have developed a desktop application in Visual Studio 2010 and used MS Sql Server Express 2005 at back end. Now i am creating a setup for my project. I want that a named instance of Sql Server be installed on the machine and database files attached to it when i install the software. I have checked some articles but could not find a complete solution.

Please if some one can help me in this regard.

Thanks in advance.

bye

推荐答案

我不建议安装SQL Server和使用C＃附加数据库。



这些是更多的sys准备/管理任务。我的建议是先与Tech谈谈。管理员有关安装SQL Server等的政策，指南等。



我相信他们会对此有意见。



就脚本和自动化而言，我建议使用PowerShell。



在Google上查看如何使用PowerShell安装SQL Server的命名实例，您应该找到许多提示。

I would not suggest to installation of SQL Server and attaching databases using C#.

These are more sys preparation / administrative tasks. My suggestion would be first talk with the Tech. Admins about the policies, guidelines etc. regarding installation of SQL Server etc.

I am sure they would have an opinion on it.

And as far as scripting and automation is concerned, I would suggest to use PowerShell for that.

Look on Google on how to use PowerShell for installing named instance of SQL Server and you should find many hints.

这篇关于以编程方式安装名为Instance的Sql server 2005的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！