Issue with Schema Comparison and Synonyms
I'm schema-comparing two databases (i'm using Schema comparison from within SQL Server Studio). Database A and B exist in two different servers/instances (let's say S1 and S2). Database A has a synonym to Database C (in the same server - S1) but Database B doesn't have that synonym. When i create the synchronization script, it correctly contains the creation of that synonym, but it still points to Database C (which does not exist in the destination server S2). If i execute the script without changing anything, it reports that it has been executed successfully but when i re-compare the DBs, it is still reported that the synonym does not exist in the destination DB.
In that case, when i executed the script i would expect Schema comparison to report an error while creating the synonym. It doesn't.