如何使用数据库部署c＃window应用程序 [英] How to deploy c# window application with database

问题描述

亲爱的朋友们，

我使用visual studio 2012，c＃和SQL server 2012开发了一个窗口应用程序。该项目已经完成并经过测试。但现在我想用sql serve数据库部署我的项目，以便我的客户端可以在他的系统上安装它。请问我该如何解决这个问题，以便数据库将与我的客户端计算机上的应用程序一起安装。



我尝试了什么：



我已经尝试将数据库添加到我的解决方案探索中但它无法正常工作

解决方案

您好，请参考下面的链接，它将真正帮助您解决问题，

1. 部署应用程序和数据库 [ ^ ]

2. 如何使用sql server数据库部署c＃windows应用程序 [ ^ ]

3.使用sql server数据库 C＃应用程序部署？ - 堆栈溢出 [ ^ ]

4. c＃ - 如何使用SQL Server数据库部署或发布Windows应用程序 - Stack Overflow [ ^ ]

并参考以下安装程序，

1. 高级安装程序 - 配置数据库SQL脚本 [ ^ ]和 SQL数据库 [ ^ ]

2. Installshield

我不建议使用SQL Server。这是一项艰苦的工作。

如果您希望执行完全自动化，则需要解决以下问题：



1.检测不同版本的操作系统：XP，Win7，Win8，Win10

2.检测.NET Framework的存在

3.执行所需的.NET Framework安装

4.检测32位或64位操作系统

5.需要包含各种版本的SQL Server安装文件。

6.需要为不同版本的SQL Server附加正确的语法，用于无人值守的自动安装。



我个人更喜欢SQLite或MySQL，安装过程要简单得多。

Dear friends,
I developed a window application using visual studio 2012, c# and SQL server 2012. The project is already completed and tested. But now I want to deploy my project with sql serve database so that my client can install it on his system. Please how can I go about this so that the database will install with the application on the my client machine.

What I have tried:

I have try to add the database to my solution explore but it is not working

解决方案

Hi, refer the links below, it will really help you to solve your problem,
1. Deploy your Application and Database[^]
2. How to deploy c# windows application with sql server database[^]
3. C# application deployment with sql server database? - Stack Overflow[^]
4. c# - How to deploy or publish Windows app with SQL Server database - Stack Overflow[^]
And refer the following installers,
1. Advanced Installer - Configuring Databases with SQL Scripts[^] and SQL Databases[^]
2. Installshield

I don't recommend using SQL Server. This is a hard work.
If you wish to perform a full automation, you need to cover the following issues:

1. Detection of different version of OS: XP, Win7, Win8, Win10
2. Detection of existence of .NET Framework
3. Perform installation of required .NET Framework
4. Detection of 32 bit or 64 bit of Operating System
5. Need to include various version of installation files of SQL Server.
6. Need to append the correct syntax for different version SQL Server for unattended automatic installation.

I personally prefer SQLite or MySQL, which the installation process is much more simpler.

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