Skip to content

Instantly share code, notes, and snippets.

@kipergil

kipergil/azure_sync_group_clean_up.sql

Created June 4, 2020 02:59
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save kipergil/0e611daf6280574faf46e219b167f5a3 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save kipergil/0e611daf6280574faf46e219b167f5a3 to your computer and use it in GitHub Desktop.
Download ZIP
Azure Sync Group Clean Up Scripts
Raw
azure_sync_group_clean_up.sql
drop table [dss].[action];
drop table [dss].[agent];
drop table [dss].[agent_instance];
drop table [dss].[agent_version];
drop table [dss].[configuration];
drop table [dss].[EnumType];
drop table [dss].[MetaInformation];
drop table [dss].[scaleunitlimits];
drop table [dss].[ScheduleTask];
drop table [dss].[subscription];
drop table [dss].[syncgroup];
drop table [dss].[syncgroupmember];
drop table [dss].[SyncObjectData];
drop table [dss].[task];
drop table [dss].[taskdependency];
drop table [dss].[UIHistory];
drop table [dss].[userdatabase];
drop table [TaskHosting].[Job];
drop table [TaskHosting].[MessageQueue];
drop table [TaskHosting].[MetaInformation];
drop table [TaskHosting].[Schedule];
drop table [TaskHosting].[ScheduleTask];
drop procedure [dss].[GetRunningTaskCount];
drop procedure [dss].[CreateSyncGroup];
drop procedure [dss].[CreateSyncGroupV2];
drop procedure [dss].[SetDatabaseAndSyncGroupMembersState];
drop procedure [dss].[DeleteSyncGroupMember];
drop procedure [dss].[UpdateSyncGroup];
drop procedure [dss].[UpdateSyncGroupV2];
drop procedure [dss].[CreateSubscriptionV2];
drop procedure [dss].[DeleteSyncGroup];
drop procedure [dss].[DeleteSubscription];
drop procedure [dss].[SetTaskResponse];
drop procedure [dss].[RegisterDatabaseV2];
drop procedure [dss].[CreateSyncGroupMember];
drop procedure [dss].[GetLocalAgentsForSubscription];
drop procedure [dss].[GetNextScheduleTask];
drop procedure [dss].[GetUIHistoryRecords];
drop procedure [dss].[GetSyncGroupById];
drop procedure [dss].[GetSyncGroupByIdV2];
drop procedure [dss].[GetSyncGroupsForSubscriptionV2];
drop procedure [dss].[GetSyncGroupsForSubscription];
drop procedure [dss].[CreateAgent];
drop procedure [dss].[DeleteUnusedDatabase];
drop procedure [dss].[ValidateAgentInstance];
drop procedure [dss].[GetTaskByIdV2];
drop procedure [dss].[SetDatabaseRegion];
drop procedure [dss].[GetSubscriptionByUniqueName];
drop procedure [dss].[GetConcurrentSyncTaskCount];
drop procedure [dss].[GetServerCount];
drop procedure [dss].[UpdateScheduleWithInterval];
drop procedure [dss].[ResetSyncGroupMemberHubState];
drop procedure [dss].[GetSyncGroupsScheduleByLastUpdatedTime];
drop procedure [dss].[GetSyncGroupMemberHubJobId];
drop procedure [dss].[SetDatabaseCredentials];
drop procedure [dss].[ResetSyncGroupMemberState];
drop procedure [dss].[SetUserDatabaseSchema];
drop procedure [dss].[GetAgentVersions];
drop procedure [dss].[GetAgentCredentials];
drop procedure [dss].[DeleteSchedule];
drop procedure [dss].[GetLocalOrCloudDatabaseByID];
drop procedure [dss].[ValidateNTierSession];
drop procedure [dss].[RegisterAgentInstance];
drop procedure [dss].[GetFailedTaskCount];
drop procedure [dss].[UpdateSyncGroupHubHasData];
drop procedure [dss].[UpdateSyncMemberNoInitSync];
drop procedure [dss].[ResetAbandonedTasks];
drop procedure [dss].[AgentKeepAlive];
drop procedure [dss].[CreateUIHistoryRecord];
drop procedure [dss].[GetDatabaseConnString];
drop procedure [dss].[TaskKeepAlive];
drop procedure [dss].[RemoveDeadAgentInstances];
drop procedure [dss].[GetConfigurationValue];
drop procedure [dss].[CheckAndDeleteUnusedDatabase];
drop procedure [dss].[GetSyncGroupMembersForGroup];
drop procedure [dss].[GetRegisteredDatabasesForSubscription];
drop procedure [dss].[RemoveAgent];
drop procedure [dss].[GetNextScheduleTaskCount];
drop procedure [dss].[GetObjectDataWithType];
drop procedure [dss].[SetAgentCredentials];
drop procedure [dss].[UpdateSyncMemberHasData];
drop procedure [dss].[UpdateSyncGroupState];
drop procedure [dss].[CleanupUIHistoryRecord];
drop procedure [dss].[SetObjectDataWithType];
drop procedure [dss].[GetNextTask];
drop procedure [dss].[RemoveObjectData];
drop procedure [dss].[SetTaskStateToProcessing];
drop procedure [dss].[GetDatabaseById];
drop procedure [dss].[CreateActionAndTasksV2];
drop procedure [dss].[UpdateScheduleWithState];
drop procedure [dss].[GetReadyTaskCount];
drop procedure [dss].[GetTaskById];
drop procedure [dss].[ValidateSubscription];
drop procedure [dss].[GetDatabaseJobId];
drop procedure [dss].[GetRecurringTaskCountWithMaxDequeueCount];
drop procedure [dss].[GetAgentById];
drop procedure [dss].[GetSyncGroupMembersByDatabaseId];
drop procedure [dss].[GetAllSubscriptions];
drop procedure [dss].[GetDatabasesForAgent];
drop procedure [dss].[UpdateSyncGroupMemberHubState];
drop procedure [dss].[GetCloudDatabasesForSubscription];
drop procedure [dss].[SetUserDatabaseTombstoneCleanupTime];
drop procedure [dss].[CreateSchedule];
drop procedure [dss].[CleanupCompletedTasks];
drop procedure [dss].[GetSubscriptionById];
drop procedure [dss].[CancelSync];
drop procedure [dss].[DeleteUserDatabase];
drop procedure [dss].[RethrowError];
drop procedure [dss].[GetProcessingSyncGroupMembers];
drop procedure [dss].[UpdateSyncGroupMemberState];
drop procedure [dss].[GetDatabaseFillRatio];
drop procedure [dss].[CleanupFailedTasks];
drop procedure [dss].[ValidateNTierSessionV2];
drop procedure [dss].[GetSyncGroupMemberById];
drop procedure [dss].[GetNextScheduleTaskV2];
drop procedure [dss].[SetDatabaseState];
drop procedure [dss].[GetCompletedTaskCount];
drop procedure [dss].[OpsChangeSubscriptionState_ALL];
drop procedure [dss].[GetSyncGroupMemberJobId];
drop procedure [dss].[GetRegisteredDatabasesForAgent];
drop procedure [dss].[SetSubscriptionTombstoneRetentionPeriod];
drop procedure [dss].[OpsChangeSubscriptionState];
drop procedure [TaskHosting].[DeleteJob];
drop procedure [TaskHosting].[CreateScheduleTask];
drop procedure [TaskHosting].[CountMessages];
drop procedure [TaskHosting].[EnableScheduleTask];
drop procedure [TaskHosting].[DisableScheduleTask];
drop procedure [TaskHosting].[DeleteMessage];
drop procedure [TaskHosting].[GetCancelStatus];
drop procedure [TaskHosting].[GetMessageById];
drop procedure [TaskHosting].[GetJobByMessageId];
drop procedure [TaskHosting].[GetMessageStatusBySyncGroupMemberId];
drop procedure [TaskHosting].[GetNextMessage];
drop procedure [TaskHosting].[GetNextMessageByType];
drop procedure [TaskHosting].[GetNextScheduleTask];
drop procedure [TaskHosting].[InsertJob];
drop procedure [TaskHosting].[GetScheduleTaskInfo];
drop procedure [TaskHosting].[GetRunningMessageCount];
drop procedure [TaskHosting].[GetPendingMessageCount];
drop procedure [TaskHosting].[IsJobRunning];
drop procedure [TaskHosting].[InsertMessage];
drop procedure [TaskHosting].[InsertJobAndMessages];
drop procedure [TaskHosting].[UpdateAllTaskNextRunTime];
drop procedure [TaskHosting].[ResetMessageQueue];
drop procedure [TaskHosting].[ResetMessageById];
drop procedure [TaskHosting].[KeepAliveMessage];
drop procedure [TaskHosting].[UpdateScheduleTask];
drop procedure [TaskHosting].[UpdateNextRunTime];
drop procedure [TaskHosting].[UpdateScheduleTaskJobInfo];
drop procedure [TaskHosting].[UpdateScheduleTaskMessageInfoV2];
drop procedure [TaskHosting].[CleanupCompletedJobs];
drop procedure [TaskHosting].[CancelJob];
drop procedure [TaskHosting].[AddMessageIdToScheduleTask];
drop type [dss].[DB_SCHEMA];
drop type [dss].[DISPLAY_NAME];
drop type [dss].[EMAIL_ADDRESS];
drop type [dss].[LIVE_PUID];
drop type [dss].[PASSWORD_HASH];
drop type [dss].[PASSWORD_SALT];
drop type [dss].[TASK_REQUEST_RESPONSE];
drop type [dss].[TaskDependencyTableType];
drop type [dss].[TaskTableTypeV2];
drop type [dss].[VERSION];
drop type [TaskHosting].[MessageListType];
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment