Activity overview
Latest activity by Dominick Reed
We have had some people explain a scenario where they use this - they use SQL Compare as a way to browse the schema of a database in a more navigatable way than you can achieve, say, in Management Studio. If you compare the database to itself, then the distractions of how it differs to another data source are removed, so it can be a neat way to explore a schema more easily. / comments
We have had some people explain a scenario where they use this - they use SQL Compare as a way to browse the schema of a database in a more navigatable way than you can achieve, say, in Management ...
We've certainly had ideas in this area before - we even had scary thoughts of making it possible to compare and synchronize at the point where you're choosing a project...
However, one idea that gained a bit more impetus was to allow the user to flag a project as eligible for "one-step" synchronization. So after going through the synch wizard once, you'd be able to set this flag on the last step. The next time you open the synch wizard for this project on the first step you could then choose between synching immediately, or stepping through the wizard to maybe change a setting or two.
During all of the user testing that we have run, we do find that people have a real trepidation about making mistakes so we do very much err on the side of caution. I'll certainly raise this again for discussion, but I can't promise anything for version 8.
Thanks for the feedback. [image] / comments
We've certainly had ideas in this area before - we even had scary thoughts of making it possible to compare and synchronize at the point where you're choosing a project...
However, one idea that ga...
Hi Jonathan!
Thanks for your comments.
The intention here is to remove an unnecessary step from the wizard for those people that never want to make any kind of backup of their database before a synch. We're trying to avoid people having to always go through a step they may not care for.
However, if backing up is something you'd like to do, because the choice you make is persisted with the project, your choice of backup settings would then become part of a slightly longer synch wizard.
Does that make sense or do you think it's something that wouldn't work for you?
I'd appreciate other people's thoughts here too to see if we've got this (and the other changes we've made to the synch wizard) right. [image]
Dom / comments
Hi Jonathan!
Thanks for your comments.
The intention here is to remove an unnecessary step from the wizard for those people that never want to make any kind of backup of their database before a syn...
Whyioughta
*shakes fist*
If it wasn't for you pesky kids I'd have gotten away with it. / comments
Whyioughta
*shakes fist*
If it wasn't for you pesky kids I'd have gotten away with it.
Hi kepr00,
Thanks for the suggestion. This is something we have previously considered but time constraints have meant that this hasn't made it into the product. It's certainly something I'd like to see in there so it will be something we'll look at closely for any future versions. [image]
Dom / comments
Hi kepr00,
Thanks for the suggestion. This is something we have previously considered but time constraints have meant that this hasn't made it into the product. It's certainly something I'd like ...
Just running a comparison between two different databases is completely non-destructive. You can, if you decide to, choose to synchronize the two databases by running through the synchronization wizard. It's only at the final step of that, where it warns you very clearly, that your database will be modified.
Hope that helps.
:-)
Dom / comments
Just running a comparison between two different databases is completely non-destructive. You can, if you decide to, choose to synchronize the two databases by running through the synchronization w...
HotAir wrote:
I used "ATA" in my example because "SSF" in nowhere to be found.
Is this a defect or part of the beta that the candidates for snippets only contains up to "cuni"?
Thanks for the usage tip; I'm conditioned by how I use Visual Studio and I've always considered intellisense a completion tool "<type something>, now complete it" as opposed to "I want to complete what I type next, <type something>".
Only going up to Cuni is just a limitation of the snippets included with the beta, so yes, ssf would be in there for the final release.
Snippets should work both ways, hopefully. What we hope to be able to accommodate is both insertion by browsing, and insertion by completion. When you get to have a large number of snippets, chances are you're not going to remember all of them, so being able to browse a list is important - especially for infrequently used ones. This is facilitated by the CTRL + SPACE to browse a list.
Working the other way, typing "ata" should probably insert the snippet just in itself, but it could potentially lead to a few mistakes. Typing "ata" then pressing CTRL + SPACE should at the very least drop you onto the snippet in question and I thnk it's a bug that it doesn't do this.
leave it with us.
:-)
Dom / comments
HotAir wrote:
I used "ATA" in my example because "SSF" in nowhere to be found.
Is this a defect or part of the beta that the candidates for snippets only contains up to "cuni"?
Thanks for the us...
HotAir wrote:
There are no snippets that start with s. Where is the "select * from " snippet? The list only contains "acud" down to "cuni".
For the snippets to be efficient, the key combos necessary to generate them need to be much shorter than the text themselves.
SQLP2's "ssf" was efficient.
The SQLP3 key combos appear to be less efficient:
"ata" [crtl] + [space] + [crtl] + [R arrow] + [enter]
The most effient way to insert a snippet is to start by pressing CTRL + SPACE and then type the snippet. So your example above would be:
CTRL + SPACE + "ata" + ENTER
In fact, with that specific example you cite, you needn't type the whole snippet name as it's selected near the top of the list.
Hope that helps, [image]
Dom / comments
HotAir wrote:
There are no snippets that start with s. Where is the "select * from " snippet? The list only contains "acud" down to "cuni".
For the snippets to be efficient, the key combos nec...
Hi Mulmad,
This is one of the things that we had planned to do but due to time constraints it didn't make it into the final product. We might look to do in the future since you're not the first to mention this.
:-)
Dom / comments
Hi Mulmad,
This is one of the things that we had planned to do but due to time constraints it didn't make it into the final product. We might look to do in the future since you're not the first to...
Apologies for that, it was left in by mistake unfortunately. It is most definately 100% free, though, yours to enjoy until they invent telepathic computers that require no keyboards.
Of course, we're also hoping that come September time, you might take a look at the spangly new version 3, which we believe will be a significant improvement to version 2.
Dom / comments
Apologies for that, it was left in by mistake unfortunately. It is most definately 100% free, though, yours to enjoy until they invent telepathic computers that require no keyboards.
Of course, we...