Comments
Sort by recent activity
Yes, everything else will function the same, you just won't see the timeline. It's quite expensive on resources to populate the timeline, so if you don't mind not seeing it, it will probably boost the performance considerably. / comments
Yes, everything else will function the same, you just won't see the timeline. It's quite expensive on resources to populate the timeline, so if you don't mind not seeing it, it will probably boost ...
Hi Chris,
It's only a GUI setting, so you don't need to restart the engine.
I think 0 is on and 1 is off. I don't know what other values would do.
I've just tried this myself and it seems that the timeline is still displayed, but it doesn't draw on the various indicators for the backups, so the interface still looks the same.
If you're on 64bit, the reg key you need to create will be in wow6432node. / comments
Hi Chris,
It's only a GUI setting, so you don't need to restart the engine.
I think 0 is on and 1 is off. I don't know what other values would do.
I've just tried this myself and it seems that the ...
Thanks for your post.
Can you check how frequently you're deleting the old backup history in the SQL Backup history and the msdb database? If the history isn't getting deleted then performance will degrade over time. These settings are in Tools > server Options > File management.
Another thing you could try is to disable the timeline in the GUI.
If you want to disable the SQB timeline, set the (DWORD value) HKLM\Software\Red Gate\SQL Backup\Client\DisableTimelineItemRequests
to 1 to disable
Hopefully one or both of these suggestions will help. / comments
Thanks for your post.
Can you check how frequently you're deleting the old backup history in the SQL Backup history and the msdb database? If the history isn't getting deleted then performance will...
That would be great if you could.
You also might like to try using an XML arg file instead of the project file as a workaround. You reference the arg file like you reference the project file, but it's not as easy to create as there isn't a UI for it. / comments
That would be great if you could.
You also might like to try using an XML arg file instead of the project file as a workaround. You reference the arg file like you reference the project file, but i...
What happens if you use the command line switches rather than referencing a project file? e.g.
C:\Program Files (x86)\Red Gate\SQL Compare 9>sqlcompare /s1:MySourceServer /db1:MyDB /s2:MyTargetServer /db2:MyDB /options:default / comments
What happens if you use the command line switches rather than referencing a project file? e.g.
C:\Program Files (x86)\Red Gate\SQL Compare 9>sqlcompare /s1:MySourceServer /db1:MyDB /s2:MyTargetServ...
I haven't been able to reproduce this yet.
Does the problem remain if you create a brand new project file?
Also, could you try using the /Include:Indentical switch with the project file?
If neither of these make a difference, would you be able to send me a SQL Compare snapshot of the source and target schemas, and also the project file?
I should then be able to recreate the project here. / comments
I haven't been able to reproduce this yet.
Does the problem remain if you create a brand new project file?
Also, could you try using the /Include:Indentical switch with the project file?
If neither...
This is a bit strange. The command line comparison should be exactly the same as the GUI comparison.
What differences are being reported in the GUI? Are the objects listed in any of the 'objects with differences' groups in the top of the results grid, or are the differences only noticed in the SQL Differences pane at the bottom of the screen? / comments
This is a bit strange. The command line comparison should be exactly the same as the GUI comparison.
What differences are being reported in the GUI? Are the objects listed in any of the 'objects wi...
Yes, if you don't use the /synchronize(/sync) switch, then only the compare operation will be performed.
To synchronize, you have to specify the /sync switch. / comments
Yes, if you don't use the /synchronize(/sync) switch, then only the compare operation will be performed.
To synchronize, you have to specify the /sync switch.
Thanks for posting your solution.
Let us know if you have any other problems. / comments
Thanks for posting your solution.
Let us know if you have any other problems.
It looks like it's currently scheduled for SQL Compare 10, which I would probably expect some time next year. We're still in the process of another 9.x release, so v10 doesn't have a release date yet.
The development team have had another look at this and decided to not make you wait until v10. There should be a fix for this is the next SQL Source Control EA release (current EA is 3.0.0.50).
You can get involved with the EA here / comments
It looks like it's currently scheduled for SQL Compare 10, which I would probably expect some time next year. We're still in the process of another 9.x release, so v10 doesn't have a release dat...