| Author |
Message |
lightyeare
Joined: 06 Sep 2012
Posts: 8
|
 Posted: Thu Sep 06, 2012 8:54 pm Post subject: Azure to local SQL 2012 error |
 |
|
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 |
|
 |
Brian Donahue
Joined: 23 Aug 2004
Posts: 6346
Location: Red Gate Software
|
| Posted: Mon Sep 10, 2012 4:09 pm Post subject: |
|
|
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.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
lightyeare
Joined: 06 Sep 2012
Posts: 8
|
| Posted: Mon Sep 10, 2012 4:21 pm Post subject: ok |
|
|
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 |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6346
Location: Red Gate Software
|
| Posted: Wed Sep 12, 2012 12:18 pm Post subject: |
|
|
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.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
lightyeare
Joined: 06 Sep 2012
Posts: 8
|
| Posted: Wed Sep 12, 2012 12:32 pm Post subject: sorry :( |
|
|
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 |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6346
Location: Red Gate Software
|
| Posted: Wed Sep 12, 2012 3:35 pm Post subject: |
|
|
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
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6346
Location: Red Gate Software
|
| Posted: Wed Sep 12, 2012 3:39 pm Post subject: |
|
|
If you run this:
select SERVERPROPERTY('EngineEdition')
against the Azure database, SQL Compare expects it to be 5.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
lightyeare
Joined: 06 Sep 2012
Posts: 8
|
| Posted: Wed Sep 12, 2012 3:41 pm Post subject: |
|
|
| select SERVERPROPERTY('EngineEdition') returns 5 |
|
| Back to top |
|
|
lightyeare
Joined: 06 Sep 2012
Posts: 8
|
| Posted: Wed Sep 12, 2012 3:46 pm Post subject: |
|
|
| keep in mind the same error occurs for both SQL compare AND Sql Data compare |
|
| Back to top |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6346
Location: Red Gate Software
|
| Posted: Wed Sep 12, 2012 4:07 pm Post subject: |
|
|
Sure it would - they are both tied to the same schema reader code.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
lightyeare
Joined: 06 Sep 2012
Posts: 8
|
| Posted: Wed Sep 12, 2012 4:16 pm Post subject: |
|
|
| 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 |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6346
Location: Red Gate Software
|
| Posted: Thu Sep 13, 2012 10:07 am Post subject: |
|
|
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.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
lightyeare
Joined: 06 Sep 2012
Posts: 8
|
| Posted: Thu Sep 13, 2012 1:15 pm Post subject: |
|
|
| 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 |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6346
Location: Red Gate Software
|
| Posted: Fri Sep 14, 2012 5:36 pm Post subject: |
|
|
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.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
lightyeare
Joined: 06 Sep 2012
Posts: 8
|
| Posted: Fri Sep 14, 2012 5:44 pm Post subject: |
|
|
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 |
|
|
|
