Error in SQL Server 2012

Erfan

hi
I use [SQL Comparison SDK 8] and I try to connect [SQL Server 2012] and compare two databases with RedGate given sample [SQLCompareCodeSnippets.vbproj]
when the following code runs :

stagingDB.Register(sourceConnectionProperties, Options.Default)

i see this error :

ExecuteReader: CommandText property has not been initialized

it is not happens when i try to connect SQL Server 2008
i need some help please

Andy C S

I'm afraid that version 8 of the SQL Comparison SDK doesn't support connecting to SQL 2012 databases - the latest version of the SDK is version 10 ( http://www.red-gate.com/products/sql-de ... rison-sdk/ ), which will support SQL 2012 connections. If you've got an active support and upgrades contract you can upgrade for free - if not, you can contact sales@red-gate.com to talk about an upgrade.

Erfan

thanks for your reply
I use last trial version of SQL Comparison SDK and it works fine

nickpatel01

I have SQL Compare 9 and SQL 2012 and Still getting same error. My question is SQL compare 9 does not work with SQL 2012?

Andy C S

Hi Nick,

SQL 2012 support was introduced in SQL Compare 10 - if you want to connect to a SQL 2012 server you'll need to upgrade.