Two tables compares generates drop procedure statements?

BlueBlue Posts: 4
edited January 25, 2006 12:06PM in SQL Compare Previous Versions
I ran the Red-Gate package and specified that I only wanted to compare between 2 tables, so I unchecked all objects expect for that specific table. I don't understand why the script generated statements for dropping stored procedures and even generated alter table statements for other tables. The only particularity with the table that I am comparing is that it has a user defined datatype. Is this causing a problem?

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello,
    It would be unusual that SQL Compare would be dropping objects this way. If you were synchronizing stored procedures, then a table may be getting pulled in as a dependency. The other way I can't see this happening.
This discussion has been closed.