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

Exclude Specific objects ie a single stored procedure

This may be a really dim question but excuse me as i'm a noobie to SQL Compare,

I have a development and a live database.
On the live database i have an SQLCLR stored proc.
On the development database i have an equivalent stored proc named exactly the same thing but is a dummy in effect.

Of course SQL Compare spots that they are different and want to include them in a synchronise.

Is there any way of excluding specific objects.

I've just downloaded the trial for Quests Change Director. This has this feature which looked quite useful for me.
Note: Wont be buying Change Director, had a few funnies in the trial, it seemed to forget some exlude options i'd set earlier. Lost confidence so abandonned.

Please Help.
zac
0

Comments

1 comment

Sort by
  • Michelle T
    Once you have compared your databases, Compare will display all of the objects in your databases in a grid. In the middle of each row (there is one row per object) will either be an equal sign (if Compare thinks the objects are equal) or a check box (if Compare thinks they are different). If you don't want to synchronize a particular object, uncheck its check box before synchronizing.
    Michelle T
    0

Add comment

Please sign in to leave a comment.