如何安装SQL Server数据库安装应用程序的时间 [英] how to install SQL server database time of install my application

查看:89
本文介绍了如何安装SQL Server数据库安装应用程序的时间的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

如何创建安装文件以安装SQL Server数据库以及我在c#(vs2005).net 2.0中的应用程序.

How to create setup file to install SQL Server Database along with my application which is in c#(vs2005) .net 2.0

推荐答案

也有第三方安装包管理器,使您可以这样做.我建议使用的是"Install Shield",您肯定已经看过很多软件,甚至您的驱动程序包都是使用install Shield制作的.

如果要制作自定义安装包,则必须创建数据库的查询文件,例如testsql.sql,
用以下几行来编程.bat文件

SQLCMD -S%1" -i C:\ testsql.sql

在安装包中,根据需要在安装后/安装前执行.bat文件.

但是在两种情况下,都必须在系统上预安装SQL客户端/服务器,以便可以在运行的实例上创建目录
there are also third party installation package managers, which allow you to do so. the one i recommend is "Install Shield", you must have seen a large verity of software, even your driver packages are made using install Shield.

if you are making a custom installation package then you have to create query file of your database eg testsql.sql,
program a .bat file with following lines

SQLCMD -S "%1" -i C:\testsql.sql

in your installation package, execute that .bat file after/before installation as you require.

but in both cases, SQL client/server must be pre-installed on system, so the catalog can be made on the running instance


这篇关于如何安装SQL Server数据库安装应用程序的时间的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
相关文章
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆