Not matching columns with same name and type..
After compare, SC wants to create a new column for one that should match and rename a column of a different name. After compare, it looks something like this:
. . . [FirmId] [int] NOT NULL, -> [IsPrivate] [bit] NOT NULL CONSTRAINT [DF_IsPrivate] DEFAULT ((0)), -> [MethodTypeId] [int] NOT NULL -> [FirmId] [int] NOT NULL )
Shouldn't it recognize that the two columns have the same name (FirmId) and type and prefer to map them and create the one with a new name (MethodTypeId)?