SQL Compare not comparing properly.
kevinwoodward
Posts: 5
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 !!!
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 !!!
Thanks,
Kevin Woodward
Kevin Woodward
Comments
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com