I am using the Synchronize --> Generate Change Script wizard to keep my models in sync with my SQL Server 2008R2 DWH. I noticed an unusal error, or maybe its a bug when the wizard creates the final change script.
Here are the difference beteeen my model, on the left, and the database on the right.
I have changed the natural key in the model to type Int, and in the database it is of type nvarchar, the script generated should be a simple:
ALTER TABLE [dbo].[DimCompany] ALTER COLUMN [CompanyAltKey] Int NOT NULL
Instead the wizard creates the following
Adding a Collate clause? Obviously this creates an error shown above. Anyone know why Toad does this, and or how to prevent it from happening? is it a bug?