When will SQL Data Compare be updated to work with Graph tables introduced in SQL 2017?
tdennis2019
Posts: 6 New member
SQL Data Compare 14.7.8.21163 is not working correctly with SQL Graph tables (Nodes and Edges).
1. The hidden node columns are not automapped.
1a. If the node columns are mapped manually, the table does not appear in the data comparison results. Going back into Edit Project removes the manual mapping
2. Selecting Deploy without the hidden node columns means new $node_id values are generated which then breaks referential integrity with all the Edge tables linked to the Nodes.
Will SQL Data Compare be updated soon to handle the Node and Edge tables?
Thank you
1. The hidden node columns are not automapped.
1a. If the node columns are mapped manually, the table does not appear in the data comparison results. Going back into Edit Project removes the manual mapping
2. Selecting Deploy without the hidden node columns means new $node_id values are generated which then breaks referential integrity with all the Edge tables linked to the Nodes.
Will SQL Data Compare be updated soon to handle the Node and Edge tables?
Thank you
Tagged:
Answers
Thanks for reaching out to us regarding this. My apology for the delay in coming back to you!
In all honesty, I have never used SQL Graph tables before now. To aid my attempts to reproduce the behavior you are seeing here, are you able to provide an example Graph table I can use for this?
Also, just for absolute clarity, was the graph table(s) in question created in SQL 2017? Do you see the same behavior in SQL Graph tables created in SQL 2019?
Dan Jary | Redgate Software
Have you visited our Help Center?
My apology for the delay in coming back to you on this.
I just wanted to clarify if the fix released as part of SQL Compare v.14.8.4 (https://download.red-gate.com/checkforupdates/SQLDataCompare/SQLDataCompare_14.8.4.21440.exe) has also resolved the issues you have highlighted here?
Dan Jary | Redgate Software
Have you visited our Help Center?
I get a 404 file not found error when I click the link you provided.
Apologies - looks like there is a ) at the end of the link
Please try the following:
https://download.red-gate.com/checkforupdates/SQLDataCompare/SQLDataCompare_14.8.4.21440.exe