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/
