I suggest you ...

Make adding own scripts more easy (graphical) to do.

Adding own scripts is not an easy job to do now. Perhaps you could make it more graphical, copy/paste, drag/drop sort of thing?

49 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    rev shared this idea  ·   ·  Admin →

    Hi,

    We now have a beta version of a UI tool to help people generate scripts for use in SQL Scripts Manager. If you’re interesting in trying it out, here’s a link to it:
    http://www.red-gate.com/SSMScriptGenerator/v1

    There’s also an article about using it at http://www.simple-talk.com/sql/sql-tools/fast-and-free-sql-scripts-managers-script-generator/

    Thanks,

    Colin.

    3 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Colin Millerchip commented  · 

        Hi,

        Thanks for the feedback.

        @Rahul Ghosh: yes, it’s possible to add your own scripts into SQL Script Manager -- on the menu, if you select "Help -> How to Add Scripts", this will take you to some documentation about how to do this.

        In addition to the documentation, there’s a blog post with a worked example at http://www.simple-talk.com/sql/sql-tools/sql-scripts-manager-an-appreciation/ . Also here are a couple of template XML files, for what I expect are very typical scenarios:
        - running a script against a SQL Server instance (ie, with no other parameters) : http://www.simple-talk.com/content/file.ashx?file=4490
        - running a script against a specific database on a SQL Server instance : http://www.simple-talk.com/content/file.ashx?file=4489

        Whilst this does involve hand-editing XML, you can make this simpler with an editor like Notepad++, with XML highlighting (in Notepad++, select “Language -> XML” from the menu). The quid pro quo for embedding in XML, is that you get a number of benefits:
        - the parameters to the script can be exposed via the UI, optionally with default values assigned
        - documentation can be included, as well as information about the author
        - versioning can be managed
        - it’s also possible to digitally sign the script, so that any attempt to tamper with it would be clearly visible in the UI (note that at the moment, only the scripts that ship with the product are signed, we haven’t exposed a signing service yet)
        - the scripts can be tagged, plus the titles are searchable in the SQL Scripts Manager UI

        Please do keep the feedback coming!

        Best regards,

        Colin.

      • RAHUL GHOSH commented  · 

        How can I add some of my own scripts in this. Is there any way of doing so???
        I am blind lover of SQL SERVER, I have many things created for SQL server but i am not getting a way to introduced it to the world, how can i do that?? If any one helps me in this i will be thankful to him/her..

      Feedback and Knowledge Base