Activity overview
Latest activity by scanner2001
We are having the same issue. How did you resolve this?
I don't seem to be able to get the migration scripts to work. I have tried migration scripts to create the cdc setup/enable for the tables, then create the views, but it never runs the cdc part of the script. / comments
We are having the same issue. How did you resolve this?
I don't seem to be able to get the migration scripts to work. I have tried migration scripts to create the cdc setup/enable for the tables, t...
We have submitted this as a bug last year, and just recently I contacted support about this as well.
The issue is around the statement: select count_big(*) from <table name>, where table name is not prefixed with the owner (schema), which in turn defaults to dbo.
You can verify this by running a trace against the source database.
The work around that was suggested to me by RedGate support was to move all of the data into a "dbo", which is completely unreasonable and unfeasible.
What I have done is created views in the dbo schema for the source tables that are not in the non-dbo schema, which are essentially "select * from <schema>.<table>".
There are obvious holes in this approach, but it works for my particular cases. / comments
We have submitted this as a bug last year, and just recently I contacted support about this as well.
The issue is around the statement: select count_big(*) from <table name>, where table name is no...