Is there a way to backup the 7.0 database and load it into 6.5? My concern
is that I upgrade to 7.0 and then several weeks later something goes wrong
and we have to go back to 6.5. I can't afford to lose several weeks of
> -----Original Message-----
> From: firstname.lastname@example.org
> [mailto:email@example.com]On Behalf Of Ronnie D. Franklin
> Sent: Sunday, November 07, 1999 12:55 PM
> To: firstname.lastname@example.org
> Subject: RE: [Emerald] VSA and USR's
> The older 2.5 database did not allow for nulls in the expiredate, which
> causes problems when placing an account inactive. We have to
> manually put a
> date in before we can save the record. I have upgraded to SQL 7.0. Will
> 7.0 allow me to change that column without any other affects on
> the system?
> For anyone that has not upgraded to SQL 7.0........
> The entire process of upgrading took about 3 hours. Most of the time was
> spent preparing for a disaster, which did not happen, but I felt a lot
> better having multiple backups, and etc. While the server was
> down, I also
> upgraded from 256mb to 512mb of memory and installed a Intel
> PRO/100 Server
> adapter. I am sure the 512mb of ram helps and I know the Server adapter
> works better as my remote tape back has a better throughput.
> The end results is that a consolidation of 670,000 records went
> from taking
> 20+ hours to taking a little over 2 hours. And such things as
> Update Calls
> now takes no more than 1-2 minutes instead of 1-2 hours.
> So the short of it is, if you have not upgraded to 7.0 then you
> should do it
> > -----Original Message-----
> > From: email@example.com
> > [mailto:firstname.lastname@example.org]On Behalf Of Dale E. Reed Jr.
> > Sent: Sunday, November 07, 1999 11:40 AM
> > To: email@example.com
> > Subject: Re: [Emerald] VSA and USR's
> > Ken Sorenson wrote:
> > >
> > > Thanks for the attributes.. However, now I have the primary key
> > issue with
> > > the radattributes table. I know I have seen your response
> > before, but it is
> > > not in my archives. How do I modify the table to accept the inserts.
> > The Primary Key for the RadAttributes table should be the
> > RadAttributeID,
> > RadVendorID, and RadVendorType attributes. The update script recreates
> > the table with these keys. You can NOT just add the columns and change
> > the primary key.
> > --
> > Dale E. Reed Jr. Emerald and RadiusNT
> > __________________________________________
> > IEA Software, Inc. www.iea-software.com
> > For more information about this list (including removal) go to:
> > http://www.iea-software.com/support/maillists/liststart
> For more information about this list (including removal) go to:
For more information about this list (including removal) go to: