Does Red Gate Compare Engine 11.1.0.2 work with Microsoft SQL Server 2016 - 13.0.4202.2 (X64)?
Klaus
Posts: 2 Bronze 1
Hi , we use Red Gate Compare Engine 11.1.0.2 every day. Now we has our first shot with SQL Server 2016 Express Edition and got this error while registering a target db for structure update:
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Unhandled Exception: RedGate.SQLCompare.Engine.SqlCompareException: A duplicate
object name has been found. This may occur if the SQL Server that you are regist
ering is case sensitive but the case sensitive option is not set. ---> System.Ar
gumentOutOfRangeException: We don't have DMV queries available for SqlServer2014
Parameter name: ServerMajorVersion
at #mWo.#3gOd.#bXge()
at #mWo.#3gOd.CaseCheck()
at #mWo.#KYo.#4np(DBPopulationOptions #1BCc)
at #mWo.#KYo.Populate(DBPopulationOptions #YBCc)
--- End of inner exception stack trace ---
at #mWo.#KYo.Populate(DBPopulationOptions #YBCc)
at RedGate.SQLCompare.Engine.Database.Register(ConnectionProperties connectio
nProperties, Options options, IDmvModelFactory factory)
at EtaskDatabaseUpdater.Program.DirectUpdateStructure(Logger log, Config conf
ig)
at EtaskDatabaseUpdater.Program.Main(String[] args)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
I am unsure, if i have config options at the database, or if i must change my compare software.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Unhandled Exception: RedGate.SQLCompare.Engine.SqlCompareException: A duplicate
object name has been found. This may occur if the SQL Server that you are regist
ering is case sensitive but the case sensitive option is not set. ---> System.Ar
gumentOutOfRangeException: We don't have DMV queries available for SqlServer2014
Parameter name: ServerMajorVersion
at #mWo.#3gOd.#bXge()
at #mWo.#3gOd.CaseCheck()
at #mWo.#KYo.#4np(DBPopulationOptions #1BCc)
at #mWo.#KYo.Populate(DBPopulationOptions #YBCc)
--- End of inner exception stack trace ---
at #mWo.#KYo.Populate(DBPopulationOptions #YBCc)
at RedGate.SQLCompare.Engine.Database.Register(ConnectionProperties connectio
nProperties, Options options, IDmvModelFactory factory)
at EtaskDatabaseUpdater.Program.DirectUpdateStructure(Logger log, Config conf
ig)
at EtaskDatabaseUpdater.Program.Main(String[] args)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
I am unsure, if i have config options at the database, or if i must change my compare software.
Tagged:
Comments
You are correct that SQL Server 2016 is only supported by SQL Compare 12. I'd suggest that you download a free trial to verify that this version fixes your problem. The reported version of 2014 from the error message is likely referring to the compatibility level of the database, which can be older than the server version (e.g. if a backup is restored to a newer server).
Additionally, it looks like you are hitting an issue with duplicate objects; perhaps the other database in your comparison has objects with case collisions.
Redgate Software