Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Copying tables from one database to another
Message
De
19/07/2001 19:29:20
 
 
À
16/07/2001 12:29:21
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00531041
Message ID:
00532915
Vues:
12
>Hi Terry,
>
>You can use SDT the same way you would use the Class Browser. Open up two instances of the Stonefield Database Explorer with your old and new databases. Then just drag the table that you want in the new database from the old one. It will put a copy in the new database.
>
>Pamela
This solution worked prefectly, but it could use some follow on instruction. That way if anyone does a search on the problem later the instructions will be complete.

Open up SDT in the original project containing the 'Source' database.

Then and this is important. In the command window, close the database but leave the SDT window open. Size it to a convient size for copying.

Now open SDT again and this time travel to the 'Destination' database.

You may now drag tables from one instance to another.

When I first tried to do this I opened two complete VFP Windows. Mistake! Then I couldn't get two instances of SDT open in one VFP window. Finally, I discovered the Close Database XXXXXX and reopen SDT solution. This sounds obvious in retrospect but it did give me pause.

If you have any corrections, don't hesitate. I'm not proud.

Thanks again

Terry
It is impossible to make programs idiot proof. Idiots are too cleaver.

MCP( Tcp/Ip )
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform