I am trying to Migrate the database which is enabled for CDC from SQL 2008 R2 to SQL 2012 server and gettingerror, while upgrading the metadata.
I tried with keep_cdc while restoring to keep CDC enabled.
Could not upgrade the metadata for database
'DB' that is enabled for Change Data Capture. The failure occurred when
executing the action 'sp_cdc_create_change_enumeration_functions'. The error
returned was 102: 'line 45, state 1, Incorrect syntax near ')'.'. Use the
action and error to determine the cause of the failure and resubmit the
RESTORE DATABASE successfully processed 5245
pages in 0.231 seconds (177.379 MB/sec).
Later i tried next it failedfor other sp_cdc_vupgrade.