Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>Hi
>>
>>I need to create an empty copy of my database and tables from one location to another.
>>
>>The problem I've got is that I need to create an empty database, and then place each table from the source into the destination, but with no records (COPY STRUCTURE), but the only problem is, how can I create an empty database programmatically with no user interaction? And then place the tables into that new database.
>>
>>I don't think you can, any suggestions?
>>
>>Thanks
>>Kev
>
>All afresh ? Thanks to VFP tools :)
>Run home()+'tools\gendbc\gendbc' and point your dbc. It'd generate a .prg and if there are stored procs a .krt file.
>Copy these files and set your default directory to new dbc folder and run the prg.
>(Alternattively you could edit the prg to create dbc and tables in folder you specify)
>Cetin
Thanks Cetin, I can't believe I forgot about good ol' gendbc!
Cheers
Kev
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement