Activity overview
Latest activity by Chris Spencer
This issue may be difficult for us to pinpoint without knowledge of the schema / data involved in the comparison. Are you able to create snapshots of the databases using SQL Compare? If so can you send them to chris.spencer@red-gate.com and I'll see if i can reproduce.
Chris / comments
This issue may be difficult for us to pinpoint without knowledge of the schema / data involved in the comparison. Are you able to create snapshots of the databases using SQL Compare? If so can you ...
My first suggestion would be to download SQL Data Compare v6.1.1 and see if this version has fixed it as I do recall getting something like this whilst testing the latest version.
Chris / comments
My first suggestion would be to download SQL Data Compare v6.1.1 and see if this version has fixed it as I do recall getting something like this whilst testing the latest version.
Chris
The best way that I can think of to do this is to use SQL Toolkit and automate the comparison. This would allow you to programatically set the WHERE clause as per the contents of a file.
Alternatively the project file (.sdc) contains readable xml and it may be possible to edit this directly rather than having to launch the UI each time. We don't support people doing this and the method is untested so it would perhaps be best to backup the file before any edits.
Hope this helps
Chris / comments
The best way that I can think of to do this is to use SQL Toolkit and automate the comparison. This would allow you to programatically set the WHERE clause as per the contents of a file.
Alternativ...
If it exists, any relevant information from the Event Viewer could also be very useful.
There should be an entry confirming the installation but there could also be entries relating to the failed attempt to launch the application.
Regards
Chris / comments
If it exists, any relevant information from the Event Viewer could also be very useful.
There should be an entry confirming the installation but there could also be entries relating to the failed a...
The Clone option has been directly replaced by the Save As which does exactly the same thing whilst offering the user the flexibility to name the project file whatever they want. Also from a usability perspective it is more consistent with other windows applications.
We could perhaps offer a default name for the project file. It's a good idea and will be considered for future releases.
Thanks for the feedback
Regards
Chris / comments
The Clone option has been directly replaced by the Save As which does exactly the same thing whilst offering the user the flexibility to name the project file whatever they want. Also from a usabil...
Hi
I can see the problem you are having and have subsequently raised an enhancement request internally.
However, I'm unable to give any timescale at the moment as to when it may get done.
Regards
Chris / comments
Hi
I can see the problem you are having and have subsequently raised an enhancement request internally.
However, I'm unable to give any timescale at the moment as to when it may get done.
Regards
C...
That's great news regarding the free upgrade to 6.
I really hope you like the new version as much as we do.
Regards
Chris / comments
That's great news regarding the free upgrade to 6.
I really hope you like the new version as much as we do.
Regards
Chris
Hi Scott
Apologies if this is causing you grief. Unfortunately, the only way to NOT have it reset everything is to get SQL Data Compare v6 as we have fixed the problem in this version.
I'm not aware of any workaround for version 5 sadly.
Regards
Chris / comments
Hi Scott
Apologies if this is causing you grief. Unfortunately, the only way to NOT have it reset everything is to get SQL Data Compare v6 as we have fixed the problem in this version.
I'm not awar...
That's excellent news. Thanks for letting us know [image]
Regards
Chris / comments
That's excellent news. Thanks for letting us know
Regards
Chris
It seems like you have set the SqlOptions correctly.
In my code example above there are some important assignments further down that ensure that the SqlOptions in TableMappings.Options are also used by the SQLProvider object.
It does it in 2 steps. Firstly:
session.Options = mappings.Options;
and then:
provider.Options = session.Options;
You might be able to get away with setting it directly e.g.
mappings.Options.SqlOptions = SqlOptions.DisableKeys
provider.Options.SqlOptions = mappings.Options.SqlOptions
Whatever technique you choose, I suspect that the reason that you are getting comments still is that you need to set up the options for the SqlProvider object. / comments
It seems like you have set the SqlOptions correctly.
In my code example above there are some important assignments further down that ensure that the SqlOptions in TableMappings.Options are also use...