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

SQL Compare dropping non compared objects

When running a compare against 2 databases, SQL compare is generating script code that will alter tables that I have specifically asked it not to look at.

If you check the following image, you can see that, although I have unselected the "orders" table, the code in the script drops columns from this table.

The version of SQL Compare I am running is 3.2.1.14

Thanks,

Jason

error.jpg
jasonspeight
0

Comments

2 comments

Sort by
  • Brian Donahue
    Hi Jason,

    Can you try the same thing with the 'include dependent objects' turned off? This may be scripted as part of a dependency.

    Note: in the next version you'll be able to tell which objects were ones you'd explicitly chosen and which are dependencies. Good news there!
    Brian Donahue
    0
  • Brian Donahue
    Oh, by next version I don't mean 4, which is already out. I mean version 5.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.