Comments
Sort by recent activity
The trouble with only comparing a subset of the objects is that we can't detect and bring in any dependencies you may have with unselected objects, making the resulting synch scripts unreliable. So it's a trade off between speed and reliability so we chose reliability.
Did you know that it is possible to take a schema snapshot with SQL Compare (or the free SQL Snapper) and copy this from your remote sites and compare them locally? This should speed up the process considerably. Please let me know if this works for you.
Kind regards,
David Atkinson
Product Manager
Red Gate Software / comments
The trouble with only comparing a subset of the objects is that we can't detect and bring in any dependencies you may have with unselected objects, making the resulting synch scripts unreliable. So...
I see your point. It's allowing exact searches to be substrings as well, which it probably shouldn't! We'll review this behaviour and hopefully improve what it does.
Thanks,
David / comments
I see your point. It's allowing exact searches to be substrings as well, which it probably shouldn't! We'll review this behaviour and hopefully improve what it does.
Thanks,
David
"Exact" does a full string match. If it is unchecked, it treats each word (separated by a space) separately. The analogy in a Google search would be to put the search term in quotes.
So in the case where you have just one word it should make no difference.
We're aware that the terminology is confusing. How could we improve this?
David Atkinson
Red Gate Software / comments
"Exact" does a full string match. If it is unchecked, it treats each word (separated by a space) separately. The analogy in a Google search would be to put the search term in quotes.
So in the case...
I'm not sure I understand. Is this because ALTER assumes the object exists, whereas DROP/CREATE will work regardless?
David Atkinson
Red Gate Software / comments
I'm not sure I understand. Is this because ALTER assumes the object exists, whereas DROP/CREATE will work regardless?
David Atkinson
Red Gate Software
Hi,
Are you asking for an option to search the data of a table? At the moment we just search the text of schema objects, but of course we could add this in a later release.
David Atkinson
Red Gate Software / comments
Hi,
Are you asking for an option to search the data of a table? At the moment we just search the text of schema objects, but of course we could add this in a later release.
David Atkinson
Red Gate ...
Could this simply be solved if we added an additional option to exclude these 4-part objects from the synchronization script?
I'd be curious to hear from anyone else who is experiencing similar issues.
David Atkinson
Red Gate Software / comments
Could this simply be solved if we added an additional option to exclude these 4-part objects from the synchronization script?
I'd be curious to hear from anyone else who is experiencing similar iss...
That's a great idea. I guess that there's a fair chance that the object that was modified the latest is the one that should be preserved. Do you want to actually see the modified date for each object, or is it enough to know which is more recent?
David Atkinson
Product Manager
Red Gate Software / comments
That's a great idea. I guess that there's a fair chance that the object that was modified the latest is the one that should be preserved. Do you want to actually see the modified date for each obje...
Just to give you a couple of options, remember that we have a free snapshot tool, SQL Snapper, that you can use independently of SQL Compare.
You can also cancel the Project Configuration dialog and access the snapshot menuitem without having to do a comparison first.
David Atkinson
Red Gate Software / comments
Just to give you a couple of options, remember that we have a free snapshot tool, SQL Snapper, that you can use independently of SQL Compare.
You can also cancel the Project Configuration dialog an...
Thanks for the request. We'll definitely consider this, especially since SQL Prompt and SQL Refactor current have this ability!
Kind regards
David Atkinson
Product Manager
Red Gate Software / comments
Thanks for the request. We'll definitely consider this, especially since SQL Prompt and SQL Refactor current have this ability!
Kind regards
David Atkinson
Product Manager
Red Gate Software
SQL Compare 9.5 not only allows column mapping, but also has a migrations feature, allowing the user to specify their own custom scripts to override default SQL Compare behavior. This works in conjunction with SQL Source Control. http://www.red-gate.com/MessageBoard/vi ... 1312#51312
Let us know if this meets your expectations.
David Atkinson
Red Gate Software / comments
SQL Compare 9.5 not only allows column mapping, but also has a migrations feature, allowing the user to specify their own custom scripts to override default SQL Compare behavior. This works in conj...