Hi,
I did a compare schema and the result show that a column will be drop in the target database, but when a export to editor the script to drop column doesn't generate.
For exemple:
Source Object:
CREATE TABLE [dbo].[Leito] (
[lei_codigo] CHAR (4) NOT NULL,
[locatend_codigo] CHAR (4) NOT NULL,
[lei_status] CHAR (1) NULL,
[lei_motivo] TEXT NULL,
[lei_tipo] CHAR (1) NULL,
[lei_descricao] VARCHAR (30) NULL,
[lei_extra] CHAR (1) NULL,
[lei_tipo_uti] CHAR (1) NULL,
[TIPESPLEI_CODIGO] CHAR (4) NULL,
[LEI_REGULAVEL] CHAR (1) NULL,
[Codigo_integracao] VARCHAR (10) NULL
);
Target Object: (The column Lei_censo will be drop)
CREATE TABLE [dbo].[Leito] (
[lei_codigo] CHAR (4) NOT NULL,
[locatend_codigo] CHAR (4) NOT NULL,
[lei_status] CHAR (1) NULL,
[lei_motivo] TEXT NULL,
[lei_tipo] CHAR (1) NULL,
[lei_censo] CHAR (1) NULL,
[lei_descricao] VARCHAR (30) NULL,
[lei_extra] CHAR (1) NULL,
[lei_tipo_uti] CHAR (1) NULL,
[TIPESPLEI_CODIGO] CHAR (4) NULL,
[LEI_REGULAVEL] CHAR (1) NULL,
[Codigo_integracao] VARCHAR (10) NULL
);
Generated script
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
PRINT N'Altering dbo.Leito...';
GO
[HERE IS THE PROBLEM]
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
I changed a lot of options but the problem persist.
Thanks
Mussi
