|
 SYNONYMs
were
first introduced in SQL 2005, but support for them in AdeptSQL Diff
was only added in one of the latest 1.96 releases. The
SYNONYMs are rather simple objects, so the only option affecting
them tells the Diff if the actual object names behind the synonyms
should be compared literally or using a "smart" comparison
algorithm.
This
"smart" comparison first parses each of the 2 object names into
their 4 components: server, database, schema and object). Each part
is then converted to uppercase and any delimiters (such as [])
removed. If the referenced object is on the same server is as
the synonym itself, the Diff removes that part of the name, then
proceeds with similar reductions on database and schema
parts. As the result, a SYNONYM on Server1.DB1.Schema1
referring to "Server1.DB1.Schema1.MyTable" and a SYNONYM on
Server2.DB2.Schema2 referring to "Server2.DB2.Schema2.MyTable" or
just to "[MyTable]" would be found identical.
|
