1. You can put sql script in "SQLScript" folder.

NOTE: 	For db script seperated by GO, the first line of the script must be "--fiesGO". 
		And Script seperated by GO must end with GO  
	For db script - unbreaken,line by line commands only (insert and delete commands 	in a single line)
	the first line must be "--fiesLineByLine" 	
	[string case insensitive]
*******************************************************************************************
2. Put the product dll files in "Application" folder.

*******************************************************************************************
3. AppCfg notepad:
AppCfg notepad can be used to modify installation wizard needs to work.
Following are the commands AppCfg notepad with explanations.

*******************************************************************************************
AppName: The name providing in this field will reflect as windows caption of the setup wizard.

*******************************************************************************************
DBFolder: It is to mention the folder name in which we keep product database files. Setup will create a folder in the root folder of the application with the name given in the DBFolder field to keep Database related files in it.

*******************************************************************************************
DBScript: As it was told earlier, the scripts to be ran need to place in the SQLScript folder of setup folder. DBScript field is for mentioning the order in which script has to be ran. We can mention the name of the script one by one in the "DBScript" field.
for eg:
script 1.sql
script 2.sql
script 3.sql likewise

NOTE: Please note that the file name should have the suffix ".sql"

*******************************************************************************************
AppFolder: User can mention a folder name here. Setup wizard will create a folder with this name inside the root folder to keep the product dll files.

*******************************************************************************************
SystemDSN: We need to mention the connection string here for ODBC connection for the product. 
The format of the string is as follows: Backendserver,dsnname,dbname,dsnlogin,dsnpassword
<Driver>,<DSNname>,<Databasename>,<Username>,<password>
For MAGNOLIA :{SQL Server,admindsnv2, adminv2, admin, fiesadmin003}
For ANDROMEDA:{SQL Server,hmsdsnv2, hmsv2, fieshmsv2, hfiesmsv2}
For ALBATROSS:{SQL Server,accountsdsnv2, accounts, accounts, accounts}
For ALBATROSS:{SQL Server,reservationdsnv2, reservation, reservation, res}
For HRMS     :{SQL Server,payrolldsnv2, payroll, sa, fiessystems}

*******************************************************************************************
RegnLocation: This section given for folder specic registration, that is if this section specified setup will only register files and subfolders under specifid folders only
              If this section not specified then setup will register entire application folder
<path\foldername>

*******************************************************************************************
SpecialRegn: If there are any dlls or ocxs to be registered or copied under System 32 folder of Windows,then we need mention those file names here. Make sure that the those files exist in the application setup under "SpecialRegn" folder.

(eg: if we need to copy and register crpaig32.dll in System folder, then it can be mentioned like below.)
Special Regn
{
crpaig32.dll
}

*******************************************************************************************
ShotCut: Can provide the shortcut path here.
<\path\filename>,<special folder (eg.Desktop/startmenu)>, <Shortcut Name>
For MAGNOLIA :{/Magnolia.exe,Desktop,Magnolia}
For ANDROMEDA:{/Main.exe,Desktop,Andromeda}
For ALBATROSS:{/Main.exe,Desktop,Albatross}
For HRMS     :{/MV3Main.exe,Desktop,HRMS}
NOTE: If special folder is Start menu, subfolders will be created under it.

*******************************************************************************************
WriteSettings : this section can be used to create settings files to installation location.

<\+path+filename> : this part will specify the file name and path inside application folder. file name can be any type which must be posssible to edit from a notepad.if this file already exists it will replace existing file.

<string> : this part will directly copied to the corresponding files.

<server/username/password> : this is an optional part. These are treated as variables which will be interpritted to original value during installation. if youdont want just put it as blank.

{
<\+path+filename>,<string>,<server/username/password>
\Hrmssettings.txt,servername =:,Server
\Hrmssettings.txt,servername =:,Server
\Hrmssettings.txt,99999999999999999999,
\Hrmssettings.txt,888888888888,
\Hrmssettings1.txt,888888888888,
}