|
This is R:base you are talking about. You can have several people updating the
same tables at the same times. #1 is not a big deal unless you have
column names in the different tables in the different dbs that have the same
name and different data types. In which case you either need to modify the
tables and change the column names or change the data types to match. I assume you also want to move over any
forms and reports which are stored in the sys_forms, sys_forms2, and sys_forms3
tables depending on which version of R:base you have. To move a table from one db to the other,
do the following. -- put mytable schema in mytable.sch and
data in mytable.dat R> Connect DBtoDelete R>out mytable.sch R>unload schema for mytable R>out mytable.dat R>unload data for mytable R>out screen -- load the new table into the second db R>Connect DBtoKeep R>set mes on R>set err mes on R>run mytable.sch If you don’t get any errors, you are good
to go, otherwise you will need to fix the errors. R>run mytalbe.dat This will copy mytable from DBtoDelete to
DBtoKeep You will need to do the same things with
the sys_forms and sys_reports tables to move forms and reports. Troy From: 1. I currently have two databases with
several independent tables in each. I would like to bring all the tables into
one data base and wondered how to do this. 2. If I have a database and several tables
within the DB is there a way for two people to work on differend tables
updating info and then bring them together so the tables would contain all the
updates from the two people working on them. I'm not a pro at RBase but am learning so
any help would be appreciated --- |
