matt40k

Give support a call - often they'll be able to tell you, just thinking about Redstor (third party backup tool), if they use it - also thinks to check that often get overlooked, like b2b, groupcall xporter etc

SQL Compact has some SQL migration thing in it that Capita uses to perform SOLUS3 db deployments (new and upgrades). They could move over to using the full DAC now Microsoft have started releasing it as a separate installer, but if it works

I doubt we'll see many individual schools being sued over breaking the procurement law. Doesn't mean people won't be fired over it however! In the grand scheme of things, even £20k isn't that much when you compare it to agency cover staff costs, which has a much larger cost both in terms of actual finance and in student performance Be interesting to see what replaces the current MIS framework (RM1500) - Information Management and Learning Services | Crown Commercial Service - I hope they replace\renew it with something because it was basically a pick list of "safe" suppliers. Hopefully you folks know more. Anyway, good luck all you non-Capita MIS suppliers I hope you prove me wrong now the LA "blocker" is gone (well going)

Nope, every maintained school is going to throw a ton of relicensing money directly at Capita. No LA involvement. LA can't transfer the license, Capita won't allow it - ignore that other folks do (points at Microsoft). They won't be looking at changing tools because they'll be too busy worrying about a million other things that they have to worry about as an Academy - really they should look at the market, but really, there are only so many hours in the day! School will be now rushing to convert early because that pot of money to help convert is going to dry up pretty quick. In short, buy Capita shares. And the cynic in my says by 2020, it'll be going the other way and Academies will be coming back up LA... well (combined) LAs From what I've heard, they're doing some features that will work in SIMS 7, it just won't be as feature rich.

Late to game but https://www.mythic-beasts.com/ - they do invoicing too.

Looks like @linkazoid has already found a bug - http://www.edugeek.net/forums/mis-systems/167439-spring-2016-full-release-2.html#post1437654

This makes me sad. Quite like linux, don't get me wrong, its not the answer to everything like some folks will tell you, but I just like to have it on the table of options. Lets face it, your rather have a ubuntu 512mb vps running wordpress over windows server 16gb vps running SharePoint for a simple website.

What about IPv6? Ditch the IPv4 tax

Sorry but, and? Even if you do go "cloud" and then they charge, say 2 or 3 years down the line, sorry you have to pay, even if its mega dosh, and? Seriously we are IT, we change everything every 3-5 years! Enjoy the years of freebies, if you had an on prem mail server, you dont just skip it (unless its mega old) repurpose it. Server are deappreciating assets, its not like your selling your playing field.

Far as I am aware, you'll need to create a clone of the server or such. WordPress MU is a single copy of the core (both database and files) so its very much all or nothing. Bit disappointing they didnt setup a dev/uat/prod environment

If its anything like survey monkey you can't store sensitive data on the service. Looking quickly at the QA's, they have a opt-in for health (data) - but it doesn't cover docs, only mail, calendar and drive (which I guess has client-side encryption?) and calendar and mail shouldn't contain sensitive data.

Ah Richard @ SalamanderSoft already submitted a fix for that. I'll PM you over a newer version with the fix. I've still not finished the next release due to lack of time.

Can you send over the log file?

Indeed, it'll be interesting to see what happens next month when RM1500 expires. It has the potential to utilise your work and fill in some gaps with framework.

Disappointing still missing some responses from certain MIS suppliers. Least Capita had the balls to point blank refuse rather then sticking head in the sand until you went away.

Yup. Sounds like @ninjafish etc are getting a bit muddled up. It use to be 3 installers - server (s3 deployment service), client (s3 agent - which is actually a s3 service also) and a UI. Every device that has SIMS has the agent\client. You have only 1 server\service and you install the UI on the server and any techy machines (saves you rdp'ing to server). Capita were speaking about having 1 installer which might confuse the whole deployment service \ ui being separate parts - especially when you couldn't deploy s3 ui (ironically) via s3

Are you going from LA to Academy status as well? I don't believe you normally carry that much across, you might take over a clean version of your suppliers. All historic data is in the old database.

You checked if the router has auto updated recently? Long shot, but you never know

No, not change tracking or cdc - that is used for loading data into warehouses etc. sql auditing. As in who has selected from table, etc Sql auditing IS the standard - it meets financial, pci, health, military requirements.

Still don't agree with you Tony. SQL Audit function IS the answer. Again, using your point at being user driven requirements, they dont want to know tables, they also dont want to know what button they pressed. They want to know what records they (user) looked at and when. The only ui change would be protected records - so parent who works at the school shouldn't be able to see the details of their child. Also staff who were previously students.

Well for starters Geoff script only trigger on insert, update, delete, not select. So... yer. @localzuk I think you under estimate how much work that would be. Enabling DB auditing is a few hours work - creating reports is harder, but could achieve something basic a few days. So its like 1 months work vs 9 months hard work. @elsiegee40 - @PhilNeal (well SIMS) falls into the "legacy" category, so they are not legally required to do anything, they'll have a horrid time when they finally release the new SIMS product as they'll find they have to comply. I know we're having some fun with it on our BI platform because effectively anyone could rock up and go hey, what data do you hold on me (data dump - easy) and who's looked at my data and when (not so easy). They might even get slap with the requirement now, depending if the government could define what is "new" is (so is new a major change, so 7.0 to 8.0, or can it be a minor change, like a new feature so 7.0 to 7.1) You are right however, they should be looking at it as a sales gimmick - hey, come use our Azure hosted solution, look at our fancy all-inclusive auditing (only on azure)

@Geoff I should shot you for suggesting adding a trigger on every table. That is a guarantee way to bork your system. Triggers are expensive and should not be used unless absolutely necessary. If you really want to enable auditing, then you need to use the built in audit, it writes to a flat file (you use tsql to read it). It has very little performance impact and can be limited by size etc Its worth noting this wont catch everything. SIMS caches alot of data, so lot will be junk, also means bits will be missed. Also if you have any extracts - both self designed reports or third party products - like groupcall So, how you gonna combine all these logs? If your gonna write these off if shouldnt be too hard for Capita to write a gui for enabling it and a few reports - the gotta might be if express edition doesnt allow auditing

@DPenfold, yes can be done, like @Skelacia and @Linfit have said - its detailed in the documentation > log in to sims, then click documentation. Bit concerned "they" claim it cant be done. Just to repeat myself, SIMS SQL logins is insecure, it may add a false layer of "security" but it adds a massive security hole. Windows security is far more secure. You should be teaching staff win key + L. It isn't difficult and far, far more secure then saying log out of SIMS

To be honest, I would always recommend wiping and installing a clean copy of Windows. Toshiba builds are pretty clean, I've got a R50-B-12Q at home, still wiped it and started again. Sorry if this sounds pretty blunt, but I wouldn't bother spending time trying to fixing it (unless I'm getting paid by the hr) until its a fresh Windows install, joined to the domain, all the updates applied and connected correctly to the network - so same subnet, server can ping client dns name and the client and ping the server dns server. Remember SOLUS3 is two-way communication. Could have some random 3rd party antivirus that has a "firewall" option or it could be something else using the port. Ideally you would want only have 1 dns entry for laptop, so if the laptop is wired in, the wifi gets disabled.

Pretty sure you can, but I would look at Windows Authentication. Far more secure.