I've had an interesting query from a couple of schools now that I never really thought about until now. All these schools have recently become Academy's and now have a new FMS database. The query is that most of these sites used Equipment Register for Asset management (some over a number of years) and each ER is is packed with inventory, backdated stock take & inspection information (audit trails). These sites will be "winding down" with the use of the old school FMS system and focusing on the Academy database instead. Therefore, these schools want to know how the data can be moved from the old FMS DB to the new one as they will continue to use ER. Obviously manual entry not a great solution. It will mean hours and hours of manual entry and essentially losing any equipment history like stock takes and inspections. I've logged a call with Capita but am unsure if they can come up with anything.
Does anyone else have any ideas? Would it be possible to do some clever scripting to get the data out of the old system and import it into the new system with Management Studio?
Can't you clone the old db, and strip out the bits that aren't theirs any more. I take it it doesn't have the function to export / import inventory items. Otherwise you could just write things off / sell them and the 'new' academy buys them and adds them.
Could be a pain if they have to have a clean new db. You could pretty much do anything in studio, but it wont be supported, that's the issue. For support you'd have to pay Capita to do it!
Unfortunately not. You can import from a spreadsheet but only basic info (ER number, S/N, Security Mark, Quantity, Description & Model). Should be able to export the info from management Studio but all the other information like which room it's in, who's responsible for it, inspection & stock take history etc will be lost. They may be an Academy now but their equipment is not changing.
Well, Capita seem to have not thought about this. Luckily, we have managed to find a way to extract the inventory details out of the database (ER number, S/N, Security mark, Quantity, Description and Model). We can then save this data in a CSV file and then import it into the new database. Unfortunately, we have found no way to bring across categories, disposal definitions, the staff and room links along with the audit history. Still, it will save the school a good chunk of manual labour and they seem happy with this.