Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Copying view or table structure from test dbc to live db
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00413746
Message ID:
00413768
Vues:
14
>I'm hoping I'm missing the boat on a much easier way to accomplish this task, and hope someone here can point me to an easier way to accomplish the following.
>
>Currently, if I need to "copy" the structure of a view or table from my test dbc to my live dbc, I have to open the development view, list view to a text file, open the text file (for reference), then open the live dbc, and using the information in the text file I generated, manually re-create that view or table in the corresponding designer. I know I could use the information in the text file to build a create view or create table statement, but that takes nearly as long to do as opening the designers to do the job.

You can use GENDBC utility to create a program which programmatically recreates your database and then just copy and run the part which recreates the view. There are also some utilities in Files section which can help you with the view code.

>I know with a table, I could simply do a copy struc to a free table, but if I do this, the table is constrained to the limitations of field name sizes, file name length, etc.... that dbc's do not have.
>

For the table just use

COPY TO FileName DATABASE myLiveDBC WITH CDX
(you can provide the full path to your DBC)
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform