Error in SQL Server 2012

Automate and integrate using the SQL comparison API

Moderators: Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

Error in SQL Server 2012

Postby Erfan » Thu Apr 12, 2012 3:01 pm

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 :
Code: Select all
stagingDB.Register(sourceConnectionProperties, Options.Default)


i see this error :
Code: Select all
ExecuteReader: CommandText property has not been initialized


it is not happens when i try to connect SQL Server 2008
i need some help please
Erfan
 
Posts: 2
Joined: Thu Apr 12, 2012 2:33 pm

Postby andy.campbell.smith » Fri Apr 13, 2012 4:37 pm

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.
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software

Postby Erfan » Fri Apr 20, 2012 8:28 am

thanks for your reply
I use last trial version of SQL Comparison SDK and it works fine
:D
Erfan
 
Posts: 2
Joined: Thu Apr 12, 2012 2:33 pm

Compare 9 and SQL 2012

Postby nickpatel01 » Thu Jan 23, 2014 1:28 pm

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? :)
nickpatel01
 
Posts: 1
Joined: Thu Jan 23, 2014 1:25 pm
Location: MD

Postby andy.campbell.smith » Thu Jan 23, 2014 2:08 pm

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.
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software


Return to SQL Comparison SDK 10

Who is online

Users browsing this forum: mpetcov and 0 guests