Subject: | Re: Tools to help analyze/cleanup a paradox data directory?
| Date: | Tue, 8 Aug 2017 13:24:02 -0400
| From: | "Steven Green" <greens@diamondsg.com>
| Newsgroups: | comp.databases.paradox
|
don't know if my current ISP is communicating with c.d.p. in real time,
but..
the indexes always go to the table of the same name
to see which query is used by which report, you'd have to see the code..
it'll call some qbe file, then maybe do more manipulation of the table, then
call an rsl file
the only way to see if files were recently used, is if the app itself tracks
that (code written to do it, there is no default tool), or if a network tool
has been doing that.. if everything is simply "answer", it ain't easy :-)
without knowing how the app was written, and how the coder typically did
stuff, there are no standard rules
--
Steven Green
Myrtle Beach, South Carolina, USA
http://www.OasisTradingPost.com
Collectibles and Memorabilia
Vintage Lego Sets and Parts
- and Paradox support, too
wrote in message
news:b54f6f5f-44ed-4a77-88c7-6f6aca86328a@googlegroups.com...
Where I work, we have "The T:\ Drive". This shared directory contains the
sum total of the Paradox data files generated by about 50-70 concurrent
employees in half a dozen departments over the course of more than 20 years.
And it's a mess. It's about 1700 files. A good chunk of it was created by
employees long since retired.
My task is to go through it, clean it up, and identify distinct
"applications" within this directory.
So far I've been using Paradox itself, filesystem tools, binary dumps, and
other rudimentary tools to try to identify what's being used and what isn't.
But I'm wondering if there are third party tools to help out here.
Some specific questions:
- I know generally that index files share the same base name as the table
they belong too. So "foo.YG1" belongs to "foo.db". But is this always the
case? Is it possible, through renaming or other processes, that "baz.XG0"
belongs to "foo.db", and -- if so -- how do I identify that connection? Or
can I safely assume that "baz.XG0" belongs to a deleted table?
- Most of our reports pull data from a generic "ANSWERS.DB" table, which
might be generated by any of a hundred QBEs (IOW, most of our QBEs output to
"ANSWERS.DB"). I can't see a way of identifying which QBE belongs to which
report other than painstakingly comparing the output fields to the expected
input fields and making an educated guess. Am I missing a tool that would
help here?
- Is there any way to see when a QBE or table was last used (e.g. run/read,
as opposed to modified)?
Thanks for any help you can offer!
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
|