Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Rename a Database SDT 6.2a
Message
De
21/04/2005 09:22:04
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Stonefield
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01006710
Message ID:
01006955
Vues:
19
Thanks for the ideas Mark!

>>Update: Found it in the helpfile. Am following the steps now. (Note: this app is not deployed yet - all is still in development only mode)
>>
>>
>>We are in the process of modifying our app for a new version and have decided to rename our databases. We don't want to create a new database (unless we have to) and add the tables to it because we don't want to lose the settings.
>>
>>Is there an easy way to do it using Stonefield Database Toolkit? We are using 6.2a
>
>When I need to change the name of the DBC, I will run the VFP utility GENDBC which creates a PRG file that has all the code in it to completely recreate the database including all tables, views, indexes, RI, etc., except for the data. I then modify this PRG to change the name of the DBC to whatever I want. I run the PRG in a clean (new) folder where everything is created. At that point, I can write a little bit of code to APPEND the data from the original tables into the new ones. Then bring up SDT to have it create the meta data for this new database.
.·*´¨)
.·`TCH
(..·*

010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform