Unable to import after deploy - Pending Migrations still found - blank list

Steps:
Create baseline from Environment A (prod)
Create migration based on A->Environment B (QA environment)
Deploy to new DB C (development environment), which now is same as B (deploy is successful, all tables are updated)
Any changes to DB C are not able to be imported into a new migration script.
Error is: Pending Migrations have been found, but the list is blank, and I'm not sure where else I can check. Deleting/Recreating/Redeploying to C doesn't do anything.
I've deployed to C from both Visual Studio and Octopus. I've created C both on localdb and a sql server instance, but the same issue happens.
I do manually remove the extra logins, roles, and schemas manually from the baseline - I can't deploy those in C (cross domain)
Create baseline from Environment A (prod)
Create migration based on A->Environment B (QA environment)
Deploy to new DB C (development environment), which now is same as B (deploy is successful, all tables are updated)
Any changes to DB C are not able to be imported into a new migration script.
Error is: Pending Migrations have been found, but the list is blank, and I'm not sure where else I can check. Deleting/Recreating/Redeploying to C doesn't do anything.
I've deployed to C from both Visual Studio and Octopus. I've created C both on localdb and a sql server instance, but the same issue happens.
I do manually remove the extra logins, roles, and schemas manually from the baseline - I can't deploy those in C (cross domain)
Answers
I suspect that your manual modification of your migration script may have changed the hash of the script, so it's not showing up as the same migration.
Can you please get some extra debugging info by performing the following steps?
- Send me the following log file:
Many Thanks%LocalAppData%\Red Gate\Logs\SQL Change Automation\VS\SQL Change Automation-VS.log
Eddie
Product Support Engineer
Redgate Software Ltd
Email: [email protected]
Please either update this post or submit a support request via the Support Portal and click the 'Submit a request' button.
Many Thanks
Eddie
Product Support Engineer
Redgate Software Ltd
Email: [email protected]