How can we help you today? How can we help you today?

Expected Synonym Behavior

SQL Change Automation doesn't appear to detect differences in the base_object_name of a synonym.  Consider the following:
1. The synonym is deployed from source control if it doesn't exist in the target DB. << as intended
2. The synonym is dropped from the target DB if it doesn't exist in source control. << as intended
3. No action is taken to deploy a new version of the synonym if the base object referenced by the synonym is different between source control & the target DB.

Does anyone know if this behavior is by-design?
Shaggy
0

Comments

4 comments

Sort by
  • Sergio R
    No, this is not expected.
    Maybe you are excluding synonyms in step 3 using a filter?
    Sergio R
    0
  • Shaggy
    I don't believe this is the case.

    The synonym section of my filter.scpf is:

          <Synonym version="1">
            <Include>True</Include>
            <Expression>TRUE</Expression>
          </Synonym>

    My ComparisonOptions.xml file contains this entry:

    <IgnoreSynonymDependencies>False</IgnoreSynonymDependencies>
    Shaggy
    0
  • Shaggy
    We invoked the desired behavior for scenario #3 by changing this option to false:
    <IgnoreDatabaseAndServerName>False</IgnoreDatabaseAndServerName>

    Can you confirm if this is valid/safe?
    Shaggy
    0
  • Sergio R
    <IgnoreDatabaseAndServerName>True</IgnoreDatabaseAndServerName> means that if the synonym exists in both source and target and the only difference is database and server name, then it will be considered identical and no differences will be deployed

    In your case since you set it to False it considers synonyms to be different, if either the database or server name are different and will deploy these differences

    I wouldn't say it's unsafe to set this option, as long as you are aware of its consequences
    Sergio R
    0

Add comment

Please sign in to leave a comment.