For troubleshooting, sometimes you'll want to run a migrations script on a database again.

To do this, you can remove the deployment record for the migration script. You might also want to remove the record for the changes before the migration script.

Mark an object as undeployed by running this SQL:

SELECT * FROM [RedGateLocal].[DeploymentMetadata]
GO
DELETE FROM [RedGateLocal].[DeploymentMetadata] WHERE [BlockId] = '<the id of the migration script or block you want to deploy again>' OR [Name] = N'<unique name of migration script or block to deploy again>'
GO