使用SQL SERVER数据库在Visual Studio VC#Windows窗体部署中需要帮助 [英] Need Help in Visual Studio VC# Windows Form Deployment with SQL SERVER Database

问题描述

大家好，

我正在使用 VC#在 Windows窗体中编写一个项目，并已与 SQL SERVER 作为后端数据库.

I am writing a project in Windows Forms using VC# and have done connectivity with SQL SERVER as back end  database.

SQL SERVER 2014& Visual Studio 2013

我正在使用 InstallShield 构建同一项目的安装程序，我想使用该安装程序部署数据库，因此客户端不必安装 SQL Server &恢复数据库以存储新数据.

I am usingInstallShield to build setup of the same project, i want to deploy the databases with the setup so the client will not have to install SQL Server & restore the database in order to store the new data.

连接字符串在客户端PC中也将有所不同，并且我在.exe中转换项目后无法更改它

also the connectionstring will be different in the client PC and i cannot change it after i convert the project in .exe

请为我提供一种方法，使我可以仅向客户端提供安装程序，并且在安装过程中，安装程序将自行完成其余的工作.

please suggest me a way so that i can provide the client only with the setup and in the installation process the setup will do the rest by itself. 

推荐答案

要无人值守安装SQL Server，请参阅:

To install SQL Server unattended see:

使用配置文件安装SQL Server 2016
https://msdn.microsoft.com/en-us/library/dd239405.aspx

Install SQL Server 2016 Using a Configuration File
https://msdn.microsoft.com/en-us/library/dd239405.aspx

如果可以从命令提示符下使用配置文件启动setup.exe，则可以从另一个安装程序启动它.

If a setup.exe can be launched with a configuration file from a command prompt, then it can be launched from another setup.

InstallShield提供了可用于任何事情的自定义操作(执行文件，修改已部署文件的连接字符串或生成具有自定义内容的文件等):

InstallShield provides custom actions that can be used for anything (execute a file, modify the connect string of a deployed file or to generate a file with custom contents, etc.):

使用自定义操作
http://helpnet.flexerasoftware.com/installshield21helplib/helplibrary/IHelpCustomActions.htm

Using Custom Actions
http://helpnet.flexerasoftware.com/installshield21helplib/helplibrary/IHelpCustomActions.htm

这篇关于使用SQL SERVER数据库在Visual Studio VC#Windows窗体部署中需要帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！