SqlDbx Forum

Allen

Member

SendTo - Massive Productivity Enhancement

It would be nice to be able to directly ship objects between servers.

For instance:
    I'd like to be able to highlight multiple objects, right-click and select a 'SendTo' menu option.
    A sub-menu should pop up showing me a list of SERVERS that I'm connected to.
    Selecting a server should display another sub-menu showing a list of databases on that server.
    Once a database is selected, then those objects' CREATE scripts should be executed on that server/database.
    Save the database that was previously selected in Session State.

To perform this task right now, you have to:
    Select the objects
    Select 'Script Create'
    Copy the text out of the script window
    Switch windows to the other server
    Add a new script tab
    Paste in scripts
    Execute scripts
    Close script tab
    Decline msgbox asking you to 'save' the script
    Switch windows back to the original server
    Close the script tab there as well
    Decline (again) msgbox asking you to 'save' the script

Xolo - What do you think?

sqldbxhelp

Administrator

Re: SendTo - Massive Productivity Enhancement

I agree. This can be a useful feature to have