Doesn't recognise the hierarchy if the object is a synonym

pip87

When comparing it doesn't recognise the hierarchy if the object is hidden beneath a synonym. This causes issues when deploying a procedure change using the synonym in conjunction with a table definition change to the underlying table in the same deployment.

Steps for reproduction:

Create table
Create synonym on table
Create Procedure using synonym (simple select should do fine)

Deploy

Alter original table by adding a column
Modify proc to look for new column on synonym

Check deploy script generated at this point you should be able to see table change comes in after the procedure change thus columns it is dependant on are not pulled through as build fails altering procedure due to not finding column on table as they haven't yet been applied.

Found in CD pipeline using teamcity but reproduced inside SQL Compare

Anu D

Hi,

Thanks for your post!

I will investigate this issue and get back to you!

Anu D

Hi,

Thanks for your patience.

I tried reproducing the issue but it works fine for me.

Can you please confirm the detailed version of SQL Compare you are using? (Help--> About SQL Compare)