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.
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