Azure to local SQL 2012 error

lightyeare

I am getting an error comparing an Azure db to a local sql 2012 db that is empty. I've just done a successful compare and deployment with a different azure db and a different local sql 2012 db that was empty.

It throws error on Registering data sources - Reading indexes. The error is "property_list_id". Yes, that's it.

I am using Windows 8, SQL 2012 and the most recent version of SQL Compare 10.2.0.1337.

Brian Donahue

Sorry for the inconvenience. Can you click on the "send error report" button and include your email address? This should give us some usable information about the error.

lightyeare

did that about an hour before I posted here but I will do that again asap. the error details say: property_list_id. Hopefully more is being sent behind then scenes that isn't on the screen.

Working with this same azure database in SQL Data Compare also produces the same result.

Edit: support message successfully sent. I'd be happy to work with you in any way to try to resolve this error. Let me know.

Brian Donahue

Can you try setting the SQL Compare project option "Ignore->Full-text indexing"? I think the text of the error message refers to a column name in the information schema that refers to a table containing fulltext indexes.

lightyeare

Tried Ignoring:
Full-text indexes
Indexes
The LOCK property of indexes
Constraint and index names
and then turned all the ignore options on.

Still fails same error.

Brian Donahue

It looks like the SQL Compare code is treating the Azure database as if it were regular 2012, which has the index property "property_list_id" on full-text indexes. The source code indicates that it should gather this information on 2012 and ignore it on Azure... possibly SQL Compare is not detecting Azure correctly. Will have to look into that.

Brian Donahue

If you run this:
select SERVERPROPERTY('EngineEdition')
against the Azure database, SQL Compare expects it to be 5.

lightyeare

select SERVERPROPERTY('EngineEdition') returns 5

lightyeare

keep in mind the same error occurs for both SQL compare AND Sql Data compare

Brian Donahue

Sure it would - they are both tied to the same schema reader code.

lightyeare

which would have been obvious if I had taken 2 seconds to think about it. let me know if I can provide any other info.

Brian Donahue

I'll let you know if I can think of anything...
I just did a SQL Compare between AdventureWorks on SQL 2102 vs Azure and did not get this error though.

lightyeare

yep, i am able to work just fine with one of our other azure dbs. also, i can work just fine with the azure db when i do the compare from our win2008 server. doesn't seem to work in my environment.

Brian Donahue

If it's any help, it looks like the live database in your error report is using SQL Server 2008 compatibility mode. I tried that in my test, but it did not reproduce the error. However, it may explain why you have this problem with some databases and not others. The bug that your error report got filed with mentions that it's a problem with SQL 2000 backward-compatibility.

lightyeare

i can work with the db fine using SQL Compare installed on our Window 2008 server.

so this is specifically related to my windows8 environment?

Brian Donahue

I'm afraid I can't comment as to whether or not Windows is at fault. All I can tell is tat this code path comes out if the database version is determined not to be Azure. But we already tested for that.

Brian Donahue

I think I've found the problem - it seems to only happen on indexed views. That would explain why the error is so uncommon.

Brian Donahue

Hello,

This issue is fixed in trhe latest release of SQL Compare, 10.3.8.406, that you can get from Check for Updates.

Brian Donahue

This is meant to be fixed in SQL Compare 10.7.