Error During upgrading CDC enabled databases from SQL 2008 R2 to SQL 2012

SQL Server Administration
1

Hi Experts,

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
request.

RESTORE DATABASE successfully processed 5245
pages in 0.231 seconds (177.379 MB/sec).

Later i tried next it failedfor other sp_cdc_vupgrade.

2

How you are executing query please clear this?

When restoring a database that uses Change Data Capture (CDC), restoring
a backup works differently depending on where the database is restored.

3

I am restoring it with the normal method... However, i am scripting it at the end and then executing it by adding Keep_CDC...

Please note this worked for another database on same server. The issue is only with this one database.

Awaiting for your response.

4

Sometimes ago I had used the keep_cdc and ignored the error about meta data upgrade failure, we didn't face any issue change capture after couple of month.

Ignored the error and upgrade is successful, even after metedata upgrade error.