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

Rudy Komsic ( (no email) )
Fri, 24 Jul 1998 21:07:48 -0400

>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