Transfer or script-out cdc enabled tables using SMO

Transfer or script-out cdc enabled tables using SMO by D. S. Dodiya

Closed

as Won't Fix Help for as Won't Fix

Type:	Bug
ID:	774042
Opened:	12/11/2012 9:42:54 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

I have some tables with CDC enabled in source server and need to transfer those tables to target server with CDC enabled. But SMO is not supporting to script-out CDC enabled tables.

Details (expand)

English

SQL Server 2012 - Enterprise Edition

Tools (SSMS, Agent, Profiler, Migration, etc.)

Windows Server 2008 Enterprise

English

Use SMO->Transfer class to script out source db and transfer. SMO is not supporting to script-out CDC enabled tables.

I tried scripting out tables with CDC enabled. I don't see the required DDL in the generated script that enabled CDC for table.

Scripting out tables with CDC enabled and you should see the required DDL in the generated script that enabled CDC for tables.

0 attachments

Posted by Microsoft on 1/31/2013 at 3:15 PM

Hello

We took a look at this DCR (this is not defect but actually DCR to add suport of SMO to CDC) along with several others. Unfortunately based on current customers votes count we decided not to proceed with this DCR in the next release. However, we have taken note of this internally, and when we revisit this functionality in the future, we will try and get this implemented.

Thanks for writing to Microsoft.
Alex Grach (MSFT)

Posted by D. S. Dodiya on 12/12/2012 at 2:26 PM

I am using SQL Server Management Objects (SMO) - > Transfer class in order to transfer objects from one SQL Server (Source Server) to other SQL Server (Destination Server). Actually there are some tables with CDC enabled in source server and need to transfer those tables to target server with CDC setting. So we need not to enable CDC for those tables on destination server manually.

Posted by Microsoft on 12/11/2012 at 3:48 PM

Thanks for reporting this issue. Could you please attach the T-SQL script that you used to enable CDC on table and list of steps you performed to generate scripts? ( Was it done using SMO object model / through Generate Scripts Wizard )

Thanks
Sethu Srinivasan [MSFT]
SQL Server