Hi all - I am currently in the process of setting up Source Control. Everything seemed to be going well until we decided to test the process with a live production update.
The staging database that we are committing changes from is an exact copy of the production database, i.e. the staging database was restored from the production database's backup...and no changes have occurred on the production database since the last backup.
We added a single bit field to our table, committed the change to Subversion and attempted to commit the change through Source Control.
We received the following error message -
Title: The type Date on object [dbo].[SupplierVenue].[DateCreated] is not supported in the target database version.
There was no change to this table, I have looked in sys.object to confirm the modified date and the last update was over two months ago.
Why would Source Control identify an unsupported datatype when I'm not committing a Date field change and there has been no changes to the SupplierVenue table.
Kind regards, Russell.