Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Utility to test sync of DBC
Message
De
19/12/2005 20:06:50
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
19/12/2005 17:08:40
Neil Mc Donald
Cencom Systems P/L
The Sun, Australie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00945594
Message ID:
01079387
Vues:
29
>Hi,
>The utility compares the source DBC to the target, prints out the differences and then makes all the required mods to the target DBC.

OK. Well, I am not personally interested in this utility. I have my own, that works as follows:

I do all changes to the database in an empty copy of the database.

Then, I do an APPEND FROM for each table, from the production data (or, at first, my test data) with the old structure, into the empty database, which has the new structure.

I will not publish this, since it relies on some framework-specific functions.

It does not show a difference in structures; come to think of it, that might be a good idea (as a separate utility, perhaps).
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform