Activity overview
Latest activity by nate.johnson
The left column shows the first portion of the index. The index is unique.
It looks like the PK isn't being used for comparison either. I checked the rows that are showing as identical and the PKs are different. / comments
The left column shows the first portion of the index. The index is unique.
It looks like the PK isn't being used for comparison either. I checked the rows that are showing as identical and the PKs ...
This is happening in the GUI as well. / comments
This is happening in the GUI as well.
Actually, this doesn't clear things up. I was using the SDK when I discovered the problem so I tried it in the GUI. Now that I look it over again, I see I am trying to use an index as the comparison key. The GUI allows you to specify either the PK or any of the indexes listed but has no option for a custom key in the dropdown when using a backup.
When I select an index as the comparison key, it falls back to the PK.
Sorry for the confusion, but the GUI should not allow selection of an index as comparison key if it is going to use the PK anyway. / comments
Actually, this doesn't clear things up. I was using the SDK when I discovered the problem so I tried it in the GUI. Now that I look it over again, I see I am trying to use an index as the compariso...
Compare live vs backup does not generate similar scripts
Hello,
I am trying to automate our database upgrade process by shipping a database backup and comparing with the customer database.
I have a working utility but the problem I am running into is tha...
SQL Compare ignores user defined function
I have a table valued function with changes that keeps getting ignored by SQL Compare. The changes are as follows:
The new function:
CREATE FUNCTION [dbo].[GetPricingTableEntryForPricePlanCostItemR...