SQL Compare not comparing properly.

kevinwoodward

I am running a compare, in that compare I have a table that has dropped or renamed 3 columns. This should be compared as a drop and an add in the compare and in script generation, but it seems that it is compared as equal since the colid, and data type and nullability happens to be the same.

I want to attach the picture of this, but i don't see a way to do it.



old table:
CREATE TABLE [dbo].[ServiceProcedureDefinition](
[sp_def_id] [varchar](36) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[created_by] [varchar](36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[created_date] [datetime] NULL,
[obsolete] [tinyint] NOT NULL,
[updated_by] [varchar](36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[updated_date] [datetime] NULL,
[version] [int] NULL,
[add_attachment] [tinyint] NOT NULL,
[clinical_review_requested] [tinyint] NOT NULL,
[guidelines] [varchar](512) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[location_code] [tinyint] NOT NULL,
[pl_code] [tinyint] NOT NULL,
[treatment_type] [tinyint] NOT NULL,
[bhp_node_id] [varchar](36) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[service_type_id] [varchar](36) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL)

new table

CREATE TABLE [dbo].[ServiceProcedureDefinition](
[sp_def_id] [varchar](36) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[created_date] [datetime] NULL,
[obsolete] [tinyint] NOT NULL,
[updated_date] [datetime] NULL,
[version] [int] NULL,
[clinical_review_requested] [tinyint] NOT NULL,
[guidelines] [varchar](512) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[hide_this_service_type] [tinyint] NOT NULL,
[show_auth_by] [tinyint] NOT NULL,
[show_location_code] [tinyint] NOT NULL,
[show_pl_code] [tinyint] NOT NULL,
[show_place_of_service] [tinyint] NOT NULL,
[show_treatment_type] [tinyint] NOT NULL,
[created_by] [varchar](36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[updated_by] [varchar](36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[bhp_node_id] [varchar](36) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[default_location_code_id] [varchar](36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[default_pl_code_id] [varchar](36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[default_place_of_service_id] [varchar](36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[default_treatment_type_id] [varchar](36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[default_unit_type_id] [varchar](36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[service_type_id] [varchar](36) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL)


Thanks !!!

Eddie D

Thank you for your post into the forum.

A support call has been created for you. Can you please send your screen shot or picture to support@red-gate.com and include the following call reference number in the subject field of your e-mail, F0031346.

In your e-mail reply, can you please provide information on the 3 columns that have been renamed.

Many Thanks
Eddie