Installshield 附加数据库

1, 安装设计视图中创建连接后,直接创建一个sqlscript

2, Sqlscript Code:
USE master;
GO
-- Drop database if it exists.
IF EXISTS (Select name FROM sysdatabases Where NAME = 'yourdatabase')
Drop DATABASE yourdatabase;
GO
Create DATABASE yourdatabase ON PRIMARY
(FILENAME =
'%TEXT_TO_BE_REPLACED_IN_THE_FILE%\database\yourdatabase_DATA.mdf')
LOG ON (FILENAME =
'%TEXT_TO_BE_REPLACED_IN_THE_FILE%\database\yourdatabase_LOG.LDF')
FOR ATTACH;
GO

3, 在text replacement 选项卡, Add Item '%TEXT_TO_BE_REPLACED_IN_THE_FILE%'  Replace TO [INSTALLDIR]

posted @ 2009-11-12 13:08  架构师聊技术  阅读(200)  评论(0)    收藏  举报