BEGIN
	EXEC('CREATE PROCEDURE [dbo].[MigrateFormsUser]
		@oldSID nvarchar(100),
		@newSID nvarchar(100)
	AS
	BEGIN
		IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME=''cf_users'' AND COLUMN_NAME=''sid'')
		BEGIN
			UPDATE cf_users SET sid=@newSID where sid=@oldSID
		END	
		IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME=''cf_usergroups'' AND COLUMN_NAME=''sid'')
		BEGIN
			UPDATE cf_usergroups SET sid=@newSID where sid=@oldSID
		END
		IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME=''cf_user_profile'' AND COLUMN_NAME=''sid'')
		BEGIN
			UPDATE cf_user_profile SET sid=@newSID where sid=@oldSID
		END
		IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME=''cf_user_snapshot'' AND COLUMN_NAME=''sid'')
		BEGIN
			UPDATE cf_user_snapshot SET sid=@newSID where sid=@oldSID
		END
		IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME=''cf_bp_steps'' AND COLUMN_NAME=''definition_json'')
		BEGIN
			UPDATE cf_bp_steps SET definition_json=REPLACE(definition_json, @oldSID + ''""'', @newSID + ''""'') WHERE definition_json LIKE ''%'' + @oldSID + ''""'' + ''%''
		END
		IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME=''cf_bp_static_reports'' AND COLUMN_NAME=''created_by_sid'')
		BEGIN
			UPDATE cf_bp_static_reports SET created_by_sid=@newSID where created_by_sid=@oldSID
		END
		IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME=''static_report_security'' AND COLUMN_NAME=''user_group_sid'')
		BEGIN
			UPDATE static_report_security SET user_group_sid=@newSID where user_group_sid=@oldSID
		END
		IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME=''report_email_scheduling'' AND COLUMN_NAME=''scheduling_definition_json'')
		BEGIN
			UPDATE report_email_scheduling SET scheduling_definition_json=REPLACE(scheduling_definition_json, @oldSID + ''""'', @newSID + ''""'') WHERE scheduling_definition_json LIKE ''%'' + @oldSID + ''""'' + ''%''
		END
		IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME=''report_email_scheduling'' AND COLUMN_NAME=''email_definition_json'')
		BEGIN
			UPDATE report_email_scheduling SET email_definition_json=REPLACE(email_definition_json, @oldSID + ''""'', @newSID + ''""'') WHERE email_definition_json LIKE ''%'' + @oldSID + ''""'' + ''%''
		END
		IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME=''cf_business_processes'' AND COLUMN_NAME=''terminal_email_template'')
		BEGIN
			UPDATE cf_business_processes SET terminal_email_template=REPLACE(terminal_email_template, @oldSID + ''""'', @newSID + ''""'') WHERE terminal_email_template LIKE ''%'' + @oldSID + ''""'' + ''%''
		END
		IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME=''cf_business_processes'' AND COLUMN_NAME=''suspend_email_template'')
		BEGIN
			UPDATE cf_business_processes SET suspend_email_template=REPLACE(suspend_email_template, @oldSID + ''""'', @newSID + ''""'') WHERE suspend_email_template LIKE ''%'' + @oldSID + ''""'' + ''%''
		END
	END')
END