What are the challenges you face when working across database platforms? Take the survey
Options

Static Data loss

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.

Answers

Sign In or Register to comment.