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

How to Ignore DataBase name while comparing?

HI,
Is there any way to ignore database name while cmparing two diferent database in same server with only Database name change, remaing are unchanged. this is in SQL Compare 9 tool.
sasikumarpsk
0

Comments

6 comments

  • sasikumarpsk
    sasikumarpsk wrote:
    HI,
    Is there any way to ignore database name while cmparing two diferent database in same server with only Database name change, remaing are unchanged. this is in SQL Compare 9 tool.

    There is project option in tools, but i am not sure what for it is used. The option is --> Ignore DataBase name in synonyms
    sasikumarpsk
    0
  • aolcot
    You can compare two databases on the same SQL instance from the project options. Can you clarify exactly where you need to ignore the database name? Do you have hard coded database name references in your procedures/triggers for example that you are trying to ignore?

    Synonyms are a useful feature to allow you to use an alternative name for a database object that is could be local or remote. Or, as we use them, a means to reference an object in a different database on the same SQL instance without specifying a hard database name within the procedure or trigger.
    aolcot
    0
  • sasikumarpsk
    yes i have hard coded database name references in my views..
    is there any way to ignore those...
    sasikumarpsk
    0
  • aolcot
    Unfortunately, I'm not aware that it is currently possible using SQL Compare to ignore database references that are in the definition of a view.

    Going forward, converting your hard coded database references to synonyms may be a potential solution.
    aolcot
    0
  • sasikumarpsk
    in near future we might get this functionallity?
    sasikumarpsk
    0
  • David Atkinson
    It's unlikely that we'll add this as an additional option unless there's sufficient demand for it. I think that the synonym approach may be your best bet.

    If anyone else needs this option, please add your request to this thread!

    Kind regards,

    David Atkinson
    Product Manager
    Red Gate Software
    David Atkinson
    0

Add comment

Please sign in to leave a comment.