如何部署WindowsApplication和SQLDatabase
问题描述:
我正在VS 2008和SQL 2005中开发Windows应用程序.我要在其中部署带有数据库的项目,并且还要更改与客户端SQL数据库的连接字符串...
I am developing windows application in VS 2008 and SQL 2005 . I want deploy the project with database in it and also change the connection string with client SQL database ...
答
请参阅此分步过程以创建一个设置和部署项目
http://aspalliance.com/622_StepbyStep_Process_of_Creating_a_Setup_and_Deployment_Project.all [使用安装程序类轻松部署SQL Server数据库 [
See this Step-by-step process to create a setup and deploy your projects
http://aspalliance.com/622_StepbyStep_Process_of_Creating_a_Setup_and_Deployment_Project.all[^]
and this article for easy deployment of sqlserver databases
Deploy SQL Server databases easily with an Installer class[^]
希望 ^ ]可能会对您有所帮助.
Hope this[^] might help you.
您需要包括一个用于安装数据库的应用程序,或者一旦用户为您提供了连接字符串,就可以恢复您随应用程序一起提供的备份.除非您使用支持它的安装程序,否则我认为您的安装程序无法为您安装数据库到SQL Server.
You need to include an app that installs your DB, or once the user has given you a connection string, restores the backup you ship with your app. Unless you''re using an installer that supports it, I don''t think your installer can install the DB to SQL Server for you.