SQL Database Validation is Out-of-sync
I ran into a strange situation where I am trying to synchronize two databases on different servers using Red Gate SQL Compare v14.4.4.16824 and a stored procedure identified as different but will not deploy because it encounters an error: "Invalid column name xxxx". The error itself is an error because the table column does in fact exist on both servers by that name. I have used SSMS to confirm the tables are the same and contain the column name and I have tried to deploy with SSMS and that failed with the same invalid column name error.
So my question is, what is the database looking at to validate the column name and how do I update that data?
So my question is, what is the database looking at to validate the column name and how do I update that data?
Tagged:
Answers
Dan Jary | Redgate Software
Have you visited our Help Center?