i need to perform consolidation and standardization of the databases in several dislocated offices as part of development of new system. Currently, at each site certain database software, hardware and IT human resources exist and the I want to make a inventory of current state, analyze level of knowledge of IT employees, analyze current hardware used for the database software, etc. Basically i want to draw a bottom line of current system to make the most of it ( if there is anything to make) in order to implement new system which will consolidate and optimize the use of all types of resources..
I need guidelines in what is the best way to extract the information from the IT staff ( questionnaire +interview) , end users opinion on the current system , pros and cons of consolidation i.e. keep everything in one place or on every location, etc?
I would be grateful if you provide me with some examples, best practices, to do lists, etc.