I would like to have a mapping of schemas while comparing my databases in schema compare feature.
in my case many of objects are the same but reside in different schemas and i can't compare them at the moment.
Click Sign In to use a Yahoo, Google, or Twitter account
What can we do to improve the compare and synch?
When generating the output script for a schema compare, the drop for statistics is not being wrapped in a check to make sure the statistic exists.
IF EXISTS (SELECT name FROM sys.stats
WHERE name = N'ContactPromotion1'
AND object_id = OBJECT_ID(N'Person.Person'))
DROP STATISTICS Person.Person.ContactPromotion1