SQL Types
Flems
Posts: 2
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
Comments
I have logged a support ticket for you and will email you shortly.
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com