Removing VRE Bolt-on changes Follow

The VRE Bolt-on app used by ARG Alliance customers pre-6.31 makes several changes to the GlasPacLX database. Once the customer upgrades to 6.31 and the Bolt-on is no longer used, these database changes should be removed; they are not part of a standard LX deployment. The script to remove the changes is as follows:

 

-----------------------------------------------
-- Script to remove database changes from VRE Bolt-on
-----------------------------------------------

-- Drop triggers
IF OBJECT_ID ('DocumentInstallation_DataModified','TR') IS NOT NULL
DROP TRIGGER DocumentInstallation_DataModified;

IF OBJECT_ID ('DocumentInstaller_DataModified','TR') IS NOT NULL
DROP TRIGGER DocumentInstaller_DataModified;

 

-- Drop stored procedures
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_ApptStatus]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[usp_ApptStatus]

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_GetXMLElements_VREBoltOn]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[usp_GetXMLElements_VREBoltOn]

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_InserUpdate_ARGScriptVersion]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[usp_InserUpdate_ARGScriptVersion]

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_Update_MetryxDetail]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[usp_Update_MetryxDetail]

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_Get_ApptStatus_EmpId]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[usp_Get_ApptStatus_EmpId]

 

-- Drop views
IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_ApptStatusFinder]'))
DROP VIEW [dbo].[vw_ApptStatusFinder]

IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_GetXMLElements_VREBoltOn]'))
DROP VIEW [dbo].[vw_GetXMLElements_VREBoltOn]

 

-- Drop tables
IF EXISTS(SELECT * FROM [INFORMATION_SCHEMA].[TABLES] WHERE [INFORMATION_SCHEMA].[TABLES].[TABLE_NAME] = 'ARGScriptVersion')
BEGIN
DROP TABLE ARGScriptVersion
END

IF EXISTS(SELECT * FROM [INFORMATION_SCHEMA].[TABLES] WHERE [INFORMATION_SCHEMA].[TABLES].[TABLE_NAME] = 'ApptSentStatus')
BEGIN
DROP TABLE ApptSentStatus
END

IF EXISTS(SELECT * FROM [INFORMATION_SCHEMA].[TABLES] WHERE [INFORMATION_SCHEMA].[TABLES].[TABLE_NAME] = 'ApptStatus')
BEGIN
DROP TABLE ApptStatus
END

IF EXISTS(SELECT * FROM [INFORMATION_SCHEMA].[TABLES] WHERE [INFORMATION_SCHEMA].[TABLES].[TABLE_NAME] = 'EmployeeMetryxID')
BEGIN
DROP TABLE EmployeeMetryxID
END

IF EXISTS(SELECT * FROM [INFORMATION_SCHEMA].[TABLES] WHERE [INFORMATION_SCHEMA].[TABLES].[TABLE_NAME] = 'VREApplication')
BEGIN
DROP TABLE VREApplication
END

IF EXISTS(SELECT * FROM [INFORMATION_SCHEMA].[TABLES] WHERE [INFORMATION_SCHEMA].[TABLES].[TABLE_NAME] = 'VRERecordsToUpdate')
BEGIN
DROP TABLE VRERecordsToUpdate
END

 

Have more questions? Submit a request

Comments

Powered by Zendesk