Error in SQL Server 2012

Erfan · April 12, 2012 10:01AM

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&#40;sourceConnectionProperties, Options.Default&#41;

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 · April 13, 2012 11:37AM

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 · April 20, 2012 3:28AM

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

nickpatel01 · January 23, 2014 7:28AM

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 · January 23, 2014 8:08AM

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.

Error in SQL Server 2012

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk