SQL Compare not comparing properly.

kevinwoodwardkevinwoodward Posts: 5
edited February 10, 2010 12:58PM in SQL Compare Previous Versions
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 !!!
Thanks,
Kevin Woodward

Comments

  • Eddie DEddie D Posts: 1,803 Rose Gold 5
    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
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.