Skip to content
← Customer Feedback for Redgate

Settings and activity

1 result found

  1. Ignore Database Name in Stored Procedures, Views, and Functions

    14 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  SQL Compare  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    Tony D'Agosta commented  · 

    Actually instead of ignoring database name I give a new name (my alias) so that stored procedures with same name in different databases are not confused.
    e.g. comparing databases PROD_GENP_Hub vs DEV_GENP_Hub I assign Hub as the alias name for the databases.

    An error occurred while saving the comment
    Tony D'Agosta commented  · 

    Because of this I stopped using SQL Compare for views and stored procedures and now use my own scripts to do the compare.

    Tony D'Agosta supported this idea  ·