SQL Compare cannot transfer correctly PERIOD FOR SYSTEM_TIME and HIDDEN attributes
Ivailo
Posts: 1 New member
in SQL Compare
Hello support team,
I am trying to transfer changes from lower environment to the next environment. Unfortunately PERIOD FOR SYSTEM_TIME and HIDDEN attributes are not transferred correctly.
PERIOD FOR SYSTEM_TIME is transferred after the table changes are transferred. HIDDEN attribute cannot be transferred at all. There is an error in the statement SQL Compare produces.
Step to reproduce the issue:
Create table in Env1 with PERIOD FOR SYSTEM_TIME and HIDDEN attributes on the period columns.
Create the same table in Env2 (they should be exactly the same). Remove PERIOD FOR SYSTEM_TIME on the table in Env2.
Compare and try to sync Env1 and Env2. You should be able to see the issues.
Please tell me how to sync environments if I am missing something?
I am trying to transfer changes from lower environment to the next environment. Unfortunately PERIOD FOR SYSTEM_TIME and HIDDEN attributes are not transferred correctly.
PERIOD FOR SYSTEM_TIME is transferred after the table changes are transferred. HIDDEN attribute cannot be transferred at all. There is an error in the statement SQL Compare produces.
Step to reproduce the issue:
Create table in Env1 with PERIOD FOR SYSTEM_TIME and HIDDEN attributes on the period columns.
Create the same table in Env2 (they should be exactly the same). Remove PERIOD FOR SYSTEM_TIME on the table in Env2.
Compare and try to sync Env1 and Env2. You should be able to see the issues.
Please tell me how to sync environments if I am missing something?
Tagged:
