[Emerald] SQL Database Transfers

Glen Harvy ( glen@aquarius.com.au )
Mon, 16 Nov 1998 12:49:36 +1100


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.

AQUARIUS Communications for all your Internet<>Fidonet needs
<>Full ISP services<>FrontDoor Commercial<>TransX Internet/FTSC Mailer
http://www.aquarius.com.au <> mailto:sales@aquarius.com.au