Static Data loss

Manoj_298

I have used the SQL Change Automation PowerShell module on a Windows server machine to deploy the source control projects to the Azure SQL databases. 

I facing static data loss during the deployment process. I don't know why this is happening. I have all static data files in my data folder and tables listed in the RedGateDatabaseInfo.xml file.

This is my Sql Automation Powershell module version '4.6.23319.2501'

This is a log message I got

Applying update script to database 'mydatabase' on server 'xxxx.database.windows.net'.

Delete rows from [dbo].[table]

Operation applied to 2 rows out of 2

Reseed identity on [dbo].[table]

Checking identity information: current identity value '2'.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Checking identity information: current identity value '0', current column value 'NULL'.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Manoj_298

Is there any solution to this question?

DanC

Hi @Manoj_298

I'm going to reach out directly via a support ticket, as it would be good to get some resources from yourself to troubleshoot this further!