Skip to content

Instantly share code, notes, and snippets.

@cassioeskelsen

cassioeskelsen/alterando_cdc.sql

Last active April 11, 2022 00:17
Show Gist options
  • Save cassioeskelsen/2a420b8fd52d2515bc33737cebcb71cf to your computer and use it in GitHub Desktop.
Save cassioeskelsen/2a420b8fd52d2515bc33737cebcb71cf to your computer and use it in GitHub Desktop.
Download ZIP
Raw
alterando_cdc.sql
/* Criação de uma nova capture instance */
EXEC sys.sp_cdc_enable_table
@source_schema = N'Faturamento'
@source_name = N'NotasFiscais',
@role_name = N'CDC_Reader',
@capture_instance = N'NotasFiscais002',
@supports_net_changes = 0
GO
/* Exclusão da antiga capture instance */
EXEC sys.sp_cdc_disable_table
@source_schema = N'Faturamento',
@source_name = N'NotasFiscais',
@capture_instance = N'NotasFiscais001'
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment