Re: how to copy live paradox tables


Robert,
You idea sounds like a good safeguard and far better than just copying all
files and hoping noone is using the application because of the late hour.

I have one question however.


You can find out if anyone is using a copy by searching for files like
*.lck.

If there are none, you know no-one is using the database using the Borland

Database Engine.

If there are any *.lck files, and you can delete them, they have been left

over through the BDE being abended.

How do I know the difference between a .lck file 'left over through the BDE
being abended' and an actual user lock? I'm not sure what you mean by 'BDE
being abended'. Can you clarify?

Thank you.

John






1. Check for *.lck files. Handle any occurences.

2. Rename the database directory

3. Copy it.

4. Rename back to original.

BUT:

You have not said what you are trying to achieve by this.

Why make copies of the database? Can't you use the production version?

If all you want is a few tables, you might be able to snapshot them safely

during operation.

One of the joys of Paradox is that you can safely work on individual tables.

So for example, if the production database contains hundreds of tables,
but
you only need one or two, you can copy them either with Paradox or the OS,

work on them, and put them back, without requiring the production database

to be shut down.

You can use the date and time stamp on the table component files to see

whether it is in use or not, or has been changed since the last copy.

"john ligda" <jligda@xxxxxxxxxxxxx> wrote in message
news:44f62acf$1@xxxxxxxxxxxxxxxxxxxxxxxxxxx

Hello, I am very new to paradox databases but have some familiarity with
Oracle and MS SQL rdbms concepts. I would like to learn how to safely

copy
paradox data files while the database is operatonal. Is this possible?
Im used to some sort of admin tool which hides the complexity involved
in
preserving a valid database state. I have no idea if such a tool exists
for paradox databases. To add to the confusion, I will not be allowed
to
touch the production tables myself. I will instead, be prviding a safe

solution
to the administrator so that he can provide me with consistant refreshes
of the production tables. We want to do this nightly.

Our first attempt was to simply copy the data directory with Windows OS

commands.
He delivered a directory of .DB, .TV, .PX files. I was able to extract
data from the .DB tables but have no idea if the data transaction
integrity
is preserved. In fact, on one table there is a violation of the primary
key on the very last record. I suspect the copy is corrupt because of
the
way it was copied. But honestly i have no idea. Can anyone direct me
to
a resource where I can read about basic administration for paradox
databases?
Specifically how to safely copy/mirror/replicate source systems without
affecting daily operations of end users.



.

Relevant Pages

  • how do i query Multiple Databases in access?
    ... I need to create an access database that would query Multiple Paradox ... the Paradox Databases all have the same fields. ... the purpose of the access database to check all the Paradox Databases for ...
    (microsoft.public.access.queries)
  • Oracle DBA, Denver, Branta Group Contract
    ... Oracle DBA, Denver, Branta Group Contract ... sites focusing on database performance and availability. ... first and second tier resolution of production issues. ... procedures supporting a mission critical 24x7 production environment ...
    (comp.databases.oracle.marketplace)
  • Oracle DBA, San Jose, Branta Group Contract
    ... Oracle DBA, San Jose, Branta Group Contract ... sites focusing on database performance and availability. ... first and second tier resolution of production issues. ... procedures supporting a mission critical 24x7 production environment ...
    (comp.databases.oracle.marketplace)
  • Looking for a few good beta testers
    ... development off-line and install it in the production environment after ... If so, you need ZZ DoesIt!! ... DefaultValue, Required, AllowZeroLength) will be flagged as Install: ... Tables in the From database which don't exist in the To database ...
    (microsoft.public.access.modulesdaovba)
  • Re: Estimating effectivity of performance improvement measures
    ... I actually think this is a bad idea unless you plan to do the same ... thing on production. ... database, as I have tried to explain. ... differences such as physical I/O access time and account for that. ...
    (comp.databases.oracle.server)