Computed Column Dependent on Function Fails in Migration
We added a new computed column to a table. The computed column is dependent on a new function.
When we attempt to deploy this branch, migrations reports the error below. How can we successfully deploy these needed database changes?
Thank you in advance!
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]))
0 · Share on Twitter