On 2011/04/06 12:52 AM, Gary Gatten wrote:
Option 4.) Dump data from ACT to a "real" DB, then dump ACT completely? j/k - sorta... Does ACT support triggers and / or stored procedures? If so it would be relatively easy to keep a subset of the ACT DB in MySQL (or whatever) and keep it synchronized.
If ACT is ODBC, I'm sure one could install an ODBC driver and write a query in SQL ( or whatever ACT uses). At that point it wouldn't be any different than any other backend data store.
There is probably an option 5 - 10 as well. Is this a high volume environment? How many requests per sec / minute are we guestimating? I ask because if it's low you have many more options than if it's high.
Hi all, ACT is actually a CRM system. Unsure what database it uses, but I suspect it is Access Based (that horrible M$ thing) My suggestion would be to use a php script (called using rlm_exec) that can query the ACT database directly. Php can query weird and wonderful databases using odbc, and rlm_exec can call any php script. Cheers, -- Johan Meiring Cape PC Services CC Tel: (021) 883-8271 Fax: (021) 886-7782 ------------------------------------------------------- Before acting on this email or opening any attachments you should read Cape PC Service's email disclaimer at: http://www.pcservices.co.za/disclaimer.html -------------------------------------------------------