Purged Account Migration From Backup Script

-- to install extension
CREATE EXTENSION postgres_fdw;

-- you need to create a reference to the backup server
CREATE SERVER backup_prod_server
FOREIGN DATA WRAPPER postgres_fdw
OPTIONS (host 'hostAddressHere', port '5432', dbname 'postgres');

-- you need to define the user credentials to access the backup db
CREATE USER MAPPING FOR currentDbUserNameHere
SERVER staging
OPTIONS (user 'usernameHere', password 'passwordHere');

-- and you need to define a reference to the external db schema(s) (you actually need to create a schema named backup_prod_db_public)
IMPORT FOREIGN SCHEMA public
FROM SERVER backup_prod_server
INTO backup_prod_db_public;

-- and you need to define a reference to the external db schema(s) (you actually need to create a schema named backup_prod_db_workflow)
IMPORT FOREIGN SCHEMA workflow
FROM SERVER backup_prod_server
INTO backup_prod_db_workflow;

INSERT INTO public."DbBrandings"
SELECT * FROM backup_prod_db_public."DbBrandings" where "Id" IN (SELECT "BrandingID" FROM backup_prod_db_public."DbAccounts" WHERE "Id" = {ACCOUNT_ID});

INSERT INTO public."DbAccounts"
SELECT * FROM backup_prod_db_public."DbAccounts" where "Id" = {ACCOUNT_ID};

INSERT INTO public."DbSamlConfigurations"
SELECT * FROM backup_prod_db_public."DbSamlConfigurations" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbSamlRoleAuthentications"
SELECT * FROM backup_prod_db_public."DbSamlRoleAuthentications" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbSamlResponses"
SELECT * FROM backup_prod_db_public."DbSamlResponses" where "AccountID" = {ACCOUNT_ID};

CREATE TEMP TABLE Temp_Email_Settings_Ids(Id integer);
INSERT INTO Temp_Email_Settings_Ids
SELECT "EmailSettingsID" from backup_prod_db_public."DbEmailSettingToAccounts" where "AccountID" = {ACCOUNT_ID};
INSERT INTO public."DbEmailSettings"
SELECT * FROM backup_prod_db_public."DbEmailSettings" where "Id" IN (SELECT "Id" FROM Temp_Email_Settings_Ids);

INSERT INTO public."DbEmailSettingToAccounts"
SELECT * FROM backup_prod_db_public."DbEmailSettingToAccounts" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbProfileItemHiddenCharacterConfigurations"
SELECT * FROM backup_prod_db_public."DbProfileItemHiddenCharacterConfigurations" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbProfileItemHiddenCharacterRanges"
SELECT * FROM backup_prod_db_public."DbProfileItemHiddenCharacterRanges" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbProfileItems"
SELECT * FROM backup_prod_db_public."DbProfileItems" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbProfiles"
SELECT * FROM backup_prod_db_public."DbProfiles" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbPresetValues"
SELECT * FROM backup_prod_db_public."DbPresetValues" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbProfileToProfileItems"
SELECT * FROM backup_prod_db_public."DbProfileToProfileItems" where "ProfileID" in (select "Id" from backup_prod_db_public."DbProfiles" where "AccountID" = {ACCOUNT_ID});

INSERT INTO public."DbFormFillDefinitions"
SELECT * FROM backup_prod_db_public."DbFormFillDefinitions" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbFormFillToProfileItems"
SELECT * FROM backup_prod_db_public."DbFormFillToProfileItems" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbFormFillPendings"
SELECT * FROM backup_prod_db_public."DbFormFillPendings" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbSecurityPolicies"
SELECT * FROM backup_prod_db_public."DbSecurityPolicies" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbSecurityPolicyIpAddresses"
SELECT * FROM backup_prod_db_public."DbSecurityPolicyIpAddresses" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbSecurityPolicyLoginTimes"
SELECT * FROM backup_prod_db_public."DbSecurityPolicyLoginTimes" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbSystemPermissions"
SELECT * FROM backup_prod_db_public."DbSystemPermissions" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbRoles"
SELECT * FROM backup_prod_db_public."DbRoles" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbRoleToAccountFeatures"
SELECT * FROM backup_prod_db_public."DbRoleToAccountFeatures" where "RoleID" in (select "Id" from backup_prod_db_public."DbRoles" where "AccountID" = {ACCOUNT_ID});

INSERT INTO public."DbUserRolePreferences"
SELECT * FROM backup_prod_db_public."DbUserRolePreferences" where "RoleID" in (select "Id" from backup_prod_db_public."DbRoles" where "AccountID" = {ACCOUNT_ID});

INSERT INTO public."DbUserSessions"
SELECT * FROM backup_prod_db_public."DbUserSessions" where "RoleID" in (select "Id" from backup_prod_db_public."DbRoles" where "AccountID" = {ACCOUNT_ID});

INSERT INTO public."DbUserSessionToDbRoles"
SELECT * FROM backup_prod_db_public."DbUserSessionToDbRoles" where "UserSessionID" in (select "Id" from "DbUserSessions" where backup_prod_db_public."RoleID" in (select "Id" from "DbRoles" where "AccountID" = {ACCOUNT_ID}));

INSERT INTO public."DbUserSessionToDbRoles"
SELECT * FROM backup_prod_db_public."DbUserSessionToDbRoles" where "RoleID" in (select "Id" from backup_prod_db_public."DbRoles" where "AccountID" = {ACCOUNT_ID});

INSERT INTO public."DbProfileValueRoles"
SELECT * FROM backup_prod_db_public."DbProfileValueRoles" where "RoleID" in (select "Id" from backup_prod_db_public."DbRoles" where "AccountID" = {ACCOUNT_ID});

INSERT INTO public."DbRoleRelationships"
SELECT * FROM backup_prod_db_public."DbRoleRelationships" where "ParentRoleID" in (select "Id" from backup_prod_db_public."DbRoles" where "AccountID" = {ACCOUNT_ID});

DELETE FROM public."DbRoleClosures" where "ParentID" in (select "Id" from backup_prod_db_public."DbRoles" where "AccountID" = {ACCOUNT_ID});
INSERT INTO public."DbRoleClosures"
SELECT * FROM backup_prod_db_public."DbRoleClosures" where "ParentID" in (select "Id" from backup_prod_db_public."DbRoles" where "AccountID" = {ACCOUNT_ID});

INSERT INTO public."DbNotifications"
SELECT * FROM backup_prod_db_public."DbNotifications" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbWorkflowStageInstanceToNotifications"
SELECT * FROM backup_prod_db_public."DbWorkflowStageInstanceToNotifications" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbAccountSettings"
SELECT * FROM backup_prod_db_public."DbAccountSettings" where "AccountID" = {ACCOUNT_ID};

CREATE TEMP TABLE Temp_Active_File_Infoes(NodeID bigint, FileInfoID bigint);
INSERT INTO Temp_Active_File_Infoes (nodeid, fileinfoid)
SELECT "Id", "FileInfoID" from backup_prod_db_public."DbNodes" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbNodes" ("Id", "AccountID", "CreatedByUserID", "ParentID", "Name", "SystemType", "FileInfoID", "ProfileID", "CreatedOn", "ModifiedOn", "DeletedOn", "PurgedOn")
SELECT backup_prod_db_public."DbNodes"."Id", backup_prod_db_public."DbNodes"."AccountID", backup_prod_db_public."DbNodes"."CreatedByUserID", backup_prod_db_public."DbNodes"."ParentID", backup_prod_db_public."DbNodes"."Name", backup_prod_db_public."DbNodes"."SystemType", NULL, backup_prod_db_public."DbNodes"."ProfileID", backup_prod_db_public."DbNodes"."CreatedOn", backup_prod_db_public."DbNodes"."ModifiedOn", backup_prod_db_public."DbNodes"."DeletedOn", backup_prod_db_public."DbNodes"."PurgedOn"
FROM backup_prod_db_public."DbNodes" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbNodeComments"
SELECT * FROM backup_prod_db_public."DbNodeComments" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbFileInfoes"
SELECT * FROM backup_prod_db_public."DbFileInfoes" where "AccountID" = {ACCOUNT_ID};

UPDATE public."DbNodes"
SET "FileInfoID" = Temp_Active_File_Infoes.fileinfoid
FROM Temp_Active_File_Infoes
WHERE public."DbNodes"."Id" = Temp_Active_File_Infoes.nodeid;

INSERT INTO public."DbNodeToFileInfoes"
SELECT * FROM backup_prod_db_public."DbNodeToFileInfoes" where "AccountID" = {ACCOUNT_ID};

DELETE FROM public."DbNodeClosures" WHERE "AccountID" = {ACCOUNT_ID};
INSERT INTO public."DbNodeClosures" ("ParentID", "ChildID", "Depth", "AccountID")
SELECT backup_prod_db_public."DbNodeClosures"."ParentID", backup_prod_db_public."DbNodeClosures"."ChildID", backup_prod_db_public."DbNodeClosures"."Depth", backup_prod_db_public."DbNodeClosures"."AccountID"
FROM backup_prod_db_public."DbNodeClosures" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbEmailQueueAttachmentNodes"
SELECT * FROM backup_prod_db_public."DbEmailQueueAttachmentNodes" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbPortfolioToNodes"
SELECT * FROM backup_prod_db_public."DbPortfolioToNodes"
where "AddedByUserID" IN (select "UserID" from backup_prod_db_public."DbRoles" where backup_prod_db_public."DbRoles"."AccountID" = {ACCOUNT_ID} and backup_prod_db_public."DbRoles"."UserID" is not null)
and isnumeric(backup_prod_db_public."DbPortfolioToNodes"."NodeID")
and EXISTS (SELECT * FROM backup_prod_db_public."DbNodes" WHERE "Id" = CAST(backup_prod_db_public."DbPortfolioToNodes"."NodeID" as bigint) AND "AccountID" = {ACCOUNT_ID});

INSERT INTO public."DbTemplateNodeChangeLogs"
SELECT * FROM backup_prod_db_public."DbTemplateNodeChangeLogs" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbESignatureTransactions"
SELECT * FROM backup_prod_db_public."DbESignatureTransactions" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbESignatureNodeAssociations"
SELECT * FROM backup_prod_db_public."DbESignatureNodeAssociations" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbESignatureSigners"
SELECT * FROM backup_prod_db_public."DbESignatureSigners" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbRetentionChangeReason"
SELECT * FROM backup_prod_db_public."DbRetentionChangeReason" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbRightSignatureDocuments"
SELECT * FROM backup_prod_db_public."DbRightSignatureDocuments" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbNodeAnnotations"
SELECT * FROM backup_prod_db_public."DbNodeAnnotations" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbUserImageStamps"
SELECT * FROM backup_prod_db_public."DbUserImageStamps" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbDocumentRequests"
SELECT * FROM backup_prod_db_public."DbDocumentRequests" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbDocumentRequestToNotifications"
SELECT * FROM backup_prod_db_public."DbDocumentRequestToNotifications" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbDocumentRequestRoles"
SELECT * FROM backup_prod_db_public."DbDocumentRequestRoles" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbDocumentRequestContainers"
SELECT * FROM backup_prod_db_public."DbDocumentRequestContainers" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbDocumentRequestAttachments"
SELECT * FROM backup_prod_db_public."DbDocumentRequestAttachments" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbDocumentRequestContainerNodes"
SELECT * FROM backup_prod_db_public."DbDocumentRequestContainerNodes" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbFileQueue"
SELECT * FROM backup_prod_db_public."DbFileQueue" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbNodeShares"
SELECT * FROM backup_prod_db_public."DbNodeShares" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbProfileValueNodes"
SELECT * FROM backup_prod_db_public."DbProfileValueNodes" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbPermissions"
SELECT * FROM backup_prod_db_public."DbPermissions" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbLegacyNodeMappings"
SELECT * FROM backup_prod_db_public."DbLegacyNodeMappings" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbTriggerMessageContent"
SELECT * FROM backup_prod_db_public."DbTriggerMessageContent" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbTriggers"
SELECT * FROM backup_prod_db_public."DbTriggers" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbTriggerToSearchCriteria"
SELECT * FROM backup_prod_db_public."DbTriggerToSearchCriteria" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbTriggerToApiCallouts"
SELECT * FROM backup_prod_db_public."DbTriggerToApiCallouts" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbTriggerInfoNodes"
SELECT * FROM backup_prod_db_public."DbTriggerInfoNodes" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbTriggerToNode"
SELECT * FROM backup_prod_db_public."DbTriggerToNode" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbTriggerToRoles"
SELECT * FROM backup_prod_db_public."DbTriggerToRoles" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbTriggerToWorkflow"
SELECT * FROM backup_prod_db_public."DbTriggerToWorkflow" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbTimeTriggers"
SELECT * FROM backup_prod_db_public."DbTimeTriggers" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbEventTriggers"
SELECT * FROM backup_prod_db_public."DbEventTriggers" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbEmailImportMappings"
SELECT * FROM backup_prod_db_public."DbEmailImportMappings" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbEmailQueue"
SELECT * FROM backup_prod_db_public."DbEmailQueue" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbEmailRecipients"
SELECT * FROM backup_prod_db_public."DbEmailRecipients" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbEmailQueueAttachmentNodes"
SELECT * FROM backup_prod_db_public."DbEmailQueueAttachmentNodes" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbAuditLogs"
SELECT * FROM backup_prod_db_public."DbAuditLogs" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbAuditLogsToRoles"
SELECT * FROM backup_prod_db_public."DbAuditLogsToRoles" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbAuditLogsToRoleDetails"
SELECT * FROM backup_prod_db_public."DbAuditLogsToRoleDetails" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbAuditLogsToNodes"
SELECT * FROM backup_prod_db_public."DbAuditLogsToNodes" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbAuditLogsToNodeDetails"
SELECT * FROM backup_prod_db_public."DbAuditLogsToNodeDetails" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbAccessLinks"
SELECT * FROM backup_prod_db_public."DbAccessLinks" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbAccessLinksToDocumentRequests"
SELECT * FROM backup_prod_db_public."DbAccessLinksToDocumentRequests" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbAccessLinksToNodeAndTriggers"
SELECT * FROM backup_prod_db_public."DbAccessLinksToNodeAndTriggers" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbAccountFeatureUsages"
SELECT * FROM backup_prod_db_public."DbAccountFeatureUsages" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbAccountFeatures"
SELECT * FROM backup_prod_db_public."DbAccountFeatures" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbCheckoutInfoes"
SELECT * FROM backup_prod_db_public."DbCheckoutInfoes" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbSfMappingDestinations"
SELECT * FROM backup_prod_db_public."DbSfMappingDestinations" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbSfMappings"
SELECT * FROM backup_prod_db_public."DbSfMappings" where "AccountID" = {ACCOUNT_ID};

INSERT INTO public."DbSfLinks"
SELECT * FROM backup_prod_db_public."DbSfLinks" where "AccountID" = {ACCOUNT_ID};

-- WORKFLOW TABLES

INSERT INTO workflow."DbWorkflows"
SELECT * FROM backup_prod_db_workflow."DbWorkflows" where "AccountId" = {ACCOUNT_ID};

INSERT INTO workflow."DbWorkflowAssets"
SELECT * FROM backup_prod_db_workflow."DbWorkflowAssets" where "WorkflowID" IN (SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID});

INSERT INTO workflow."DbWorkflowStages"
SELECT * FROM backup_prod_db_workflow."DbWorkflowStages" where "WorkflowID" IN (SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID});

INSERT INTO workflow."DbWorkflowsAvailableStates"
SELECT * FROM backup_prod_db_workflow."DbWorkflowsAvailableStates" where "WorkflowID" IN (SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID});

CREATE TEMP TABLE Temp_Current_Workflow_Stages(WorkflowInstanceID bigint, WorkflowStageInstanceID bigint);
INSERT INTO Temp_Current_Workflow_Stages (workflowinstanceid, workflowstageinstanceid)
SELECT "Id", "CurrentStageID" from backup_prod_db_workflow."DbWorkflowInstances" where "WorkflowID" IN (SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID});

INSERT INTO workflow."DbWorkflowInstances" ("Id", "Name", "Description", "IsActive", "StateID", "WorkflowID", "OwnerID", "CreatedDate", "LastModifiedDate", "CurrentStageID")
SELECT "Id", "Name", "Description", "IsActive", "StateID", "WorkflowID", "OwnerID", "CreatedDate", "LastModifiedDate", NULL
FROM backup_prod_db_workflow."DbWorkflowInstances" where "WorkflowID" IN (SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID});

INSERT INTO workflow."DbWorkflowStageInstances"
SELECT * FROM backup_prod_db_workflow."DbWorkflowStageInstances" where "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID}));

UPDATE workflow."DbWorkflowInstances"
SET "CurrentStageID" = Temp_Current_Workflow_Stages.workflowstageinstanceid
FROM Temp_Current_Workflow_Stages
WHERE workflow."DbWorkflowInstances"."Id" = Temp_Current_Workflow_Stages.workflowinstanceid;

INSERT INTO workflow."DbAssetNodeReference"
SELECT * FROM backup_prod_db_workflow."DbAssetNodeReference" where "AssetID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowAssets" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID}));

INSERT INTO workflow."DbWorkflowAssetsStages"
SELECT * FROM backup_prod_db_workflow."DbWorkflowAssetsStages" where "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStages" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID}));

INSERT INTO workflow."DbWorkflowAssetInstances"
SELECT * FROM backup_prod_db_workflow."DbWorkflowAssetInstances" where "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID}));

INSERT INTO workflow."DbAssetInstanceNodeReferences"
SELECT * FROM backup_prod_db_workflow."DbAssetInstanceNodeReferences" where "AssetInstanceID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowAssetInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID})));

INSERT INTO workflow."DbProfileRoutingRules"
SELECT * FROM backup_prod_db_workflow."DbProfileRoutingRules" where "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStages" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID}));

INSERT INTO workflow."DbWorkflowSteps"
SELECT * FROM backup_prod_db_workflow."DbWorkflowSteps" where "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStages" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID}));

INSERT INTO workflow."DbStageApproveResults"
SELECT * FROM backup_prod_db_workflow."DbStageApproveResults" where "StageInstanceID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStageInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID})));

INSERT INTO workflow."DbWorkflowAssetsStagesInstances"
SELECT * FROM backup_prod_db_workflow."DbWorkflowAssetsStagesInstances" where "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStageInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID})));

INSERT INTO workflow."DbWorkflowStepInstances"
SELECT * FROM backup_prod_db_workflow."DbWorkflowStepInstances" where "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStageInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID})));

INSERT INTO workflow."DbWorkflowSetProfileInstanceItems"
SELECT * FROM backup_prod_db_workflow."DbWorkflowSetProfileInstanceItems" where "StepInstanceID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStepInstances" WHERE "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStageInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID}))));

INSERT INTO workflow."DbWorkflowSetProfileInstanceItemPresetValues"
SELECT * FROM backup_prod_db_workflow."DbWorkflowSetProfileInstanceItemPresetValues" where "StepProfileItemID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowSetProfileInstanceItems" WHERE "StepInstanceID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStepInstances" WHERE "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStageInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStageInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID})))));

INSERT INTO workflow."DbWorkflowSendMessageInstanceRecipients"
SELECT * FROM backup_prod_db_workflow."DbWorkflowSendMessageInstanceRecipients" where "StepInstanceID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStepInstances" WHERE "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStageInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID}))));

INSERT INTO workflow."DbWorkflowStepInstanceEmailUserGroups"
SELECT * FROM backup_prod_db_workflow."DbWorkflowStepInstanceEmailUserGroups" where "WorkflowAddTriggerStepInstanceID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStepInstances" WHERE "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStageInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID}))));

INSERT INTO workflow."DbWorkflowStepInstanceEmailUsers"
SELECT * FROM backup_prod_db_workflow."DbWorkflowStepInstanceEmailUsers" where "WorkflowAddTriggerStepInstanceID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStepInstances" WHERE "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStageInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID}))));

INSERT INTO workflow."DbWorkflowRequestFileExternalStepInstanceNewUserReferences"
SELECT * FROM backup_prod_db_workflow."DbWorkflowRequestFileExternalStepInstanceNewUserReferences" where "StepInstanceID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStepInstances" WHERE "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStageInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID}))));

INSERT INTO workflow."DbWorkflowRequestFileExternalStepInstanceRecipientGroups"
SELECT * FROM backup_prod_db_workflow."DbWorkflowRequestFileExternalStepInstanceRecipientGroups" where "WorkflowStepInstanceID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStepInstances" WHERE "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStageInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID}))));

INSERT INTO workflow."DbWorkflowRequestFileExternalStepInstanceRecipients"
SELECT * FROM backup_prod_db_workflow."DbWorkflowRequestFileExternalStepInstanceRecipients" where "WorkflowStepInstanceID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStepInstances" WHERE "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStageInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID}))));

INSERT INTO workflow."DbWorkflowStepInstanceDocumentRequestContainers"
SELECT * FROM backup_prod_db_workflow."DbWorkflowStepInstanceDocumentRequestContainers" where "StepInstanceID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStepInstances" WHERE "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStageInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID}))));

INSERT INTO workflow."DbWorkflowStepInstanceUserReferences"
SELECT * FROM backup_prod_db_workflow."DbWorkflowStepInstanceUserReferences" where "StepInstanceID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStepInstances" WHERE "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStageInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID}))));

INSERT INTO workflow."DbWorkflowStepInstanceGroupReferences"
SELECT * FROM backup_prod_db_workflow."DbWorkflowStepInstanceGroupReferences" where "StepInstanceID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStepInstances" WHERE "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStageInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID}))));

INSERT INTO workflow."DbWorkflowShareStepInstanceNewUserReferences"
SELECT * FROM backup_prod_db_workflow."DbWorkflowShareStepInstanceNewUserReferences" where "StepInstanceID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStepInstances" WHERE "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStageInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID}))));

INSERT INTO workflow."DbWorkflowStepInstanceUsers"
SELECT * FROM backup_prod_db_workflow."DbWorkflowStepInstanceUsers" where "WorkflowSetPermissionsStepInstanceID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStepInstances" WHERE "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStageInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID}))));

INSERT INTO workflow."DbWorkflowStepInstanceUserGroups"
SELECT * FROM backup_prod_db_workflow."DbWorkflowStepInstanceUserGroups" where "WorkflowSetPermissionsStepInstanceID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStepInstances" WHERE "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStageInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowInstances" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID}))));

INSERT INTO workflow."DbWorkflowInstanceHistoryRecords"
SELECT * FROM backup_prod_db_workflow."DbWorkflowInstanceHistoryRecords" where "WorkflowID" IN (SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID});

INSERT INTO workflow."DbWorkflowSetProfileItems"
SELECT * FROM backup_prod_db_workflow."DbWorkflowSetProfileItems" where "StepID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowSteps" WHERE "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStages" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID})));

INSERT INTO workflow."DbWorkflowSetProfileItemPresetValues"
SELECT * FROM backup_prod_db_workflow."DbWorkflowSetProfileItemPresetValues" where "StepProfileItemID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowSetProfileItems" WHERE "StepID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowSteps" WHERE "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStages" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID}))));

INSERT INTO workflow."DbWorkflowSendMessageRecipients"
SELECT * FROM backup_prod_db_workflow."DbWorkflowSendMessageRecipients" where "StepID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowSteps" WHERE "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStages" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID})));

INSERT INTO workflow."DbWorkflowAddTriggerStepEmailUserGroups"
SELECT * FROM backup_prod_db_workflow."DbWorkflowAddTriggerStepEmailUserGroups" where "WorkflowStepID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowSteps" WHERE "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStages" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID})));

INSERT INTO workflow."DbWorkflowAddTriggerStepEmailUsers"
SELECT * FROM backup_prod_db_workflow."DbWorkflowAddTriggerStepEmailUsers" where "WorkflowStepID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowSteps" WHERE "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStages" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID})));

INSERT INTO workflow."DbWorkflowRequestFileExternalStepNewUserReferences"
SELECT * FROM backup_prod_db_workflow."DbWorkflowRequestFileExternalStepNewUserReferences" where "StepID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowSteps" WHERE "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStages" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID})));

INSERT INTO workflow."DbWorkflowRequestFileExternalStepRecipientGroups"
SELECT * FROM backup_prod_db_workflow."DbWorkflowRequestFileExternalStepRecipientGroups" where "WorkflowStepID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowSteps" WHERE "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStages" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID})));

INSERT INTO workflow."DbWorkflowRequestFileExternalStepRecipients"
SELECT * FROM backup_prod_db_workflow."DbWorkflowRequestFileExternalStepRecipients" where "WorkflowStepID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowSteps" WHERE "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStages" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID})));

INSERT INTO workflow."DbWorkflowStepDocumentRequestContainers"
SELECT * FROM backup_prod_db_workflow."DbWorkflowStepDocumentRequestContainers" where "StepID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowSteps" WHERE "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStages" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID})));

INSERT INTO workflow."DbWorkflowShareStepNewUserReferences"
SELECT * FROM backup_prod_db_workflow."DbWorkflowShareStepNewUserReferences" where "StepID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowSteps" WHERE "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStages" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID})));

INSERT INTO workflow."DbWorkflowStepUserReferences"
SELECT * FROM backup_prod_db_workflow."DbWorkflowStepUserReferences" where "StepID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowSteps" WHERE "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStages" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID})));

INSERT INTO workflow."DbWorkflowStepGroupReferences"
SELECT * FROM backup_prod_db_workflow."DbWorkflowStepGroupReferences" where "StepID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowSteps" WHERE "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStages" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID})));

INSERT INTO workflow."DbWorkflowSetPermissionsStepUsers"
SELECT * FROM backup_prod_db_workflow."DbWorkflowSetPermissionsStepUsers" where "WorkflowStepID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowSteps" WHERE "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStages" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID})));

INSERT INTO workflow."DbWorkflowSetPermissionsStepUserGroups"
SELECT * FROM backup_prod_db_workflow."DbWorkflowSetPermissionsStepUserGroups" where "WorkflowStepID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowSteps" WHERE "StageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStages" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID})));

INSERT INTO workflow."DbWorkflowStageAssigneeGroups"
SELECT * FROM backup_prod_db_workflow."DbWorkflowStageAssigneeGroups" where "WorkflowStageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStages" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID}));

INSERT INTO workflow."DbWorkflowStageAssignees"
SELECT * FROM backup_prod_db_workflow."DbWorkflowStageAssignees" where "WorkflowStageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStages" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID}));

INSERT INTO workflow."DbWorkflowStageApproverGroups"
SELECT * FROM backup_prod_db_workflow."DbWorkflowStageApproverGroups" where "WorkflowStageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStages" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID}));

INSERT INTO workflow."DbWorkflowStageApprovers"
SELECT * FROM backup_prod_db_workflow."DbWorkflowStageApprovers" where "WorkflowStageID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflowStages" WHERE "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID}));

INSERT INTO workflow."DbWorkflowStarterGroups"
SELECT * FROM backup_prod_db_workflow."DbWorkflowStarterGroups" where "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID});

INSERT INTO workflow."DbWorkflowStarters"
SELECT * FROM backup_prod_db_workflow."DbWorkflowStarters" where "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID});

INSERT INTO workflow."DbWorkflowOwnerGroups"
SELECT * FROM backup_prod_db_workflow."DbWorkflowOwnerGroups" where "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID});

INSERT INTO workflow."DbWorkflowOwners"
SELECT * FROM backup_prod_db_workflow."DbWorkflowOwners" where "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID});

INSERT INTO workflow."DbWorkflowWatcherGroups"
SELECT * FROM backup_prod_db_workflow."DbWorkflowWatcherGroups" where "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID});

INSERT INTO workflow."DbWorkflowWatchers"
SELECT * FROM backup_prod_db_workflow."DbWorkflowWatchers" where "WorkflowID" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID});

INSERT INTO workflow."DbWorkflowScheduleConfigurations"
SELECT * FROM backup_prod_db_workflow."DbWorkflowScheduleConfigurations" where "Id" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID});

INSERT INTO workflow."DbWorkflowNotificationConfigurations"
SELECT * FROM backup_prod_db_workflow."DbWorkflowNotificationConfigurations" where "Id" IN
(SELECT "Id" FROM backup_prod_db_workflow."DbWorkflows" WHERE "AccountId" = {ACCOUNT_ID});

INSERT INTO workflow."DbWorkflowJobsQueue"
SELECT * FROM backup_prod_db_workflow."DbWorkflowJobsQueue" where "AccountId" = {ACCOUNT_ID};

INSERT INTO workflow."DbWorkflowAccountEmailConfig"
SELECT * FROM backup_prod_db_workflow."DbWorkflowAccountEmailConfig" where "AccountId" = {ACCOUNT_ID};