Deployment will disable Stretch Database

adambaldwin

Our database deployments have recently been moved over from using SQLCI from command line to using SQL Release (we have version 1.3.10.380 and version 1.3.7.332 both installed). We are using Team City for builds, Octopus for deployments. Our database/webapps live in the Azure cloud, we use localDB for testing and during development. In Azure we have DEV/CI/UAT/Staging/Production life cycles (Staging does not have it's own database, it uses the production for testing before changes go live).

The new process is:
1. Downloads and extracts the database with the Deploy a NuGet package step.
2. Create Database Release - version date 7/16/15
3. Review database update resources - manual intervention step.
4. Deploy from Database Release - version date 7/16/15

When we deploy to CI/UAT the process works without error. We are running into an issue deploying to DEV/Production. When checking the changes.html file, SQL Compare has picked up Stretch Database being enabled on the tables and we are unable to deploy without receiving timeouts. The warning we are seeing is: "The deployment will disable Stretch Database on the [dbo].[******] table. To do this, SQL Compare will download the table's remote data from Azure and then rebuild the table. Downloading remote data may cause the deployment to take a long time."

We have performed further testing, and we do not have Stretch enabled upon any of the databases. The warnings also exist for CI/UAT however we're not seeing failures/timeouts, which is probably due to having just testing data in those DBs. When querying the sys.tables for the database, we're seeing is_remote_data_archive_enabled = 0 for all tables (table is not Stretch-enabled), remote_data_archive_migration_state = 3 (options from MSDN docs says 0(Disabled),1(Stretch-enabled, data migration off) or 2 (Stretch-enabled, data migration on)), and remote_data_archive_migration_state_desc = DISABLED.

So this has gotten us stumped, any ideas are appreciated!

Tugberk

Hey adambaldwin,

I am following up on this now to see why this is happening. I will come back to you shortly.

Tugberk

Hi Adam,

Sorry for the wait. The issue you are seeing has been fixed with the latest version of SQL Compare but we haven't released a DLM Automation Suite version which has that version of SQL Compare. In the meantime, we are trying to figure out when we can release that. I will be in touch when we know more.

Tugberk

Tugberk

Hey Adam,

Can you upgrade to the latest version of DLM Automation Suite (which is 1.3.11.393)? The problem you are seeing should be resolved in this release. You can download the latest release here: https://www.red-gate.com/dynamic/produc ... e/download

Let us know if you still have the problem after the upgrade.

Tugberk

adambaldwin

Hi Tugberk,

I will get this tested out this morning and let you know what happens. Thank you.