Comments
Sort by recent activity
Thanks for your post.
There is not actually much you can do to speed up the performance of SQL Data Compare, you might be interested in looking at the following article, but I'm not sure it will be much help in your situation. http://www.red-gate.com/supportcenter/C ... 000166.htm
Does the new server have particularly different hardware or SQL Server version to the old one? / comments
Thanks for your post.
There is not actually much you can do to speed up the performance of SQL Data Compare, you might be interested in looking at the following article, but I'm not sure it will be...
Thanks for your post.
I suspect the problem is because your GUI project file is configured to 'include dependencies' and some other objects included in the project for synchronization are dependent on those excluded functions and users. This would mean that they will be sync'ed regardless of being unchecked.
If you are calling a project file from the command line you can remove the 'include dependencies' option by:
1. Open the GUI project
2. Run the Comparison
3. Select the 'Synchronization Wizard' button
4. Go to step 2. Dependencies
5. Uncheck 'include dependencies'
5. Cancel the Synchronization Wizard
6. Refresh the comparison.
7. Now when you run the command, the excluded objects should stay excluded.
I hope this is helpful. / comments
Thanks for your post.
I suspect the problem is because your GUI project file is configured to 'include dependencies' and some other objects included in the project for synchronization are dependent...
Yes, you can set the option 'Extended Properties' in
Project Configuration >> Options >> Ignore Ignore Extended Properties
Ignores extended properties on objects and databases when comparing and synchronizing databases. / comments
Yes, you can set the option 'Extended Properties' in
Project Configuration >> Options >> IgnoreIgnore Extended Properties
Ignores extended properties on objects and databases when comparing and syn...
I've just had some feedback from the developers with regards to this issue.
The problem seems to be a bug with Dev Express not liking some of the printers installed/not installed.
It might be that we cannot find a work around without upgrading the DevExpress components that we use in our tools, however this would mean a major upgrade of all our applications [image]
Would you be able to send me a list of the printers you have installed? Also, I never asked you to confirm the user privileges of your account. Are you using a local admin account? / comments
I've just had some feedback from the developers with regards to this issue.
The problem seems to be a bug with Dev Express not liking some of the printers installed/not installed.
It might be that ...
It sounds like it might be related to random memory corruption, however if this is the case then it's surprising you haven't noticed it somewhere else.
Is your machine configured to run a memory check on start-up?
Is this a consistent problem after you restart? / comments
It sounds like it might be related to random memory corruption, however if this is the case then it's surprising you haven't noticed it somewhere else.
Is your machine configured to run a memory ch...
You could try reinstalling .net 2.0. / comments
You could try reinstalling .net 2.0.
I've just had a message from our testing team, and they have encountered this error before.
They seem to get this error from time to time when running under VMWare on 64-bit guest operating systems.
Are you also running the tools under VMWare? If not, can you let me know your environment. / comments
I've just had a message from our testing team, and they have encountered this error before.
They seem to get this error from time to time when running under VMWare on 64-bit guest operating systems...
Can you try launching the application from a command prompt with an argument to create an error log?
Navigate to the install directory
e.g. C:/Program Files/Red Gate/SQL Compare 7
Then launch the application including the 2>error.log argument to create a log on a failed execution.
e.g. RedGate.SQLCompare.UI.exe 2>error.log
Please can you post the results here, or send them to support@red-gate.com. / comments
Can you try launching the application from a command prompt with an argument to create an error log?
Navigate to the install directory
e.g. C:/Program Files/Red Gate/SQL Compare 7
Then launch the a...
Thanks for your reply.
Unfortunately there is no way to ignore the highlighted differences in the SQL Differences pane. This view will always highlight any textual differences between the objects. SQL Compare will try to match them up as best it can, but it does not attempt to reorganise the sql. This is done mainly for speed, but also because most people still want to see that there are actually differences present.
If there are any semantic differences identified, you will need to skip past the known column order differences and review the other dissimilarities. / comments
Thanks for your reply.
Unfortunately there is no way to ignore the highlighted differences in the SQL Differences pane. This view will always highlight any textual differences between the objects. ...
SQL Compare shouldn't identify a difference in column order as a semantic difference, unless the 'Force Column Order' option is checked.
However, the actual textual difference in the object will still be highlighted in the SQL Differences pane, but the difference will not be included in the synchronisation script. / comments
SQL Compare shouldn't identify a difference in column order as a semantic difference, unless the 'Force Column Order' option is checked.
However, the actual textual difference in the object will st...