Activity overview
Latest activity by retm1109
I have found your product does not like constraints very well. I had several constraints fail in a comparison of a development and a test database whereby we introduced (2) column changes ( additions ) and (3) view changes, and 4 procedure changes to support new columns. The offending columns were not related to the changes either. Just happened to be columns with constraints. / comments
I have found your product does not like constraints very well. I had several constraints fail in a comparison of a development and a test database whereby we introduced (2) column changes ( additi...
I have a development database. And a test database.
I added two columns to a table, updated (2) views, (3) procedures to support new columns and I received this on a update from Development to Test.
The following error message was returned from the SQL Server:
There is no table: Docs].[tmp_rg_xx_ContentNodes. I'm guessing this is some work table being used by SQL Compare application.
[2714] There is already an object named 'DF__ContentNo__Activ__53D770D6' in the database.
Could not create constraint. See previous errors.
The following SQL command caused the error:
CREATE TABLE [Docs].[tmp_rg_xx_ContentNodes]
(
[...
[Active] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ContentNo__Activ__53D770D6] DEFAULT ('A')
)
The following messages were returned from the SQL Server:
[5701] Changed database context to 'WP3Test'.
[0] Dropping extended properties / comments
I have a development database. And a test database.
I added two columns to a table, updated (2) views, (3) procedures to support new columns and I received this on a update from Development to Tes...