Problem with excluding object from syncronize

rdobrichrdobrich Posts: 60
edited December 2, 2005 6:30AM in SQL Compare Previous Versions
I have following problem then try to exclude some object:

I Try to compare two databases (working and empty database).
I have all object including in synchronizing.
The script failed (let say because of ordering or something else)
Now I try to exclude that failed object from the list.
I try to sync again.
I have the same error. Script include that excluding object.

After experiment with this I realize why.
In comparation option I have check 'include dependencies'

This is little confuse. I know that option include all dependencies for object. But when I wont some object not to include that option, Script force to create that.

I think that excluding some object from the list have to exclude that object from creating (from object dependencies of parent object)

Comments

  • rdobrich wrote:
    I have following problem then try to exclude some object:

    I Try to compare two databases (working and empty database).
    I have all object including in synchronizing.
    The script failed (let say because of ordering or something else)
    Now I try to exclude that failed object from the list.
    I try to sync again.
    I have the same error. Script include that excluding object.

    After experiment with this I realize why.
    In comparation option I have check 'include dependencies'

    This is little confuse. I know that option include all dependencies for object. But when I wont some object not to include that option, Script force to create that.

    I think that excluding some object from the list have to exclude that object from creating (from object dependencies of parent object)

    You are right that we do not support explicit object exclusion. If you have an object that depends on another one, then without the "include dependencies" option this object cannot be synchronized (the script would raise a dependency error or the resulting database will be most likely inconsistent). In the future we will show more information that could help in such cases.

    Regards,
    Andras
    András Belokosztolszki, PhD
    Red Gate Software Ltd.
This discussion has been closed.