Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Backup an Online VFP Database
Message
De
26/01/2012 02:21:35
 
 
À
25/01/2012 17:12:30
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2003
Divers
Thread ID:
01533653
Message ID:
01533780
Vues:
52
Thanks for looking, but on first glance that looks like a product that converts (and/or syncs) from VFP to other databases. I'm really just looking for a straight backup solution.

>Just Googling - does this help: http://dbconvert.com/convert-foxpro-to-mssql-sync.php
>
>
>
>>I'd like to be able to back up a VFP database ( i.e. DBC and associated tables ) even if one or more users are actively working with it. Preferably using VFP code, but I'm open to other techniques ( e.g. LLFF ) if necessary. I'd like to avoid 3rd-party applications if possible.
>>
>>The database nor its tables are not currently used EXCLUSIVEly by anyone, so SHARED access should always be available. However, momentary locks will occur during backups and will need to be avoided or handled as necessary.
>>
>>With free tables, it looks like COPY TO or SELECT should easily do the job. But, a DBC and its tables looks more difficult. My first thought:
>>
>>- open the DBC SHARED, as a table
>>- use COPY TO ( WITH PRODUCTION ) to create a copy in another folder
>>
>>I see Cetin has FAQ#7694 with some code that supposedly addresses this in a different way, I haven't looked at that yet.
>>
>>But, now it looks like a chicken-and-egg situation:
>>
>>- if I open the new DBC and its member tables are not present, does VFP check for that and cause an error?
>>- if I open up member tables in the source, and COPY TO ( target ) DATABASE BackupDBC, does that create another reference in the DBC to a new member table, even though the reference is already there in the copied DBC file?
>>
>>It seems to be an issue of somehow handling the backlinks.
>>
>>Anyone have any experience with this?
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform