Comments
Sort by recent activity
Is there a "more details" or "send report" link next to the error message? SQL Compare manipulates paths in quite a lot of places, but we try to handle such errors more gracefully than that. Specifically in deployment, you might want to check the backup/snapshot creation options in case there's an invalid path in one of those. If you're deploying to a scripts folder, any database objects with unusual characters in their names would arouse suspicion. However, I've tried those and wasn't able to reproduce the issue. / comments
Is there a "more details" or "send report" link next to the error message?SQL Compare manipulates paths in quite a lot of places, but we try to handle such errors more gracefully than that. Specif...
Sounds like you have some quite complex jobs defined. Is this a symptom of a more general problem, where you need to search within the definition of a large object? Perhaps the lower pane just needs a find dialog? / comments
Sounds like you have some quite complex jobs defined. Is this a symptom of a more general problem, where you need to search within the definition of a large object? Perhaps the lower pane just ne...
I'd expect it to work fine without consistent versions. However, it is worth upgrading the server components, since most of the bugfixes are there and the user interface changes relatively little. / comments
I'd expect it to work fine without consistent versions. However, it is worth upgrading the server components, since most of the bugfixes are there and the user interface changes relatively little.
Unfortunately SQL Data Compare 6 is no longer supported - even if we manage to reproduce the issue here, it would be difficult to build and release an updated version of the product. If you can verify that the latest version is also affected, then we'd be happy to take a look at the bug. / comments
Unfortunately SQL Data Compare 6 is no longer supported - even if we manage to reproduce the issue here, it would be difficult to build and release an updated version of the product. If you can ve...
Upgrades are normally cheaper than the full product license, but you'll need to contact Sales. Here are some contact details: https://documentation.red-gate.com/xx/upgrading / comments
Upgrades are normally cheaper than the full product license, but you'll need to contact Sales. Here are some contact details: https://documentation.red-gate.com/xx/upgrading
SQL Data Compare 6.1 is about a decade old, so I'd recommend a free trial of a more recent version. The best version to use depends on which version of SQL Server you need to connect to. Did you mean to say that you regularly use SQL Server 2000 and 2005 without problems, or that you only use later versions?
If you're only using SQL Server 2005 or later, I'd recommend trying SQL Data Compare 13, the currently supported version.
SQL Data Compare 11 still connected to SQL Server 2000 (though this wasn't officially supported).
/ comments
SQL Data Compare 6.1 is about a decade old, so I'd recommend a free trial of a more recent version. The best version to use depends on which version of SQL Server you need to connect to. Did you m...
We rewrote a lot of the indexing code last year; it was released in November (version 3.0.4). Did you notice SQL Search get any better or worse since then? The main complication with a "stop" button is that you'd end up with a half-populated index, which means your searches would return incomplete results. I guess we could keep the old index hanging around until the new index has been completely built, but this would increase disk/memory usage and might confuse users by returning outdated results while the rebuild is in progress. We'll investigate further, but it may well turn out to be impractical. / comments
We rewrote a lot of the indexing code last year; it was released in November (version 3.0.4). Did you notice SQL Search get any better or worse since then?The main complication with a "stop" butto...
Unfortunately, I don't think SQL Data Generator can encrypt your data for you. As a workaround, you could create a table with the equivalent unencrypted columns and then select the data across with a call to your encryption routine. / comments
Unfortunately, I don't think SQL Data Generator can encrypt your data for you. As a workaround, you could create a table with the equivalent unencrypted columns and then select the data across wit...
We've just released 13.4.0 to our Frequent Updates channel, which should fix this bug. You can turn on frequent updates from the Help menu. / comments
We've just released 13.4.0 to our Frequent Updates channel, which should fix this bug. You can turn on frequent updates from the Help menu.
I'm not sure what best practice is, but I can offer a solution that should work: table variables don't participate in transactions. If you store your results in a table variable, you should still be able to copy them to the real results table after the transaction has been rolled back. http://www.sqlservercentral.com/blogs/steve_jones/2010/09/21/table-variables-and-transactions/ / comments
I'm not sure what best practice is, but I can offer a solution that should work: table variables don't participate in transactions. If you store your results in a table variable, you should still ...