使用 SQL Server 数据库安装发布 ASP.Net Web 应用程序
我的要求是部署一个 ASP.NET 应用程序，其中有一个核心库类项目、服务层和 UI 层，使用 SQL Server 数据库作为后端。
我的客户需要使用一些 MSI 或 EXE 来部署它，他/她应该能够自定义 IIS 和 SQL Server 的安装。
我想说的是，当我执行EXE时，它会询问我对IIS的基本要求，如服务器名称、虚拟目录名称、应用程序池等，然后自动将其部署到那里。现在它还应该对 SQL Server 数据库安装提出相同的要求，例如服务器名称、身份验证、数据库名称等等...
我已经尝试过，但我可以设法部署 ASP.NET 应用程序，但无法自定义 SQL Server 安装。 还告诉一个可行的解决方案，因为我的数据库大小在6GB左右。为此创建安装程序的优化方法是什么？
My requirement is to deploy an ASP.NET application in which I have a core library class project, service layer and a UI layer, using SQL Server database as backend.
My client needs to deploy it using some MSI or EXE, in which he / she should able to customize the installation to IIS and his SQL Server.
What I want to say, when I execute the EXE, it will ask me the basic requirement for the IIS like server name, virtual directory name, app pool etc , then automatically deploy it there. Now it should also ask the same for SQL Server database installation like server name, authentication, database name and so on....
I have tried but I can manage to deploy ASP.NET app not able to customize the SQL Server installation.
Also tell a feasible solution, as my database size is around 6GB. What will be optimized way to create a installer for that?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我曾经不得不做类似的事情，但我的数据库要小得多。
我将数据库编写成 T-SQL 语句以便从头开始创建，并将其存储在文本文件中。
然后，我编写了一个 .NET Windows 应用程序，它会提示用户输入 SQL Server 网络位置和凭据信息。该.NET应用程序将数据库创建SQL文本文件作为资源文件包含在可执行文件中，并且将连接到指定的SQL Server并一一执行文本文件中的命令。我能够读取文本文件并通过对关键字“GO”（换行符）进行定界来解析命令。
I once had to do something similar but my database was much smaller.
I scripted out my database into T-SQL statements for its creation from scratch and stored those in a text file.
I then wrote a .NET windows app that would prompt the user for SQL Server network location and credential information. This .NET application had the database creation SQL text file included in the executable as a resource file, and would connect to the specified SQL Server and execute the commands in the text file one by one. I was able to read the text file and parse commands out by delimiting on the keyword "GO"(linebreak).