I am facing and issue in Red Gate Source Control beta
My source control version is Red Gate Source Control 18.104.22.168 (migration V2 beta version)
I have a table called 'CustomMigration' in a database and the database is already source controlled.
I am trying to add a migration script for inserting the data into 'CustomMigration' table
migration script is:
insert into CustomMigration(Id) values(12345)
Added this migration script and executed using F5 button and clicked on save and close button.
Clicked on commit changes tab, getting below error
Error while running migration script:
Invalid object name 'CustomMigration'.