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

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?


  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.