Red Gate forums :: View topic - Azure to local SQL 2012 error
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Azure to local SQL 2012 error

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Go to page 1, 2  Next
Author Message
lightyeare



Joined: 06 Sep 2012
Posts: 8

PostPosted: Thu Sep 06, 2012 8:54 pm    Post subject: Azure to local SQL 2012 error Reply with quote

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.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6669

PostPosted: Mon Sep 10, 2012 4:09 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
lightyeare



Joined: 06 Sep 2012
Posts: 8

PostPosted: Mon Sep 10, 2012 4:21 pm    Post subject: ok Reply with quote

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.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6669

PostPosted: Wed Sep 12, 2012 12:18 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
lightyeare



Joined: 06 Sep 2012
Posts: 8

PostPosted: Wed Sep 12, 2012 12:32 pm    Post subject: sorry :( Reply with quote

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.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6669

PostPosted: Wed Sep 12, 2012 3:35 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6669

PostPosted: Wed Sep 12, 2012 3:39 pm    Post subject: Reply with quote

If you run this:
select SERVERPROPERTY('EngineEdition')
against the Azure database, SQL Compare expects it to be 5.
Back to top
View user's profile Send private message
lightyeare



Joined: 06 Sep 2012
Posts: 8

PostPosted: Wed Sep 12, 2012 3:41 pm    Post subject: Reply with quote

select SERVERPROPERTY('EngineEdition') returns 5
Back to top
View user's profile Send private message
lightyeare



Joined: 06 Sep 2012
Posts: 8

PostPosted: Wed Sep 12, 2012 3:46 pm    Post subject: Reply with quote

keep in mind the same error occurs for both SQL compare AND Sql Data compare
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6669

PostPosted: Wed Sep 12, 2012 4:07 pm    Post subject: Reply with quote

Sure it would - they are both tied to the same schema reader code.
Back to top
View user's profile Send private message
lightyeare



Joined: 06 Sep 2012
Posts: 8

PostPosted: Wed Sep 12, 2012 4:16 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6669

PostPosted: Thu Sep 13, 2012 10:07 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
lightyeare



Joined: 06 Sep 2012
Posts: 8

PostPosted: Thu Sep 13, 2012 1:15 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6669

PostPosted: Fri Sep 14, 2012 5:36 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
lightyeare



Joined: 06 Sep 2012
Posts: 8

PostPosted: Fri Sep 14, 2012 5:44 pm    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Go to page 1, 2  Next
Page 1 of 2

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group