We've added a new computed column to a SQL Server database table. The new computed column is dependent on a new function.
When we attempt to deploy the branch, migrations reports the error shown below.
Error: Synchronization of 'Scripts.RedGate' and 'SomeServer.SomeDb' failed:
Cannot find either column "dbo" or the user-defined function or aggregate
"dbo.IsACredit", or the name is ambiguous. Error executing the following SQL:
ALTER TABLE [dbo].[SomeTable] ADD [IsCredit] AS ([dbo].[IsACredit]([ID]))
How can we successfully deploy these needed database changes?
Thank you in advance!