我创建了一个VB.NET应用程序，该应用程序与MS SQL Server 2008进行了交互，基本数据库文件是使用MS SQL Management Studio创建的， 现在我想将所有这些安装到为其创建的另一台PC上，但是我不想安装它们的SQL Management Studio，这是我需要知道的，如何在此处复制或安装我的DDL?
i have created a VB.NET application, which interacts with MS SQL server 2008, the basic data base file was created using MS SQL Management studio, Now i want to install all these to another pc, for which it is created but i dont want to install SQL Management studio their, this is what i need to know, how to copy or install my DDL there?
推荐答案我想将所有这些都安装到为其创建了它的另一台PC上，但是我不想安装它们的SQL Management Studio，这是我需要知道的 您无需在每个系统上都安装数据库.您需要确保通过给定的连接字符串在可访问的服务器上存在数据库. 有关更多详细信息，请单击此处:连接字符串 [ ^ ].上面的链接提供了有关连接字符串的所有信息. i want to install all these to another pc, for which it is created but i dont want to install SQL Management studio their, this is what i need to know You don''t need to install database on every system. All you need to make sure is database is present on an accessible server via given connection string. For more details, look here: Connection String[^]. The link above provides all info about connection string.
你好 有很多方法可以重新分发您的应用程序.最简单的一种称为XCOPY部署. 简而言之，您只需将程序文件和数据库mdf文件复制到目标PC并使用特殊的连接字符串即可. 看起来像这样: Hello There are many ways to redistribute your application. The easiest one is called XCOPY deployment. In a nutshell what your need to do is simply copy the program files and the database mdf file to the destination PC and use a special connection string. Something that looks like this: string conStr = "Data Source=.\SQLExpress; Initial Catalog=; Integrated Security=true; AttachDBFileName=" + Application.StartupPath + "\MyDb.mdf "
将sqlserver mdf文件存储在应用程序文件夹中的文件夹中使事情变得更加容易. 有关msdn的更多详细信息: msdn.microsoft/en-us/library/ms165716 (v = SQL.100).aspx [ ^ ] 瓦莱里.
It makes thing easier to make store the sqlserver mdf file in a folder within your application folder. More details on msdn: msdn.microsoft/en-us/library/ms165716(v=SQL.100).aspx[^] Valery.
更多推荐
如何将我的应用程序部署/安装到客户端?
发布评论