Comments
Sort by recent activity
Hi Eddie,
thanks for your explanation. That's exactly how I understood the License when we purchased the products and we are using them according to this. I was just confused with the currently published License because this per-user model was not so obvious to me anymore. / comments
Hi Eddie,
thanks for your explanation. That's exactly how I understood the License when we purchased the products and we are using them according to this. I was just confused with the currently pub...
Just found out that this feature will be in SQL Data Compare 5. Great!
"SQL Data Compare 5 features:
....
- You can now compare tables where there is no primary key by using a custom key
...."
Peter Reskovic
Hermes SoftLab / comments
Just found out that this feature will be in SQL Data Compare 5. Great!
"SQL Data Compare 5 features:
....
- You can now compare tables where there is no primary key by using a custom key
...."
Pete...
I've just tried data comparison of tables without PKs in Data Compare 5 beta and it works perfectly for me. Great work!
Thank you for your support.
Peter Reskovic
Hermes SoftLab / comments
I've just tried data comparison of tables without PKs in Data Compare 5 beta and it works perfectly for me. Great work!
Thank you for your support.
Peter Reskovic
Hermes SoftLab
Nice to hear that you solved the problem.
But for Red gate, I hope they read the thread and that they will look into this for future versions. I see no reason why you shouldn't be able to compare tables without PKs, if you manualy select the comparison columns.
Red Gate? Anyone? [image] / comments
Nice to hear that you solved the problem.
But for Red gate, I hope they read the thread and that they will look into this for future versions. I see no reason why you shouldn't be able to compare t...
Hi,
I've run into the same problem. For me the problem was that SQL Data Compare can work only with tables that have comparison keys. Copy from help:
"SQL Data Compare can compare tables and views only if they have:
...
for tables, a primary key, unique index, or unique constraint that is matches in both databases; for views, a matching unique, clustered index".
This is logical, but on the other hand it could give you an option to include tables without comparison keys if you specify columns manually. In the second screen of the "New comparison wizard", where you select tables and views for comparison, the list of tables could include also all tables without keys, but this tables should be unselected by default. You could select them only if you select comparison columns first.
This functionality for manualy selecting comparison columns is already there, so I believe that this new feature might not be so difficult to implement.
Something very similar is for example possible in SQL Delta db comparison tool, which I also tried, but at the end I decided for Red gate bundle, because I found many other, more important benefits with this tools. But having this feature in Red Gate data compare tool would really save me a lot of trouble... / comments
Hi,
I've run into the same problem. For me the problem was that SQL Data Compare can work only with tables that have comparison keys. Copy from help:
"SQL Data Compare can compare tables and views ...