Comments
Sort by recent activity
The most likely issue is that you might not have the required VIEW SERVER STATE permissions on your dev instance. SQL Compare attempts to decrypt encrypted objects, but will show this message if it was unable to do so (or if the option was disabled). The most common reason for being unable to decrypt an object is insufficient permissions on the server. / comments
The most likely issue is that you might not have the required VIEW SERVER STATE permissions on your dev instance. SQL Compare attempts to decrypt encrypted objects, but will show this message if i...
Looking through the release notes, version 13.7.3.9483 fixed a "threading deadlock when the source is a scripts folder" - does that match the problem you're having? / comments
Looking through the release notes, version 13.7.3.9483 fixed a "threading deadlock when the source is a scripts folder" - does that match the problem you're having?
Unfortunately SQL Compare doesn't support partial registration of the database schema, however there is a workaround that will achieve the same result if you don't mind creating an extra user account for the SQL Compare connection. If you deny VIEW DEFINITION on these synonyms, SQL Compare will not be able to see them. This may give you the performance boost you need, although of course any dependencies involving the synonyms will be ignored. / comments
Unfortunately SQL Compare doesn't support partial registration of the database schema, however there is a workaround that will achieve the same result if you don't mind creating an extra user accou...
Thanks for reporting this - we fixed the bug in version 13.7.2.9407, which was released in mid-February. / comments
Thanks for reporting this - we fixed the bug in version 13.7.2.9407, which was released in mid-February.
We've released SQL Compare 13.7.4.9637, which has a fix for SC-10434, to our frequent updates channel. You can turn on frequent updates from the Help menu. Do the comparison reports work as you'd expect in this version? / comments
We've released SQL Compare 13.7.4.9637, which has a fix for SC-10434, to our frequent updates channel. You can turn on frequent updates from the Help menu. Do the comparison reports work as you'd...
This is a temporary file which is normally deleted when SQL Data Compare exits (or when you close the project when using the GUI). My guess would be that a cleanup utility running on the same machine has deleted the file while it was in use. If you have difficulty identifying the process that is doing this, an alternative solution would be to set an environment variable called RGTEMP, which will tell SQL Data Compare where to store such temporary files. / comments
This is a temporary file which is normally deleted when SQL Data Compare exits (or when you close the project when using the GUI). My guess would be that a cleanup utility running on the same mach...
There's are some basic troubleshooting steps regarding exit code 505 here: https://documentation.red-gate.com/sbu7/errors-and-warnings/sql-backup-errors-500-5292 If those don't help, you should probably contact support@red-gate.com with a log file. / comments
There's are some basic troubleshooting steps regarding exit code 505 here:https://documentation.red-gate.com/sbu7/errors-and-warnings/sql-backup-errors-500-5292If those don't help, you should proba...
It sounds like you'll need to use an SVN client to look at the revisions manually and try to search for the duplicate object definitions. This shouldn't be affected by which user you run as - either you have permission to access the repository or you don't. It seems more likely that the duplicate object definition was added at about the same time as you switched users, but it's difficult to say that for sure! / comments
It sounds like you'll need to use an SVN client to look at the revisions manually and try to search for the duplicate object definitions. This shouldn't be affected by which user you run as - eith...
Unfortunately we don't support SQL Server 2000 for most of our products any more - you may have some luck with an old version of SQL Search, but remember to turn off automatic updates before you try this. / comments
Unfortunately we don't support SQL Server 2000 for most of our products any more - you may have some luck with an old version of SQL Search, but remember to turn off automatic updates before you tr...
SQL Data Compare attempts to simplify the mappings configuration each time you make a change. However, the project file can sometimes get bloated after a large enough number of modifications to the mappings configuration, especially if the same project is reused across significantly different database schemas. If this has happened, it might be worth creating a new project file and setting up your columns to compare again. If you're curious, you can take a look at the project file in Notepad and see what is going on under the hood, it's just an XML file although it's not particularly human readable. / comments
SQL Data Compare attempts to simplify the mappings configuration each time you make a change. However, the project file can sometimes get bloated after a large enough number of modifications to th...