The New Schema Comparison Wizard does not seem to be comparing Sequences. While there are Options to Ignore various Sequence values, when you get to the Object Filters Sequences is grayed out.
Is this feature in the queue to be implemented?
Schema Comparison
Re: Schema Comparison
Could you please let us know what server version you are working with and what COMPATIBILITY_LEVEL is set for your database?
Re: Schema Comparison
One is Server Version 12.00.5203, Compatibility Level = 120
Other is 12.00.2000, Compatibility Level = 100
Other is 12.00.2000, Compatibility Level = 100
Re: Schema Comparison
This happens because of the Compatibility Level = 100. On the SQL Server 2008, there is no a possibility to work with Sequences since there are no such objects for this server version. So, for correct working, you need to change Compatibility Level.