Batch File to run a patch on multiple Sims DBs

[warrerj]

Hi

 

Does anybody have a batch script I could have a to run a patch on multiple Sims DBs?

We host all our schools on one citrix environment and don't use Solus so can't runt he patch from there.

 

thanks

[MrMat]

I don't have one to hand unfortunately as we do everything via S3 but it can definitely be done using DBUpgrade.

 

Run DBUpgrade from CMD with the /? switch and it will give you all the options etc.

[warrerj]

Thanks

I know I can runt he patches via DBUpgrade (thats what we currently do) I was hopign somebody would have a script ready to run a patch on multiple DBs so save reinventing the wheel

[matt40k]

It's like 5 mins work but it depends how clever you want to make it. How often are you adding \ removing databases? TBH, you could just be lazy and write 1 line, then copy and paste it for each database. To make it more clever, use PowerShell, query SQL for a list of databases then do a simple loop. It's worth doing it for yourself to get the skills as they are very useful, especially when your doing things on mass.