User profile for alexjf

mark.jordan wrote: Good news! It looks like our test instance has now received this change, so we should be able to reproduce and figure out how to handle it now (and any other changed columns that might have sneaked in as well [image] Hopefully we'll have a fix out soon. Awesome - eagerly awaiting a patch [image] / comments

mark.jordan wrote: Good news! It looks like our test instance has now received this change, so we should be able to reproduce and figure out how to handle it now (and any other changed columns t...

0 votes

Hi Mark, When I run your query I get the following: [image] 13.0.703 12.0.2000.8 Microsoft SQL Azure (RTM) - 12.0.2000.8 Feb 21 2016 21:14:02 Copyright (c) Microsoft Corporation The build number is different. I actually thought you may have trouble creating a database in the Australia East data center. If you private message me your static IP address I'll create a test database and server and give you access to it in my subscription. Microsoft are definitely throwing some spanners in the works with their versioning. Really looking forward to a solution to this [image] / comments

Hi Mark, When I run your query I get the following: 13.0.703 12.0.2000.8 Microsoft SQL Azure (RTM) - 12.0.2000.8 Feb 21 2016 21:14:02 Copyright (c) Microsoft Corporation The build number is ...

0 votes

Hi Mark, Unfortunately it's happening again today. I can no longer sync any of our SQL Azure databases in the Australia East data-center. Today the version build date has changed again, but the version number, yet again, remains the same whilst the column no longer exists. This is extremely frustrating [image] Microsoft SQL Azure (RTM) - 12.0.2000.8 Feb 21 2016 21:14:02 Copyright (c) Microsoft Corporation The column remote_data_archive_migration_state has yet again been removed. Is this something that one of your future releases will be able to cater for? Because not being able to sync is extremely frustrating, however I do totally understand that this isn't Red Gates fault. What's more worrying than the whole thing is the fact that the version number remains the same, however entire columns are being dropped. IMHO that warrants a version increment, unfortunately trying to get hold of anyone who can help within the Azure team seems to be an impossible task. Can you recreate this problem if you use the Australia East data-center? / comments

Hi Mark, Unfortunately it's happening again today. I can no longer sync any of our SQL Azure databases in the Australia East data-center. Today the version build date has changed again, but the ver...

0 votes

I tried to sync again this morning and it has worked, however it looks like MS has rolled back the version of SQL Azure. @version I get this: Microsoft SQL Azure (RTM) - 12.0.2000.8 Feb 9 2016 00:13:50 Copyright (c) Microsoft Corporation as opposed to what I was getting on the 19th of February which was: Microsoft SQL Azure (RTM) - 12.0.2000.8 Feb 17 2016 01:00:11 Copyright (c) Microsoft Corporation Notice that the version numbers are the same but the date is different... So to confirm - I can currently sync with 11.5, however I'd be wary that they might upgrade again and cause this to break my removing the column I mentioned. Is this something you guys should follow up with Microsoft? / comments

I tried to sync again this morning and it has worked, however it looks like MS has rolled back the version of SQL Azure.@version I get this: Microsoft SQL Azure (RTM) - 12.0.2000.8 Feb 9 2016 0...

0 votes

Hi Mark, thanks for the quick reply. @version I get Microsoft SQL Azure (RTM) - 12.0.2000.8 Feb 17 2016 01:00:11 Copyright (c) Microsoft Corporation Just for some further information, we're in the Australia East data center, maybe due to us being in the furthest ahead time zone we were released with a version before other data centers? On your v12 databases that you run tests against can you see if you're running the same version? The columns in my sys.tables for my production database are: name object_id principal_id schema_id parent_object_id type type_desc create_date modify_date is_ms_shipped is_published is_schema_published lob_data_space_id filestream_data_space_id max_column_id_used lock_on_bulk_load uses_ansi_nulls is_replicated has_replication_filter is_merge_published is_sync_tran_subscribed has_unchecked_assembly_data text_in_row_limit large_value_types_out_of_row is_tracked_by_cdc lock_escalation lock_escalation_desc is_filetable is_memory_optimized durability durability_desc temporal_type temporal_type_desc history_table_id is_remote_data_archive_enabled is_external The columns in my sys.tables for the master database are: name object_id principal_id schema_id parent_object_id type type_desc create_date modify_date is_ms_shipped is_published is_schema_published lob_data_space_id filestream_data_space_id max_column_id_used lock_on_bulk_load uses_ansi_nulls is_replicated has_replication_filter is_merge_published is_sync_tran_subscribed has_unchecked_assembly_data text_in_row_limit large_value_types_out_of_row is_tracked_by_cdc lock_escalation lock_escalation_desc is_filetable is_memory_optimized durability durability_desc temporal_type temporal_type_desc history_table_id is_remote_data_archive_enabled is_external There doesn't look to be a remote_data_archive_migration_state column. I can only assume it's a Microsoft update because everything compared fine the day before and nothing compared today, but no changes were actually rolled out from me on either day. / comments

Hi Mark, thanks for the quick reply.@version I get Microsoft SQL Azure (RTM) - 12.0.2000.8 Feb 17 2016 01:00:11 Copyright (c) Microsoft Corporation Just for some further information, we're in ...

0 votes

remote_data_archive_migration_state

I can no longer compare any of my SQL Azure v12 databases using SQL Compare 11.5 as of 19th February. The error I get says: Invalid column name 'remote_data_archive_migration_state'. They did al...

20 followers 44 comments 0 votes

How can we help you today?

alexjf

Activity overview