Initializing PowerCampus Test

If you restore your prod backups to a test or dev database, you may find this initialization script handy.

This script requires customizations; do not just copy and run it.

USE [Campus6_Test]

--Set title bar and report titles
UPDATE ABT_SETTINGS
SET SETTING = 'PowerCampus TEST'
WHERE AREA_NAME = 'SYSADMIN'
	AND SECTION_NAME = 'CAMPUS'
	AND LABEL_NAME IN (
		'DESKTOP'
		,'REPORT'
		)

--Set HTML splash page
UPDATE ABT_SETTINGS
SET SETTING = '\\server\Apps\PowerCampus\INI\Test_Launch.html' --Change to your actual location
WHERE AREA_NAME = 'SYSADMIN'
	AND SECTION_NAME = 'LOCATION'
	AND LABEL_NAME ='DASHBOARD'

--Fix logins (if you restore to a different SQL server)
ALTER USER selfservice WITH LOGIN = selfservice
ALTER USER powercampus WITH LOGIN = powercampus

--Reset SQL Service Broker GUID to avoid breaking PFI (if you restore to the same SQL server)
ALTER DATABASE [campus6_test]
SET NEW_BROKER WITH ROLLBACK IMMEDIATE;

--Disable Great Plains and PFI connections to avoid accidental postings
UPDATE ABT_SETTINGS
SET SETTING = ''
WHERE AREA_NAME = 'SYSADMIN'
	AND SECTION_NAME IN (
		'GP_CONNECT'
		,'PF_CONNECT'
		)
	AND LABEL_NAME IN (
		'LOGID'
		,'LOGPASSWORD'
		)