SQL Script

[Lin]

I am wondering if there is any good way to the location of the master databse mdf and ldf files in InstallAware.
I need this location in order to install my other database files that I need to attach.

Thanks

[BrandonK]

Lin,

My install runs a SQL script to create the app database from scratch. It finds the path to master.mdf using the code below.

Not sure how you could do this in IA script; SQL scripting isn't my strong suit. Maybe run the first half in an IA "MS SQL Server" action and return @SQLDataPath into an IA variable?

Code: Select all

DECLARE @SQLDataPath AS NVARCHAR(256)
SET @SQLDataPath = (
	SELECT SUBSTRING(physical_name, 1, CHARINDEX('master.mdf', LOWER(physical_name)) - 1)
	FROM master.sys.master_files
	WHERE database_id = 1 AND file_id = 1
	)

EXECUTE ('
	CREATE DATABASE [YOUR_DB_NAME]
	ON (
		NAME = ''YOUR_DB_NAME'', 
		FILENAME = ''' + @SQLDataPath + 'YOUR_DB_NAME.mdf'', 
		SIZE = 3072KB , 
		MAXSIZE = UNLIMITED, 
		FILEGROWTH = 10%
		) 
	LOG ON (
		NAME = ''YOUR_DB_NAME Log'', 
		FILENAME = ''' + @SQLDataPath + 'YOUR_DB_NAME.ldf'', 
		SIZE = 1024KB , 
		MAXSIZE = 1GB , FILEGROWTH = 10%
		)
	COLLATE SQL_Latin1_General_CP1_CI_AS
	')
GO

Hope this helps,
Brandon