What are the challenges you face when working across database platforms? Take the survey

SQL Compare dropping non compared objects

jasonspeightjasonspeight Posts: 2
edited March 3, 2006 4:00PM in SQL Compare Previous Versions
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





  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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!
  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Oh, by next version I don't mean 4, which is already out. I mean version 5.
Sign In or Register to comment.