Getting error "commandtext property has not been initialized" when sql compare of Red Gate

sql sql-server-2012-express redgate sqlcompare
Tushar Maru picture Tushar Maru · Jun 13, 2013 · Viewed 15k times · Source

When I compare the 2 databases with the Red Gate's SQL compare then getting below error. "ExecuteReader: CommandText property has not been initialized"

I am using the SQL server 2012 express and Red Gate's SQL Compare 8

Is there any solution?

Thanks,

Answer

gbn picture gbn · Jun 13, 2013

SQL Compare 8 (current is 10.4) does not work with SQL Server 2012

http://www.red-gate.com/messageboard/viewtopic.php?t=15296&highlight=commandtext

Related questions

How to prevent 'query timeout expired'? (SQLNCLI11 error '80040e31')

I have a connection to a MS SQL Server 2012 database in classic ASP (VBScript). This is my connection string: Provider=SQL Server Native Client 11.0;Server=localhost; Database=databank;Uid=myuser;Pwd=mypassword; When I execute this SQL command: UPDATE [info] …

Read More
Get .sql file from SQL Server 2012 database

I need to get .sql files from an existing database with SQL Server 2012. Is this possible because all I see in the export option is delimited files. Ex.) I have table1 with 30 records. I need a file that would be …

Read More
Can't create stored procedure with table output parameter

I have this code: IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetProfitDeals]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[GetProfitDealsVar2] GO IF EXISTS(SELECT 1 FROM sys.types WHERE name = 'TableOrderType' AND is_…

Read More