Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Move a dbc table
Message
From
05/10/2006 08:09:28
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
04/10/2006 17:21:48
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01159529
Message ID:
01159617
Views:
15
>Is it possible to move a table from DBC1 to DBC2 in a way that won't loose all the special formats and data that are contained in the DBC?
>
>Thanks for any help on this one.

Don,
It's doable in code. However since you need to do it for one time (right?) you can do like this:
-do home()+'tools\gendbc\gendbc' with 'fullpath of DBC1'
-It'd create a prg which is programmatic way of creating the whole DBC1 with its tables/indexes etc.
-Open the generated prg, locate the procedure that creates your table (something like MakeTable_myTable).
-Open your DBC2
-Run the procedure (but first edit filename to include the path where it should be created- ie: it says
create table myTable ...
Make that
create table ('c:\myPath\myTable') ...

append from ('fullpath to your table in DBC1')

-Drop the table from DBC1

PS: If it depends on any stored procedure in DBC1 do not forget to handle it.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform