Re: Bulk Table copy.

Dale E. Reed Jr. ( (no email) )
Tue, 14 Jul 1998 15:09:43 -0700

See this post in the archives:

Ian Pizey wrote:
> Does any one know how to copy the calls table within the emerald
> database to another
> table that can be used for archive purposes. That in turn can be used for
> user time look ups.
> The table would have a different name and contain the same structure and
> data as the current table. i asssume that once the table is created a
> nightly trigger can update this table and therefore have near on line time
> available for the users. I realize that the purpose of the consolidation
> process is to reduce the amount of data in the calls table. However the
> need for online time checking does save a needless administrative burden
> and provides the customers with better service.

Many sites are using this and it works well.

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |