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/
