I have a file that I track data in. I just started getting a problem where SQL Source Control does not think two rows are the same. I commit and push changes, but it still thinks the two rows are not the same.
Any thoughts on how to get this right?
-- Only In Database
INSERT INTO [a].[InputMapping] ([InputType], [InputValue], [MappedValue], [MappedInt]) VALUES (N'Employer Organization', N'Dukes Restaurant', N'Duke''s', NULL)
INSERT INTO [a].[InputMapping] ([InputType], [InputValue], [MappedValue], [MappedInt]) VALUES (N'Employer Organization', N'Duke''s Restaurant', N'Duke''s', NULL)
-- Only In Source Control
INSERT INTO [a].[InputMapping] ([InputType], [InputValue], [MappedValue], [MappedInt]) VALUES (N'Employer Organization', N'Dukes Restaurant', N'Duke''s', NULL)
INSERT INTO [a].[InputMapping] ([InputType], [InputValue], [MappedValue], [MappedInt]) VALUES (N'Employer Organization', N'Duke''s Restaurant', N'Duke''s', NULL)
INSERT INTO [a].[InputMapping] ([InputType], [InputValue], [MappedValue], [MappedInt]) VALUES (N'Employer Organization', N'Dukes Restaurant', N'Duke''s', NULL)
INSERT INTO [a].[InputMapping] ([InputType], [InputValue], [MappedValue], [MappedInt]) VALUES (N'Employer Organization', N'Duke''s Restaurant', N'Duke''s', NULL)
INSERT INTO [a].[InputMapping] ([InputType], [InputValue], [MappedValue], [MappedInt]) VALUES (N'Employer Organization', N'Dukes Restaurant', N'Duke''s', NULL)
INSERT INTO [a].[InputMapping] ([InputType], [InputValue], [MappedValue], [MappedInt]) VALUES (N'Employer Organization', N'Duke''s Restaurant', N'Duke''s', NULL)