Activity overview
Latest activity by DennisRehm
The fix solved the problem for me, too. / comments
The fix solved the problem for me, too.
I'm experiencing the same issue and found this post from two years ago. It is a nuisance to have tables show up as different, but not be different when synchronizing. We expect no differences between our development and test servers and any differences need to be reviewed.
Any thoughts about implementing the enhancement, perhaps optionally? I am using SQL Compare 8.50.12.20.
Thanks. / comments
I'm experiencing the same issue and found this post from two years ago. It is a nuisance to have tables show up as different, but not be different when synchronizing. We expect no differences betwe...
I'm having the same problem. Unfortunately my database is on a hosted site and they do not wish to GRANT VIEW SERVER STATE for security reasons. Any suggestions?
Thanks. / comments
I'm having the same problem. Unfortunately my database is on a hosted site and they do not wish to GRANT VIEW SERVER STATE for security reasons. Any suggestions?
Thanks.
I am getting the same error comparing two SQL Server 2008 databases. If I connect as a sysadmin, everything is OK. If I connect as a db_owner, I get the Reading permissions error.
I need to compare to a SS2K8 hosted database where I cannot be a sysadmin.
Thanks,
Dennis / comments
I am getting the same error comparing two SQL Server 2008 databases. If I connect as a sysadmin, everything is OK. If I connect as a db_owner, I get the Reading permissions error.
I need to compare...
Print comparisons
I know there was a request for SQL Compare 6 that identical items could be skipped when printing a comparison report. If I'm printing, I'm interested in the differences. This could be an option tha...
SQL Servers 2005 and 2008
I downloaded the SQL Compare 7 beta in the hope that I could sync our new SQL Server 2008 Feb CTP with our existing SQL Server 2005 dev database. Worked perfectly and saved a lot of effort. I'll co...
Disable DML triggers did the trick! Thanks to RichardM. / comments
Disable DML triggers did the trick! Thanks to RichardM.
Inserting rows with identity column and instead of trigger
I have a table with an identity column. This value is generated by the database on an INSERT. The table also has an INSERT INSTEAD OF trigger to provide referential integrity for some values of a c...
Excluding column compares
I like the feature that row comparisons can be done on a limited number of columns. This is useful where columns may be updated by triggers and contain LastTimes. However, it appears that when I li...