October 12, 2011 at 5:20 am
Hi Guys!
First Question::
We are working in Fast developement Environment.Where things are running very fast and changes are likely to be happened.
There are 250 DB on my SQL Server Now.
Unfortunately and we cannot stop this even I have processed many times.
DBs are getting increase in Number on daily basis ... Suppose if i am going to Home at Night and there are 250 DBs attached on the server>> And I have Created an instance of 250 DBs in the RedGate SQL Multiscript ....
When i came in the morning ... Our onsite team has created 09 DB more and they didn't inform us.
I came and start deployment on the 250 DBs and rest of DBs are still Unsynched.
PS: I dont want to go in "Database Configuration List" to manually Add.
Second QUESTION:
We are running some sets like:
1) DBName_Mobile
2) DBName_App
3) DBName_Images
There is no way to sort out things as per your requirements.
Like If i want to execute a script on "DBName_App" I will have to create a list. No sorting within Reggate Multiscript.
Thanks in advance.
October 12, 2011 at 6:51 am
Build your scripts dynamically by querying system catalog views etc. That way you are not executing scripts for a pre-defined list of databases and you can make them re-runnable.
Thanks
Chris
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply