Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Moving Tables Between Databases
Message
From
26/02/2004 12:22:49
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00880647
Message ID:
00881147
Views:
27
>>Is there a way to move data tables from one DBC to another, aleady-exisiting database without first freeing it (which I assume will lose all DBC-specific stuff like captions and long field names)? Long ago, I dumbly put one of application's tables into three different databases (each in a different folder) and would like to consolidate them. I've no problem hacking the database files if needed, but am not sure of everything I should look out for.
>
>>> If one of your existing tables is the right one, why not just append from >> the other two and then drop these two?
>
>Sorry, what I should have said is that I dispersed the application's tables into three different databases, not that I had duplicated any one table in more than one DBC. Other respondents reminded me of the DATABASE parameter in VFP's COPY TO command, which was what I needed. Thanks!

You may still be better off running gendbc for all the databases, then consolidating that into one big prg which will create a fourth database, then appending the data from the old ones. The reason I'd rather do it this way is that the copy to... database doesn't carry over all the extended properties - not even the defaults. Haven't tried that recently, but I remember it had shortcomings. GenDbc will give you ALL the extended properties, and it would save you a lot of time if you had a lot of them.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform