Re: Ran out of licenses; need to wipe out old MBRs

Dale E. Reed Jr. ( (no email) )
Fri, 24 Jul 1998 20:19:04 -0700

Rudy Komsic wrote:
> >Yes, it does. Emerald's database is relational. Therfore, you can't
> >delete a parent (the MBR) without deleting the related records (you
> >can't orphan child records, the SQL Server won't allow it). We are
> >working on ways to resolve this where it will keep the accounting
> >data but remove the customer information.
> Would it not be easier to have it create a separate database called Oldrecords
> and have the information dumped there and remove from the active year
> information?

Not really. You have to think about reporting issues. You need the
data toegther for the reporting aspects.

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