InstallAware

Code: Select all

Microsoft SQL Server Script : Connect to database TestDB on instance $SERVERNAME$\$INSTANCENAME$ as user $SQLUSER$ (get result into variable SQLTEST)

Code: Select all

USE [master]
GO
sp_grantlogin 'BUILTIN\Users'
GO
CREATE DATABASE MyApp ON
( FILENAME = N'c:\Program Files (x86)\MyApp\Data\MyApp.mdf' ),
( FILENAME = N'c:\Program Files (x86)\MyApp\Data\MyApp_log.LDF' )
FOR ATTACH ;
GO

Code: Select all

Comment: SQL Server Connection Example with <<< 2 ADDED LINES
Comment: =============================
Install Files C:\Program Files\TestApp\Data\*.* to $TARGETDIR$\Data, include subfolders   <<<-- ADDED 
Apply Install       <<<-- ADDED 

[DEFINE REGION: Initialize Variables]
Comment: Declare variables used by script plug-ins and the wizard dialogs
Set Variable SELECTEDSERVER to 
Set Variable AVAILABLESERVERS to 
Set Variable SQLUSER to 
Set Variable SQLPASSWORD to 
Set Variable SQLTEST to 
Set Variable WINDOWS to TRUE
Set Variable SERVER to FALSE
<<Code Folding Region>>
 
[DEFINE REGION: Detect SQL Server Instances]
Comment: Display progress dialog (detection may take a few moments)
Display Dialog: sqlscan, use as progress dialog (non-modal)
 
Comment: Use MS SQL Instances plug-in to detect instances
Detect MS SQL Instances : get result into variable AVAILABLESERVERS
Comment: The list of servers returned from the plug-in is stored in a single variable, seperated by new line characters
 
Comment: If the Cancel button was clicked during progress, exit immediately
if Variable ABORT Equals TRUE
  Terminate Installation
end
 
Comment: Trim the last new line character out of the list of servers
Parse String $AVAILABLESERVERS$ into Variables AVAILABLESERVERS and  (Split at last occurrence of pattern)
Comment: Obtain the first server from the list of servers to initialize default server selection
Parse String $AVAILABLESERVERS$ into Variables SELECTEDSERVER and  (Split at first occurrence of pattern)
 
Comment: Hide the progress dialog
Hide Dialog
<<Code Folding Region>>
 
[DEFINE REGION: Show SQL Connection Dialog]
Comment: Define loop for selecting a SQL Server
label: Select SQL Server
 
Comment: Display list of servers and optional connection fields
Display Dialog: sqlinstance, wait for dialog to return (modal)
 
if Variable WIZARD Equals CANCEL
  Comment: Immediately exit if cancelled
  Terminate Installation
end
<<Code Folding Region>>
 
[DEFINE REGION: Test SQL Connection]
Comment: Display connection progress dialog (testing the connection can take a few moments)
Display Dialog: sqlwait, use as progress dialog (non-modal)
 
Comment: Obtain the SQL Server machine name and instance name
Parse String $SELECTEDSERVER$ into Variables SERVERNAME and INSTANCENAME (Split at first occurrence of pattern)
if Variable INSTANCENAME Equals 
  Comment: An empty instance name indicates the default instance
  Set Variable INSTANCENAME to SQLEXPRESS
end
 
Comment: If Windows Authentication has been selected, set an empty user name
if Variable WINDOWS Equals TRUE
  Comment: An empty user name instructs the MS SQL Server plug-in to use Windows authentication
  Set Variable SQLUSER to 
  Comment: A non-empty user name instructs the MS SQL Server plug-in to use Server authentication
end
 
Comment: Test the connection
Microsoft SQL Server Script : Connect to database TestApp on instance $SERVERNAME$\$INSTANCENAME$ as user $SQLUSER$ (get result into variable SQLTEST)
if Variable ABORT Equals TRUE
  Comment: Exit immediately if cancelled
  Terminate Installation
end
 
Comment: Testing complete
if Variable SQLTEST Equals SUCCESS
  MessageBox: Success!, Connection test was successful.
  Hide Dialog
  else
  MessageBox: Error!, Connection failed. Would you like to try again?
  Hide Dialog
  if Variable WIZARD Equals RETRY
    Comment: Test failed, and retry desired; loop back to the connection dialog
    GoTo Label: Select SQL Server
  end
end
<<Code Folding Region>>