We have an application which contains a number of defined SQL types
i.e.
CREATE TYPE [dbo].[acctno] FROM bigint NOT NULL
CREATE TYPE [dbo].[balance] FROM decimal (19, 2) NOT NULL
When I come to compare the latest generated script against a previously saved one, the type appear to change creation order despite not being changed.
I cannot find any configuration options to stop this.
Any ideas would be appreciated?
Note, We are using SQL Compare (10.4.8.87). This worked fine under SQL Compare 8
i.e.
CREATE TYPE [dbo].[acctno] FROM bigint NOT NULL
CREATE TYPE [dbo].[balance] FROM decimal (19, 2) NOT NULL
When I come to compare the latest generated script against a previously saved one, the type appear to change creation order despite not being changed.
I cannot find any configuration options to stop this.
Any ideas would be appreciated?
Note, We are using SQL Compare (10.4.8.87). This worked fine under SQL Compare 8