Activity overview
Latest activity by ChrisClark
Hi Brian,
Thanks for your reply. About ten minute before your post I actually tracked this down (using filemon) to the C:\Program Files\Red Gate\SQL Bundle 5\RedGate.SQLDataCompare.Distribution.mod file that is created when SqlDataCompare runs. Unfortunately the package is running through the command line as a non-privileged user, and so doesn't have permissions to write to the Program Files folder. I have given the user the appropriate permissions but I would suggest that SqlDataCompare should not be writing out to privileged folders (it goes against Windows Logo guidelines!) - perhaps the All Users folder in Documents and Settings would be a better place for this file?
Cheers,
Chris / comments
Hi Brian,
Thanks for your reply. About ten minute before your post I actually tracked this down (using filemon) to the C:\Program Files\Red Gate\SQL Bundle 5\RedGate.SQLDataCompare.Distribution.mod...
Permissions required by SqlDataCompare
Hi,
Can anyone tell me what sql permissions are required by SqlDataCompare to perform a comparison and produce (but not execute) a synchronisation script? I have a comparison failing with error cod...
Further to this, I've just run the same script through QA, having manually edited it to include GOs after each set of table updates - the whole thing completed in 1 minute 10 seconds! I'd say that this is fairly conclusive but I can't see why Sql 2005 is unable to handle a 10mb batch....does anyone have any suggestions? / comments
Further to this, I've just run the same script through QA, having manually edited it to include GOs after each set of table updates - the whole thing completed in 1 minute 10 seconds! I'd say that ...
Hi Eddie,
Thanks for your reply. I'm currently using a Where clause to synchronise a very specific subset of the data. The only other thing I could do is use a Where clause to horizontally partition data and generate a separate script for each partition; ideally I'd like to avoid this as it means I'd have to manually create a transaction to wrap the scripts in.
Cheers.
Chris / comments
Hi Eddie,
Thanks for your reply. I'm currently using a Where clause to synchronise a very specific subset of the data. The only other thing I could do is use a Where clause to horizontally partitio...
insufficient system memory error during synchronisation
Hi,
I'm using SqlDatacompare to produce a 10mb synchronisation script. When I attempt to apply this script using Sql Management Studio or SqlCmd, the script runs for approximately 20 mins and then ...