Activity overview
Latest activity by Peter
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...
Licensing question
If I remember well the License for SQL compare and other tools allowed one user to install the software on multiple computers, as long as it was used by one user (for example, on home computer, wor...
DC generates script with multiple drop/add FK constraints
SQL Server 2000 SP3
Data Compare 5.0.0.2003
When comparing two DBs I noticed strange behavior of Sync wizard: I start sync wizard, save sql script, cancel sync wizard, and reopen sync wizard again....
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
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...
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 ...