Many ways to do the same thing, eh? It's great we have so many excellent
tools and choices!
David
----- Original Message -----
From: "Neil Smith" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 13, 2002 10:03 AM
Subject: Re: Unload all/Reload/ Pack
> David
>
> If you're feeling adventurous - you can do a similar thing
> with Oterro!
>
> You can easily write row counts to a file - do a reload -
> use the counts to check the reloaded database then decide
> how to proceed based on the results. If there's a problem
> you can even email the administrator an alert.
>
> If you use R:Mail you can of course do it all this from
> within R:BASE - although, for us, having a VB/Oterro app to
> do reloads gives us the advantages of speed (especially if
> we run the reloader on the server) and ease of deployment -
> some of our client sysadmins are happier to have a specific
> utility running day in day out on their server than full
> R:BASE or RTIME.
>
> Cheers
>
> Neil
>
> Neil Smith
> Aspen Software
> www.aspensoftware.co.uk
>
> ----- Original Message -----
> From: "David M. Blocker" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, December 13, 2002 7:07 AM
> Subject: Re: Unload all/Reload/ Pack
>
>
> > Al
> >
> > That sounds like a VERY useful routine - would you be
> willing to share it?
> >
> > David Blocker
> >
> > ----- Original Message -----
> > From: "Albert Berry" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Thursday, December 12, 2002 3:27 PM
> > Subject: Re: Unload all/Reload/ Pack
> >
> >
> > At PSD we create a small database on the fly, unload the
> table names and row
> > counts from sys_tables (deliberately including the SYS_
> tables, because that
> > way we know if any indexes or constraints don't make it)
> from the before and
> > after databases and load them into the new database and
> compare the
> > rowcounts. We do this after every reload.
> >
> > I don't know who originally wrote the routines, they
> predate me, but they
> > are now in my permanent repertoire.
> >
> >
> > "J.M. GRATIAS" <[EMAIL PROTECTED]> wrote:
> >
> > >
> > >Randy :
> > >
> > >>>
> > >Do you have a slick way of doing this? Or do you output a
> > >list command to the printer, and physically compare the
> lists?
> > ><<
> > >
> > >This will count the total number of rows :
> > >
> > >-- Comptage nb total d'enreg. avant installation
> > >SELECT SUM(sys_num_rows) INTO vnbenr1 FROM sys_tables +
> > > WHERE Sys_Table_Type = 'TABLE' AND Sys_Table_Name NOT IN
> > >('aide','popup')
> > >
> > >I add a WHERE clause because in my case I need to exclude
> some tables from
> > >the count.
> > >
> > >Do that before and after UNLOAD/RELOAD and compare
> results....
> > >
> > >J.M. GRATIAS, Logimatique
> > >================================================
> > >TO SEE MESSAGE POSTING GUIDELINES:
> > >Send a plain text email to [EMAIL PROTECTED]
> > >In the message body, put just two words: INTRO rbase-l
> > >================================================
> > >TO UNSUBSCRIBE: send a plain text email to
> [EMAIL PROTECTED]
> > >In the message body, put just two words: UNSUBSCRIBE
> rbase-l
> > >================================================
> > >TO SEARCH ARCHIVES:
> > >http://www.mail-archive.com/rbase-l%40sonetmail.com/
> > >
> >
> >
> > --
> > Albert Berry
> > Full Time Consultant to
> > PSD Solutions
> > 350 West Hubbard, Suite 210
> > Chicago, IL 60610
> > 312-828-9253 Ext. 32
> >
> >
> >
> ____________________________________________________________
> ______
> > The NEW Netscape 7.0 browser is now available. Upgrade
> now!
> > http://channels.netscape.com/ns/browsers/download.jsp
> >
> > Get your own FREE, personal Netscape Mail account today at
> > http://webmail.netscape.com/
> > ================================================
> > TO SEE MESSAGE POSTING GUIDELINES:
> > Send a plain text email to [EMAIL PROTECTED]
> > In the message body, put just two words: INTRO rbase-l
> > ================================================
> > TO UNSUBSCRIBE: send a plain text email to
> [EMAIL PROTECTED]
> > In the message body, put just two words: UNSUBSCRIBE
> rbase-l
> > ================================================
> > TO SEARCH ARCHIVES:
> > http://www.mail-archive.com/rbase-l%40sonetmail.com/
> >
> >
> >
> > ================================================
> > TO SEE MESSAGE POSTING GUIDELINES:
> > Send a plain text email to [EMAIL PROTECTED]
> > In the message body, put just two words: INTRO rbase-l
> > ================================================
> > TO UNSUBSCRIBE: send a plain text email to
> [EMAIL PROTECTED]
> > In the message body, put just two words: UNSUBSCRIBE
> rbase-l
> > ================================================
> > TO SEARCH ARCHIVES:
> > http://www.mail-archive.com/rbase-l%40sonetmail.com/
> >
>
> ================================================
> TO SEE MESSAGE POSTING GUIDELINES:
> Send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: INTRO rbase-l
> ================================================
> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: UNSUBSCRIBE rbase-l
> ================================================
> TO SEARCH ARCHIVES:
> http://www.mail-archive.com/rbase-l%40sonetmail.com/
>
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
