Merge Two School's Data - Different MIS
We may have to merge administratively with the school next door in the near future. MIS data will have to be merged as well.
School A is on SIMS and school B is on CMIS. The scenarios as far as I can see are:
School A keeps SIMS and school B moves over to SIMS, school B keeps CMIS and school A moves to CMIS or both schools keep their existing MIS and just carry on as they are (there won't be too much cross over in pupils between sites - it'll pretty much carry on as it is for the time being with pupils still going into the same building they've always used).
Assuming the first scenario, would the data from CMIS (school B) be able to be merged into a new SIMS database along with the existing SIMS data (from school A)? I assume historical data for analysis will be required so a new blank database from scratch will not be the preferred solution here (I know we could give access to the old database(s) but the ideal solution is to have all previous data available).
A name change may take place and the possibility that a new DfES number will be assigned means that a patch from Capita may be required.
Does anyone have any experience of this scenario and know the pitfalls we may encounter (apart from the obvious timetabling and admin ones)?