Conflicts with SQL Server 2012 Sequence objects
However, whenever I get latest, they are returned as conflicts, even thought the sequences in the database and source control are shown to be exactly the same.
E.g. (mine and theirs exactly the same):
-- Sequence CREATE SEQUENCE [dbo].[seq_EnvID] AS identifier START WITH 1 INCREMENT BY 1 MINVALUE -9223372036854775808 MAXVALUE 9223372036854775807 NO CYCLE CACHE GO
Note: In this case, "identifier" is a custom type I have created and checked in:
CREATE TYPE [dbo].[identifier] FROM [bigint] NOT NULL.
When I select "theirs" and click the get latest button, it fails to run the script against the database, as it generates empty "ALTER" statements for the sequences, e.g.:
ALTER SEQUENCE [dbo].[seq_EnvID] GO
If I choose "Keep mine" and check the changes in, I am back to square one.