Computed Column Dependent on Function Fails in Migration

GHoh

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?

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]))

Thank you in advance!

Jessica R

Hi @GHoh!

Just to confirm, is the error coming up when doing a get latest? And are you using a migration script?

Would it be possible for you to share the CREATE statement for the table and function with us?