As you know, Emerald deletes all information in the Calls table when
running consolidation. This means that if there is a later dispute
regarding usage by the client then the details of all calls is lost.
Presumably everyone has found their own way of overcoming this major
shortcoming and I would like to hear what people have done.
I am not an SQL expert and nor did I think I would need to become one after
purchasing Emerald <sigh>.
I have in mind creating a new database each month called "nov_1998" or
something similar and then using the Transfer Management Interface to copy
the data into there from Emerald for future reference/use. The book i have
seems to use the word "move" and "copy" as if they meant one and the same
thing!!!! If I do take this course of action, will I delete the data
information in Emerald?
Thanks in advance.
Glen.
--------------------------------------------------------------------
AQUARIUS Communications for all your Internet<>Fidonet needs
<>Full ISP services<>FrontDoor Commercial<>TransX Internet/FTSC Mailer
voice(02)9977-3788<>fax(02)9977-3844<>bbs(02)9977-2855<>3:714/930
http://www.aquarius.com.au <> mailto:sales@aquarius.com.au