- or
1 result found
-
Allow multisubnetfailover to be specified in tools
We have a new SQL cluster that is built completely on dynamic ports with multiple points of failover. We have to hack the host file of the machine that's running multiscript to point to a single IP for each instance in order to get multiscript to run without timeout failures. The rest of the tools we have give us the option to add multisubnetfailover which solves this problem. Could we get that option in multiscript?
1 vote
19 results found
-
Include Indexes in SQL Search tool
SQL Search is able to go through that list of programmable db objects, but why not include indexes as well? If as developers we want to find something in our db instance, there should be a tool to include everything we are looking to find. It is a "search" tool; has that in the name. The tool is not called "Programmable Objects SQL Search", so why limit the search?
1 vote -
Add visibility for test functions
When you test a function (ie use the tsqlt.FakeFunction method) you have to specify a function that will replace the function being faked. This creates a dependency on that function. Currently these faked functions aren't visible in SQL Test. It would be great to be able to see them listed in the UI so that developers can see them. The functions are typically created within the same schema/class as the the test(s) so that's where they should be displayed. The names of the functions won't typically start with
testand won't have any extended properties on them as they are just normal functions, but are identifiable because they are in the test schema/class. It would be helpful to have some visible distinction that they aren't tests (maybe italicize the function name or give it a special icon instead of the normal bullet point?)When you test a function (ie use the tsqlt.FakeFunction method) you have to specify a function that will replace the function being faked. This creates a dependency on that function. Currently these faked functions aren't visible in SQL Test. It would be great to be able to see them listed in the UI so that developers can see them. The functions are typically created within the same schema/class as the the test(s) so that's where they should be displayed. The names of the functions won't typically start with
testand won't have any extended properties on them as they are…1 vote -
Support Test Setup in SQL Test
The tSQLt framework allows for the existence of a test procedure named
Setupwithin a test class that can be used to create data once instead in each of the individual tests. However, in SQL test if you create a test namedSetupit makes the test name betest Setupwhich isn't what is needed. You can see the documentation of theSetupin the following documentation for tSQLt:
https://tsqlt.org/130/creating-and-running-test-cases-in-tsqlt/
Can you make it so that if the test name specified isSetuporsetup(or any case variation thereof) that it will not prepend the wordtestto the new test name. When the test is created it should be displayed in the UI, but not executed when you run the test via the UI because the framework executes the procedure. This is because Setup is not a test, it is a component of all the tests in that class, so it should not be explicitly executed by SQL Test but needs to be visible in the UI so that developers know that it exists as part of the tests.The tSQLt framework allows for the existence of a test procedure named
Setupwithin a test class that can be used to create data once instead in each of the individual tests. However, in SQL test if you create a test namedSetupit makes the test name betest Setupwhich isn't what is needed. You can see the documentation of theSetupin the following documentation for tSQLt:
https://tsqlt.org/130/creating-and-running-test-cases-in-tsqlt/
Can you make it so that if the test name specified isSetuporsetup(or any case variation thereof) that it will not prepend the wordtestto…1 vote -
Make SQL Test Template File Location Configurable
In SQL Test there is a file called
TestCaseTemplate.sqlthat is in the Program Files folder for SQL Test.Can the folder location be configurable so that we can put the file in source control and then have it pointed at the folder where we have our local repos on our development machine?
1 vote -
shelly.miller@rev.io
Would like SQL Data Generator or automatically detect new or modified objects via the CLI and, if that option to automatically add new objects to the project has been chosen, add data to those new objects when the CLI is run.
1 vote -
Implement configurable caption property
Stumbled upon this feature from dbForge:
https://docs.devart.com/sqlcomplete/setting-up-sql-complete/ssms-caption-options.html (adding the section "SSMS Caption" to Options making it possible to customize the pattern for the main window title.
I frequently use to instances of SSMS - one running under my standard account and one running with an elevated account. I would use a feature like SSMS Caption to make it easy to distinguish a window from the standard instance and a window from the elevated instance.
1 vote -
Diagramming tool
If I'm designing a new application or adding a new feature to an existing one, I'll typically use the SQL Diagram feature in SSMS to design the tables and their relationships. It works okay, but has some limitations:
1) It's tied to a single server. If I want to get those diagrams onto a new server, well, I don't know a way to do it so they typically only exist on our dev servers. It'd be great to have a tool that kept these outside of SSMS and the SQL server. It wouldn't update the database on save, but would instead batch up changes until I was ready to commit them to a server.
2) It would be great if this combined some features of multi script and sql compare, and could be applied to a defined group of servers in one go, bringing all aspects of the affected schemas on those servers into line with the diagram
3) Every time I start a new diagramming session I need to set up my own custom table format, with the fields I care about. SSMS doesn't remember this when I start another new diagram. The tool I'm envisaging would remember.
4) Adding existing tables to the diagram from the SQL database (as in the SSMS tool), but with an option to treat these as part of the diagram or as external references (our model tables can have a relationship with them, but they remain read only in terms of the diagram)
If I'm designing a new application or adding a new feature to an existing one, I'll typically use the SQL Diagram feature in SSMS to design the tables and their relationships. It works okay, but has some limitations:
1) It's tied to a single server. If I want to get those diagrams onto a new server, well, I don't know a way to do it so they typically only exist on our dev servers. It'd be great to have a tool that kept these outside of SSMS and the SQL server. It wouldn't update the database on save, but would…
1 vote -
gMSA support for all RedGate products
gMSA support for all RedGate products
Increased security, less maintenance after initial setup. Compliance and auditors are constantly pushing for these changes.1 vote -
Data Compare and Sql Compare - Option to Uninstall Old Major Version
When upgrading and Data Compare or Sql Compare are going to a Major version, it would be nice to have an option to uninstall the old version. i.e. version 15 released and I didn't have an option to have it uninstall 14, so I had to manually uninstall it and make sure I didn't lose my settings / snippets / etc...
1 vote -
Provide RDS Support for Licensed and Unlicensed Users
Enhance how the tools are deployed within SSMS so it can better handle mixtures of licensed & unlicensed users in a RDS environment.
In a shared Remote Desktop Services environment where some users are licensed for the tools and some are not a license could be consumed by an unintended recipient. Of course, a license admin could revoke the license, etc, but this is overhead that is not desirable.
Simply removing the tools from the tool bar is a user action and only removes them from the tool bar. Other remnants of the tools still exist.
1 vote -
Add custom extended property options to SQL Doc
Please consider adding support to SQL Doc for custom extended property names. I've searched this functionality and have found other redgate forums going back several years where many users have reportedly requested this functionality, but I cannot find where it was ever added.
SQL Doc is a good tool, but adding support for users to maintain extended properties other that MS_Description would make this a great tool. As much as I appreciate this tool, I would not pay for this as a single application in its current form because it cannot meet my needs for maintaining my own extended property definitions.
Please consider adding support to SQL Doc for custom extended property names. I've searched this functionality and have found other redgate forums going back several years where many users have reportedly requested this functionality, but I cannot find where it was ever added.
SQL Doc is a good tool, but adding support for users to maintain extended properties other that MS_Description would make this a great tool. As much as I appreciate this tool, I would not pay for this as a single application in its current form because it cannot meet my needs for maintaining my own extended property…
1 vote -
Allow Additional licenses to be purchased at the current discount level.
We've been buying Red-Gate tools for way over 10 years, and have found them invaluable in our SQL development .
Up until a few years ago, when we purchased additional licenses. The Discount applied was for the total number of seats already owned.
ie If we had 10 users, and wanted an additional user. The new users license was priced at the 10 user discount level.
Now when we purchase a new license, we receive no recognition of our loyalty to Redgate. We would expect for 25 seats, there would be some recognition in terms of discount.
I've discussed this with my account manager, and we have managed to negotiate a discount on only the renewals next year, but its taken far to much of my time. Company policy before was to issue, all staff a license. Now we are looking for alternatives.
Can the licensing be changed to allow licenses, to charged at what ever discount level we have reached. And maybe even a 25+ discount level as well would be gratefully received.
Considering Redgate increase the prices by 10% (or 20% for perpetual) it doesn't seem like a big ask.
The other issue, is that I would prefer to have one license, I hold off buying new seats, until the renewal so I can just have one license to manage. If I could 'buy in' additional seats during the year, it would make administration a whole lot easier.
If someone from Reg-gate would care to comment, I would be interested to hear...
We've been buying Red-Gate tools for way over 10 years, and have found them invaluable in our SQL development .
Up until a few years ago, when we purchased additional licenses. The Discount applied was for the total number of seats already owned.
ie If we had 10 users, and wanted an additional user. The new users license was priced at the 10 user discount level.
Now when we purchase a new license, we receive no recognition of our loyalty to Redgate. We would expect for 25 seats, there would be some recognition in terms of discount.
I've discussed this…
1 vote -
A function to schedule scripts to run against multiple instances and autosave the results as csv
The ability to schedule scripts to run and save the results to a csv or add an email function
1 vote -
selecting the list of databases using a query instead of checking or unchecking manually
selecting the list of databases using a query instead of checking or unchecking manually once we selected the SQL instance where we want to execute the script.
e.g:- when we want to execute a script on the required databases instead of all databases in an instance, currently we can select SQL server instance and the databases in it all are considered for execution - if we want we can manually uncheck them - what if we have thousand of databases on an instance - manually unchecking the databases will be a nightmare, So we request a feature where after connecting to the instance we can select desired databases using a query where we want script to get executed.selecting the list of databases using a query instead of checking or unchecking manually once we selected the SQL instance where we want to execute the script.
e.g:- when we want to execute a script on the required databases instead of all databases in an instance, currently we can select SQL server instance and the databases in it all are considered for execution - if we want we can manually uncheck them - what if we have thousand of databases on an instance - manually unchecking the databases will be a nightmare, So we request a feature where after connecting…1 vote -
SQL Doc Show all Extended Properties for Triggers
With Triggers, you now only see the Extended Property with the MS_Description, but we also keep our Changelog in the Extended Properties. Please add the possibility to show multiple Extended Properties for Triggers. Maybe just as a table showing all Extended Properties, or moving Triggers to their own object, just like Stored Procedures.
The same problem exists for Views and a few other objects, that are now just a part of a DB-Table, but can be seen as their own object, as they can have multiple Extended Properties
2 votes -
SQL Doc Cover Page Options
There should be options for suppressing items on the Cover Page. The server and File Path options are not relevant when the created document is sent out to clients, we just want to provide them with relevant information.
1 vote -
Allow multisubnetfailover to be specified in tools
We have a new SQL cluster that is built completely on dynamic ports with multiple points of failover. We have to hack the host file of the machine that's running multiscript to point to a single IP for each instance in order to get multiscript to run without timeout failures. The rest of the tools we have give us the option to add multisubnetfailover which solves this problem. Could we get that option in multiscript?
1 vote -
Stop updating one app at a time.
The installer/updater needs to be improved to evaluate installed components and offer to update them all at once.
Today, when I opened SSMS, I received a suggestion to update SQL Prompt. When I was done I reopened SSMS. From within SSMS, I opened a Dependency Diagram and was offered to update that component, which also requested to close SSMS. When that was completed and SSMS was reopened, I needed to open SQL Compare, which, in its turn, offered to perform an update and requested to close SSMS.All this could have been accomplished with a single SSMS restart if the SQL Prompt updater were to offer to update other SQL Toolbelt Essentials components as well.
The installer/updater needs to be improved to evaluate installed components and offer to update them all at once.
Today, when I opened SSMS, I received a suggestion to update SQL Prompt. When I was done I reopened SSMS. From within SSMS, I opened a Dependency Diagram and was offered to update that component, which also requested to close SSMS. When that was completed and SSMS was reopened, I needed to open SQL Compare, which, in its turn, offered to perform an update and requested to close SSMS.All this could have been accomplished with a single SSMS restart if the…
5 votes -
How do you use SQL Toolbelt Essentials?
If you and your colleagues are Toolbelt or Toolbelt essentials users we would like to talk to you. We are thinking of ways to improve the usability and awareness of the tools within these bundles. We are keen to learn how you use these tools and what improvements we could make so it fits better into your workflow. Your insights will be very valuable in helping us guide the future of the products. If you are interested please complete this short survey, so we can get in touch with you!
Survey Link: https://forms.office.com/r/cVpKr228i2
1 vote
- Don't see your idea?