Hello,
I have a question that I did not foresee needing to be asked about 5 years ago, but now it has become a frustrating point.
I work for a large University and a very small department that now supports close to 60 databases and roughly 1000 queries. Each database large and small has a unique function and cannot be made it to one. Several reasons are management just do not want some users to see some data. Another is that we support a lot of departments across different distinct areas that are not related to each other. The data just is not compatible. For instance HR Data in one area and Work Orders in another area.
Because of the growth of the areas that we support and the databases we keep needing to build we have come to a management nightmare. The nightmare is that we are at the mercy of PeopleSoft and those yahoo's that support and manage it here. The admins like to change field names,or make incorrect data changes that affect many of our databases. Now that we are in mismanagement, we need to find a way to support the objects in the databases. If they change a field name we need to change the field name in multiple databases and multiple queries and multiple reports. It has become crazy.
On top if it all some departments that use the same data need it hashed a specific way, which is not always the same as another group. So now we have 5 databases with the same data but the criteria is different.
How do other people manage multiple databases?
Thanks
Jim Wagner
Tidak ada komentar:
Posting Komentar