Home Dashboard Directory Help
Search

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


Status: 

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


2
0
Sign in
to vote
Type: Bug
ID: 774042
Opened: 12/11/2012 9:42:54 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

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
Sign in to post a comment.
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
Sign in to post a workaround.