Mapping for schemas
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.
What can we do to improve the compare and synch?
2 votes
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.
2 votes
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.
For example:
USE AdventureWorks2008R2;
GO
IF EXISTS (SELECT name FROM sys.stats
WHERE name = N'ContactPromotion1'
AND object_id = OBJECT_ID(N'Person.Person'))
DROP STATISTICS Person.Person.ContactPromotion1
GO
Social Web