部署Windows应用程序和SQL数据库 [英] Deploying windows application and sql database

问题描述

Hello All;



我使用Visual Studio 2010和MS-SQL Server 2008创建了一个小型.Net Windows应用程序。数据库将驻留在用户身上机器也是。



我需要一种方法来更新用户机器上已安装应用程序的结构，例如数据库表，视图，函数，......和也* .dll在此期间组装。



用户需要一个部署计划，让他/她在保留他/她的数据库的过程中安装和卸载应用程序，并在下次安装时使用此数据库。



任何帮助和建议都将受到高度赞赏。



提前致谢，

杰克。

解决方案

对于应用程序，您需要创建一个dot.Net包，在创建包后，您将找到

所有必要的DLL和文件将集成在包内，你需要做什么，你必须安装t客户端PC中的程序包。



对于DB相关的更改，你必须为表创建alter脚本，需要在客户端DB中执行。

您好，

如果您正在创建小型应用程序，那么您可以选择SQL SERVER 2005或者可能是2008.

另外对于客户端PC，您可以安装SQL SERVER客户端版本2005.



如果您将此用作商业用途，可能会有一些许可证因素。

检查此http ：//msdn.microsoft.com/en-us/sqlserver/ff658533.aspx

Hello All;

I have created a small .Net windows application using Visual Studio 2010 and MS-SQL Server 2008. The database will be reside on the user machine too.

I need a way to update the structure of the installed application on the user machine such as the database tables, views, functions, ... , and also *.dll assembles during the time.

As well user needs a deployment plan that let him/her install and uninstall the application during the time keeping his/her database, and use this database at the next installations.

Any help and suggestions would be highly appreciated.

Thanks in advance,
Jack.

解决方案

For Application you need to create a dot.Net package, after creating a package you will find
all the necessary DLL & files will be integrated inside the package, what you need to do, you have to install this package in Client PC.

for DB related changes, you have to create alter script for Tables , Procedure & need to execute in client DB.

Hi,
If you are creating small application then you can opt SQL SERVER 2005 or may be 2008.
Also for client PC, you can install SQL SERVER client version of 2005.

There might be some license factor if you are using this for commercial purpose.
Check for this http://msdn.microsoft.com/en-us/sqlserver/ff658533.aspx

这篇关于部署Windows应用程序和SQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！