I want to be able to run multiscript on all databases from selected servers that match a regex
JamesMenzies
Posts: 1 New member
I have multiple servers containing hundreds of databases; old ones are constantly being removed and new ones created.
I want to be able to define a regular expression that will allow me to target all current databases on a given list of servers rather than the current behaviour where I have to define the list of databases as a list.
I want to be able to define a regular expression that will allow me to target all current databases on a given list of servers rather than the current behaviour where I have to define the list of databases as a list.
Tagged:
Answers
Sadly the feature you are seeking currently does not exist in SQL Multi Script.
I have added the details of this to an existing enhancement request and requested a review. However, I cannot guarantee the success or if approval is given what future version of SQL Multi Script it may appear in.
Many thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com