Red Gate forums :: View topic - Conflict on identical object schema
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 2
SQL Source Control 2 forum

Conflict on identical object schema

Search in SQL Source Control 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
DarrenGuy



Joined: 09 Sep 2011
Posts: 5

PostPosted: Fri Nov 25, 2011 4:33 pm    Post subject: Conflict on identical object schema Reply with quote

Using ver 2.2

I have the following scenaria. I have two tables that are identical, but the column order of the two tables is different

eg.

CREATE TABLE [dbo].[Suppliers](
[Id] [uniqueidentifier] ROWGUIDCOL NOT NULL,
[TenantId] [uniqueidentifier] NOT NULL,
[SupplierTypeId] [uniqueidentifier] NOT NULL,
[Status] [int] NOT NULL,
[SupplierStatus] [int] NOT NULL,
[Code] [nvarchar](20) NOT NULL,
[Name] [nvarchar](50) NOT NULL
)

CREATE TABLE [dbo].[Suppliers](
[Id] [uniqueidentifier] ROWGUIDCOL NOT NULL,
[TenantId] [uniqueidentifier] NOT NULL,
[SupplierTypeId] [uniqueidentifier] NOT NULL,
[Status] [int] NOT NULL,
[Code] [nvarchar](20) NOT NULL,
[Name] [nvarchar](50) NOT NULL,
[SupplierStatus] [int] NOT NULL
)

The only difference between the structure of the two objects is the location of the SupplierStatus field

However in SQL Source Control, when pulling the latest changes from my Kiln repository it is reporting a conflict.

Use SQL Compare, it is reporting that this object between two databases are identical.

Is there a way within SQL Source Control to indicate that this type of conflict is not actually a conflict at all and can be safely ignored
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1123
Location: My desk.

PostPosted: Fri Nov 25, 2011 5:12 pm    Post subject: Reply with quote

Thanks for posting.

It looks like originally, SQL Source Control would have indeed ignored column order differences, but quite a lot of people wanted it to pick these up. It was altered in 2.1 to see this as a change (see here)

Unfortunately this wasn't done as a configurable option so I don't think there's currently any easy way of changing it back.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group