Need advice on making universal database solution
Posted: Thu May 26, 2005 4:44 pm
Here is my situation:
I work in a call center where sales data is tracked for two different teams on two different servers, each with their own database and front end. My agent activity reports are limited to the data for each individual server. Management would like a universal report. The database and front in are both in Access. One caveat is the information is mapped to same drive letter & file names but on two different servers. I don't want to combine the data into one database becuase that amount of data would take too much space. Can this be done in PHP to where the results would not take the literally 20 mintues for access to run a query? I do not know PHP but am willing to learn if I can accomplish this task. Is this something I can construct in a month or two, or is this advanced task? I think a web-based solution would be a great way to make sure everyone has a user-friendly interface and easy access to our information. Let me know what you think, or if there is a better solution.
Thanks,
Thomas
I work in a call center where sales data is tracked for two different teams on two different servers, each with their own database and front end. My agent activity reports are limited to the data for each individual server. Management would like a universal report. The database and front in are both in Access. One caveat is the information is mapped to same drive letter & file names but on two different servers. I don't want to combine the data into one database becuase that amount of data would take too much space. Can this be done in PHP to where the results would not take the literally 20 mintues for access to run a query? I do not know PHP but am willing to learn if I can accomplish this task. Is this something I can construct in a month or two, or is this advanced task? I think a web-based solution would be a great way to make sure everyone has a user-friendly interface and easy access to our information. Let me know what you think, or if there is a better solution.
Thanks,
Thomas