It keeps doing drop table... why?!
dcolak
Posts: 2
SQL2005...
Detected differences:
[description_national] [nvarchar] (max) COLLATE Modern_Spanish_CI_AS NULL,
[description_international] [nvarchar] (max) COLLATE Modern_Spanish_CI_AS NULL,
versus
[description_national] [text] COLLATE Modern_Spanish_CI_AS NULL,
[description_international] [text] COLLATE Modern_Spanish_CI_AS NULL,
new columns and constraints:
[msrepl_tran_version] [uniqueidentifier] NOT NULL DEFAULT (newid()),
[tarifario_original_price_in_business_currency] [money] NULL
ALTER TABLE [dbo].[TB_NEG_ITI] WITH NOCHECK ADD CHECK (([ITI_COR]>(639934) AND [ITI_COR]<(800000)))
It keeps trying to recreate the table instead of just altering it. Why? Because of convert text to nvarchar(max)? Is it the new column that makes problems, maybe the constraint?
It would be fine if it worked, but, it fails because of all the constraints it drops in the wrong order... There are 160 objects in total (tables), most of them it tries to drop and create...
We're at this moment lost. We cannot drop and create a table of 1.5M rows each time we add a new column.
Thanks.
Detected differences:
[description_national] [nvarchar] (max) COLLATE Modern_Spanish_CI_AS NULL,
[description_international] [nvarchar] (max) COLLATE Modern_Spanish_CI_AS NULL,
versus
[description_national] [text] COLLATE Modern_Spanish_CI_AS NULL,
[description_international] [text] COLLATE Modern_Spanish_CI_AS NULL,
new columns and constraints:
[msrepl_tran_version] [uniqueidentifier] NOT NULL DEFAULT (newid()),
[tarifario_original_price_in_business_currency] [money] NULL
ALTER TABLE [dbo].[TB_NEG_ITI] WITH NOCHECK ADD CHECK (([ITI_COR]>(639934) AND [ITI_COR]<(800000)))
It keeps trying to recreate the table instead of just altering it. Why? Because of convert text to nvarchar(max)? Is it the new column that makes problems, maybe the constraint?
It would be fine if it worked, but, it fails because of all the constraints it drops in the wrong order... There are 160 objects in total (tables), most of them it tries to drop and create...
We're at this moment lost. We cannot drop and create a table of 1.5M rows each time we add a new column.
Thanks.
Comments
I'm also interested in the problem with constraints - it ought to get the order right. Could I have some more details about that, please? (Ideally snapshots of the relevant databases to michelle.taylor@red-gate.com, but I understand that you might not be allowed to send so much information.)
Redgate Software