Colin Millerchip

My feedback

  1. 49 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      3 comments  ·  SQL Scripts Manager » Product feedback  ·  Flag idea as inappropriate…  ·  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.

      Colin Millerchip commented  · 

      As a number of people have asked about the script generate UI beta, 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/

      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.

    • 24 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        1 comment  ·  SQL Scripts Manager » Product feedback  ·  Flag idea as inappropriate…  ·  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.

        Colin Millerchip commented  · 

        Hi Rudy,

        Thanks for the feedback. This is quite similar to another piece of feedback, where I’ve posted some links to help the process of creating new scripts a bit easier (see http://sqlscriptsmanager.uservoice.com/forums/91553-sql-scripts-manager/suggestions/1325871-make-adding-own-scripts-more-easy-graphical-to-d?ref=comments ).

        On your point about sharing the scripts via a website, this is currently supported. On the Help menu, if you select “Find New Scripts”, you’ll be taken to a page on the SQL Server Central script wiki ( http://www.sqlservercentral.com/Scripts/rgtool/ ) which will allow you to both upload new scripts wrapped up into .rgtool files, as well as download any that have been contributed there. For eg, currently there are 6 addition scripts available for download as .rgtool files, that can be run in SQL Scripts Manager.

        Please do keep the feedback coming!

        Best regards,

        Colin.

      • 2 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          1 comment  ·  SQL Scripts Manager » New script requests  ·  Flag idea as inappropriate…  ·  Admin →
          Colin Millerchip commented  · 

          Hi, can you post to describe which scripts you're having problems with, and the error messages you're getting?

          Thanks,

          Colin.

        • 17 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            2 comments  ·  SQL Scripts Manager » Product feedback  ·  Flag idea as inappropriate…  ·  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.

            Colin Millerchip commented  · 

            We have some of what you're asking for. On the menu, if you select "Help -> How to Add Scripts", this will take you to further information about how to do this (we hope to extend this information ahead of initial release).

            Note that this requires that the scripts are embedded in an .rgtool XML file, rather than just managing the raw script. However, this provides 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

            It would be interesting to know whether you find this functionality useful for managing your own scripts.

          Feedback and Knowledge Base