Comments
Sort by recent activity
Hi Mike,
Thanks for your post.
We are hoping to implement this feature in the next version of SQL Data Compare so that users can synchronize a database with a set of scripts.
Can I ask you a few questions to help us research this further?
1. What do your data scripts look like? Do they contain DML statements or are they CSV or XML files, or something else entirely?
2. Would it be useful if SQL Data Compare could create a set of scripts from an existing database or is it just the synchronization process that you're after?
Alice. / comments
Hi Mike,
Thanks for your post.
We are hoping to implement this feature in the next version of SQL Data Compare so that users can synchronize a database with a set of scripts.
Can I ask you a few qu...
Regarding the filters, if you go to Application Options and browse to the folder listed as "Filter folder", you should be able to find your filters (they'll have a .scpf extension).
From the Filter panel on the comparison results grid, you can open the dropdown and select 'Open Filter From File' to re-add them. / comments
Regarding the filters, if you go to Application Options and browse to the folder listed as "Filter folder", you should be able to find your filters (they'll have a .scpf extension).
From the Filter...
Hi Traci,
The "view object synchronization script" has moved to the right-click context menu: just right-click in the SQL differences pane and choose "Show Object Synchronization Script".
In the next release of SQL Compare, you'll also be able to access this option if you right-click on an individual object in the comparison results pane. (Unfortunately this bit didn't make it into the Beta).
The reason why we moved it was because we'd prefer people to use the Synchronization Wizard to generate the SQL for their objects: that way things like dependencies and sync order are taken into account and script errors are less likely to occur.
Can I ask you for some examples of when you use this option? Do you use it to build your own sync scripts? Are there other times when it's useful? / comments
Hi Traci,
The "view object synchronization script" has moved to the right-click context menu: just right-click in the SQL differences pane and choose "Show Object Synchronization Script".
In the ne...
Hi there,
1 - This issue has been fixed internally and will be in the next release of SQL Compare.
2 - This one is still outstanding: I can't promise that it will be fixed for the next release, but your post increases the probability of it being addressed [image] / comments
Hi there,
1 - This issue has been fixed internally and will be in the next release of SQL Compare.
2 - This one is still outstanding: I can't promise that it will be fixed for the next release, but...
Hi there,
Thanks for your post.
SQL Compare reports will only show results for objects that have been selected for synchronization (i.e. objects that have a tick in the middle column of checkboxes).
In previous versions of Compare, all objects were automatically selected, but this behaviour has been changed in v8 after user tests showed that usually people only want to consider a small number of objects, or had worries that they may synchronize things by mistake.
We're aware of how this affects reporting though: would you rather have the reports always consider all objects regardless of their checkbox state?
Or would an option to choose whether to include all objects or just selected ones be better?
Your thoughts on this would be much appreciated!
Alice Easey
Red Gate Software / comments
Hi there,
Thanks for your post.
SQL Compare reports will only show results for objects that have been selected for synchronization (i.e. objects that have a tick in the middle column of checkboxes)...
Hi Stefano,
Sorry for not replying sooner: you're right, the Ignore Replication option is not working when synchronising from snapshots in the current release of SQL Compare :oops: .
We hope to have this issue fixed for the next release - please accept our apologies for any inconvenience caused in the mean time.
Alice Easey
Red-Gate Software Ltd / comments
Hi Stefano,
Sorry for not replying sooner: you're right, the Ignore Replication option is not working when synchronising from snapshots in the current release of SQL Compare :oops: .
We hope to ha...
Hi BJHop,
Can you check a couple of additional things please?
1. Is the registry key for RoboSource Control in HKEY_LOCAL_MACHINE\software\SourceCodeControlProvider pointing to a valid key?
2. Does your user have permissions set to access the registry?
Regards,
Alice Easey
Red Gate Software / comments
Hi BJHop,
Can you check a couple of additional things please?
1. Is the registry key for RoboSource Control in HKEY_LOCAL_MACHINE\software\SourceCodeControlProvider pointing to a valid key?
2. Does...
Hi Stefano,
Yes, snapshots generated by SQL Snapper should be compatible with SQL Compare 8.0 (please tell us if they aren't [image] ) / comments
Hi Stefano,
Yes, snapshots generated by SQL Snapper should be compatible with SQL Compare 8.0 (please tell us if they aren't )
Hi Angelo,
If you can send me (alice.easey@red-gate.com) some snapshots or scripts of the databases in question, I'll take a look for you and see if I can shed some light onto what the problem might be.
Alice Easey
Red Gate Software / comments
Hi Angelo,
If you can send me (alice.easey@red-gate.com) some snapshots or scripts of the databases in question, I'll take a look for you and see if I can shed some light onto what the problem migh...
Just to clarify this point a little:
There is a bug in SQL Compare where if the synchronisation process involves dropping an index, the index will be dropped; regardless of whether or not the Ignore Indexes option has been turned on.
Unfortunately SQL Compare doesn't yet work out which situations are safe to retain the index, but hopefully this issue will be looked at for a future release.
Alice Easey
Red Gate Software / comments
Just to clarify this point a little:
There is a bug in SQL Compare where if the synchronisation process involves dropping an index, the index will be dropped; regardless of whether or not the Ignor...