Comments
Sort by recent activity
The reason you can't find it documented anywhere is that it's actually a SQL Data Compare option, not a SQL Compare option - the original post appears to have been put in the wrong forum.
Sorry for the confusion. / comments
The reason you can't find it documented anywhere is that it's actually a SQL Data Compare option, not a SQL Compare option - the original post appears to have been put in the wrong forum.
Sorry for...
Good news - we have now fixed this problem in the latest version of SQL Doc 3 available from the website. / comments
Good news - we have now fixed this problem in the latest version of SQL Doc 3 available from the website.
If you can't connect to your SQL Server in any conventional way, but you can move files to the server, you could also use SQL Snapper to get the snapshot of the remote database.
You need to move the files RedGate.SQLSnapper.exe, RedGate.SOCCompareInterface.dll and System.Threading.dll from the SQL Compare install directory to any directory on the remote server, then run SQL Snapper and generate a snapshot.
Then you can move that snapshot file (which, just being the schema, should be considerably smaller than a backup file) back to your local machine and use that as the client DB copy. / comments
If you can't connect to your SQL Server in any conventional way, but you can move files to the server, you could also use SQL Snapper to get the snapshot of the remote database.
You need to move th...
That one's a particularly persistent bug caused by a compromise solution to the problem that full text operations interact poorly with transactions - it's on the list of issues we're actively looking at, but currently the workaround is to do two deployments - first with the fulltext objects and second with the procedures that depend on them.
We hope to have this fixed for v11. / comments
That one's a particularly persistent bug caused by a compromise solution to the problem that full text operations interact poorly with transactions - it's on the list of issues we're actively looki...
The last time I remember this happening to a customer, it was tracked down to their statistics not being set to auto-update, making one of our index-related queries run slower and slower.
I don't know if this is the case here, but it might be worth checking that the database is set to auto-create and auto-update statistics, and updating statistics on slow-running instances? (Especially as inserting data seems to have fixed one of them, which is an operation which can cause statistics to update...) / comments
The last time I remember this happening to a customer, it was tracked down to their statistics not being set to auto-update, making one of our index-related queries run slower and slower.
I don't k...
Have you tried the latest version (linked in the announcement above; http://downloads.red-gate.com/checkforu ... 4.8.87.exe or available through Check for Updates)? SC-6165 should be fixed in this version for identical objects in reports. / comments
Have you tried the latest version (linked in the announcement above; http://downloads.red-gate.com/checkforu ... 4.8.87.exe or available through Check for Updates)? SC-6165 should be fixed in this ...
I know I'm late to the party, but I just wanted to add that you can create multiple snapshots off the same server more easily by entering the server on one side of the Edit Project dialog, choosing 'Snapshot' from the other side, and using the 'Create Snapshot...' link there - which will automatically populate itself from the other side of the dialog. / comments
I know I'm late to the party, but I just wanted to add that you can create multiple snapshots off the same server more easily by entering the server on one side of the Edit Project dialog, choosing...
Hi there - you have probably lost the reference to C:\Windows\System32 and/or C:\Windows\SysWOW64 in your PATH environment variable, which lets us use mode.com to set the output width.
Other than the output width setting (including its default value) not working, this is a harmless error message you can ignore - it doesn't affect the operation of the command line in any other way. / comments
Hi there - you have probably lost the reference to C:\Windows\System32 and/or C:\Windows\SysWOW64 in your PATH environment variable, which lets us use mode.com to set the output width.
Other than t...
If you're using an older version of Windows, the SQL Compare and Data Compare command lines will now display this message when you run them.
It shouldn't affect their operation in any way - it's just that they're attempting to use a feature added in later versions to help fix awkward output in a few cases. The old behaviour should all be preserved in the case that this new feature is not available.
So - no need for concern, and we'll see if we can suppress the message in future versions. / comments
If you're using an older version of Windows, the SQL Compare and Data Compare command lines will now display this message when you run them.
It shouldn't affect their operation in any way - it's ju...
There is now a patch release of 10.2 which fixes a few problems that people reported with the new SSMS integration in SQL Server 2012 - you can get it from Check for Updates or the following download link: http://downloads.red-gate.com/checkforu ... .0.569.exe / comments
There is now a patch release of 10.2 which fixes a few problems that people reported with the new SSMS integration in SQL Server 2012 - you can get it from Check for Updates or the following downlo...