Schema Comparison

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
pmeharry
Posts: 2
Joined: Mon 05 Dec 2016 19:24

Schema Comparison

Post by pmeharry » Mon 05 Dec 2016 19:30

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?
Top
alexa

Re: Schema Comparison

Post by alexa » Tue 06 Dec 2016 09:48

Could you please let us know what server version you are working with and what COMPATIBILITY_LEVEL is set for your database?
Top
pmeharry
Posts: 2
Joined: Mon 05 Dec 2016 19:24

Re: Schema Comparison

Post by pmeharry » Tue 06 Dec 2016 19:28

One is Server Version 12.00.5203, Compatibility Level = 120
Other is 12.00.2000, Compatibility Level = 100
Top
alexa

Re: Schema Comparison

Post by alexa » Wed 07 Dec 2016 15:25

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.
Top
Post Reply

Return to “dbForge for SQL Server”