craiginscotland
  • Posts: 2
  • Joined: 11/8/2012
Firstly, thank you for all your hard work, it is much appreciated. I'd like to share a suggestion for a new feature with you.

Instead of right clicking in the query window and being able to "Script Object AS Create", I would love to past text from elsewhere, containing the names of multiple objects, and then right click and have the alter/create options generate a script for all selected items.

I typically have a list of procedure names that I have pasted from a spreadsheet or email, and I synch my databases by clicking the "Script ..." context menu on each in turn, but ideally, if I highlighted 5 lines in the middle of a query window, I'd love a feature that would loop through that text, parsing each line in turn, and producing create/alter scripts in a batch with the "go" between them.

Andrei
  • Posts: 398
  • Joined: 7/1/2012
I understand your requirement. I think that it is possible to implement that, BUT, what to do, if identifiers are not unique ? Currently you get a drop-down where you can select exact object, that you want to script. What to do in your case ?
Options:
-Ignore identifiers, that have several matching objects and show info-message at the end
-show some kind of pre-selection list with all matched objects, so you can choose via check-boxes which objects should be scripted

other ideas ?
craiginscotland
  • Posts: 2
  • Joined: 11/8/2012
Oh, I never noticed the menu as I have never tried on a partial match, so I have learned something new.

Even a basic version would be good as in my case I will never have anything but fully schema qualified names. However, I would suggest that a pop up says "could only match 5 out of 7" objects (for example). You would then be asked if you wanted to continue with only the 5.

You might also get a checkbox that allows the user to choose to move all the problem lines together, so you that way you can do something with all the problem ones, like perhaps in your partial match example the user would simply expand the text on each line and then highlight only those lines, that will now be together and try again.

Such scripts would simply go to a new query window on the same connection.

Thanks for the quick reply, again much appreciated.
Andrei
  • Posts: 398
  • Joined: 7/1/2012
Ok, everything is clear. I like your proposal and I have added it to out to-do list. Please be patient, it might be implemented in early 2013.
  • You cannot post new topics in this forum.
  • You cannot reply to topics in this forum.
  • You cannot delete your posts in this forum.
  • You cannot edit your posts in this forum.
  • You cannot create polls in this forum.
  • You cannot vote in polls in this forum.