Albert
I like David would like to get a bit more of a hint of how
this is done. I am way behind all of you in that we don't
have any automated system to do utility work on our dbs.
I do it when I find gaps in my schedule.. so .. in reality
it ususaly gets done when there is a problem.. ha,ha like
that's really funny.
Jim Limburg
--- Albert Berry <[EMAIL PROTECTED]> wrote:
> 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/
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.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/
