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. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com