Option to disable the comparison of similarly named objects when using CLI

Stan_K

Hello,

When comparing an object using the the command line method, the program actually compares (and synchronizes!) objects that have similar names, as opposed to the GUI method which only compares the objects you selected with their checkbox. For example, let's say a database has the following Stored Procedures:
sp_BudgetAccounts
sp_BudgetAccounts_somesuffix
sp_BudgetAccounts2
sp_BudgetAccounts3

I only want to compare the first one: sp_BudgetAccounts. No problem with the GUI method. Tick the checkbox and the rest will be ignored. The CLI on the other hand will compare and synchronize all of them:

Object type             Name                                                     DB1 DB2 

-------------------------------------------------------------------------------------------
StoredProcedure    [dbo].[sp_BudgetAccounts]                     <>    <>

StoredProcedure    [dbo].[sp_BudgetAccounts2]                   >>      

StoredProcedure    [dbo].[sp_BudgetAccounts3]                   >>      

StoredProcedure    [dbo].[sp_BudgetAccounts_somesuffix]  >>      

This means any test or temp store procedures will now be carried over to other databases. Is there any way this can be disabled? Is there a switch or an option that I am not using?

Jessica R

Hi @Stan_KStan_K,

Thanks for your post!

I'm sorry to say there isn't a built-in option to exclude similarly named objects at the moment.

Can you please add a feature request for this to our uservoice forum here: https://redgate.uservoice.com/forums/141379-sql-compare?

Can I check though--do your temp tables always end with a number suffix? A possible option is to add an exclusion using a regular expression to exclude tables, stored procedures, etc... ending in numbers: https://documentation.red-gate.com/sc14/using-the-command-line/switches-used-in-the-command-line#Switchesusedinthecommandline-/exclude:%3Ctype%3E:%3Cregularexpression%3E

Hope that may help!