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
transactions.
Thanks
> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Ronnie D. Franklin
> Sent: Sunday, November 07, 1999 12:55 PM
> To: emerald@iea-software.com
> 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
> ASAP!!
>
> Ronnie@itexas.net
>
>
> > -----Original Message-----
> > From: emerald-request@iea-software.com
> > [mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.
> > Sent: Sunday, November 07, 1999 11:40 AM
> > To: emerald@iea-software.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:
> http://www.iea-software.com/support/maillists/liststart
>
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart