Install Guide

This script le contains script for Customize Data values.
Provide the database server name while executing the following script. An error is displayed, if you do not enter the server name.
NOTE:
---- Customize Script
Use RapportDB
Go
SET IDENTITY_INSERT [dbo].[License] ON
INSERT [dbo].[License]
([LicenseID], [Sales], [UnActivated], [Code], [License], [Utilize], [NumberOfClients],
[VendorID])
VALUES
(1, N'7V931PHY08K01LZHYXWKKP6GQ1', N'BR69T51SSP500PFW9W4R0Z0TL5', NULL, NULL, NULL, NULL,
NULL)
SET IDENTITY_INSERT [dbo].[License] OFF
GO
SET IDENTITY_INSERT [dbo].[sysHash] ON
INSERT [dbo].[sysHash] ([ID], [Hash]) VALUES (2,
0x4458473935334D31513034525254524643475338343442485836)
SET IDENTITY_INSERT [dbo].[sysHash] OFF
Go
Begin
Declare @DBServerName varchar(200) = ''
Set @DBServerName = ''
If (@DBServerName is null or @DBServerName = '')
Begin
RAISERROR(N'Database Server Name Should not be Empty...', 16, 1)
End
Else
Begin
SET IDENTITY_INSERT [dbo].[Install] ON
INSERT [dbo].[Install]
([InstallID], [Module], [ServerName], [UserName], [Installed], [Status], [Information],
[RegKey], [RegName], [RegValue], [LatestHFID], [SiteID], [SiteName])
VALUES
(0, N'Rapport4DB', @DBServerName, N'administrator', GetDate(), N'MASTER', NULL, NULL, NULL,
NULL, N'00HF05070001516', 0, NULL)
SET IDENTITY_INSERT [dbo].[Install] OFF
End
End
Go
GUID-6DEAFAE5-586B-4B12-AC67-5FE033ABD362
Upgrading WDM using database scripts
To upgrade from WDM 5.7 to WDM 5.7.2, do the following:
1. Extract the contents of the WDM installer on the system where you want to install WDM.
2. Navigate to the folder where you have extracted the installer and go to WDMv5.7.2_GA\SQL path.
3. Execute the scripts in the following order:
• CommonTables.txt
• CommonStoredProcs.txt
• Tables.txt
• StoredProcs.txt
97