[sims] How to import emailed patch to SOLUS for deployment?

[coolhands]

Capita have emailed me some patches that need applying. I know I can use dbupgrade to do so once I have extracted them from zipped file etc.

 

But if they were in solus I could schedule them for deployment after hours? But they are not in solus so how can I add them?

 

Any help appreciated

[BKGarry]

I am afraid Manual Patches like this can't be scheduled (from what I know) You will have to manually apply then with dbupgrade.

[coolhands]

ok thanks. Do you know if windows task scheduler can be sorted to run the dbupgrade programme to install the patches etc? seems daft to have to actually have to be here to do it manually once staff have left / off sims

[BKGarry]

I do not think you can put the switches in to make it install a specific patch, and do you want to risk leaving you SA password in plain text in a batch file to run it?

[Koldov]

I'm no expert so I'll leave it if I'm wrong, but what is this for...?

 

[ajp233]

If you extract the .sql patch from the zip file you have been sent, you could perhaps schedule a commandline task to run with the following syntax:

 

sqlcmd -S server\instance -d <> -U sa -P <> -i <>

[coolhands]

hi ok thanks. Our IT guy has just come back and effectively said the same that can't (shouldn't) be scheduled for various reasons so we will have to do manually. Although Koldov above's import update thing is intriguing but maybe that to investigate another day..

[highsky]

Site specific patches? No external support for SIMS?

Or housekeeping ones?

The second can be scheduled, there is a guide from them.

[coolhands]

The site specific ones. So in this case it is a problem with System Manager - Unable to reset passwords of users; I found there is a KB0024182 which has 2 patches that need to be applied to fix this (suddenly occurred) problem. Our support is with Capita which just goes as far as sending me the patches to be applied. My internal IT dept don't install patches they leave for me to do; I'm a data manager not an IT / network support person! So in previous schools I've never had to do this type of thing.

[3s-gtech]

Import Update in SOLUS3 only lets you import SOLUS packages, not the SQL scripts that dbupgrade maintains. It's a right pain that one.