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

Ignore replication stored procedures

Is there a way to tell the SQL Comparator to ignore stored procedures prefixed sp_MS or indeed all sp_ ?

I have slightly different replication between a development database and a prodcution database and lost my replication stored procedures when I ran the compare.

I can of course manually uncheck the compare each time, but that seems to defeat the object of an automatic tool.

Cheers!
Simon
SimonG156
0

Comments

2 comments

Sort by
  • Brian Donahue
    Hello Simon,

    From the sound of it, what you really need is for SQL Compare to automatically ignore replication objects, such as the stored procedures that are created by SQL Server when you make a database a publisher or subscriber. This is something we'd like to do in a future version, but right now we're including all of these objects as part of the schema. SQL Compare does have this issue with replicated databases.
    Brian Donahue
    0
  • SimonG156
    Exactly that. Not the end of the Owrld as I can go through once and uncheck all those objects and save a project. Currently I am the only user of the software in the company..
    SimonG156
    0

Add comment

Please sign in to leave a comment.