Merging Two Roundtable Databases

Chris Kelleher

Administrator
Staff member
Greetings and salutations,
Thank you all for help with my last problem.
Now I have another. I need to merge 2 Roundtable databases. The 2 databases are currently on different Hp/UX boxes. The WS's are exclusive and should be able to be merged with out any duplicate program names or table names.
Are there any utilities / programs that I can use to copy the WS's from one RTB database to a different one ?
If not, how about a list of RTB tables that I could buffer copy ?
______________________________________________________
Steve G Brown
Database Manager
DANA Brake & Chassis
[HP/UX 10.20/11.0][RTB 8.3B][Prog 8.3A]
 

Chris Kelleher

Administrator
Staff member
Steve,

Have you thought about dumping all of the data out? Roundtable has a set of
dump/load utilities in the rtb_util directory. That would dump product
codes, sub types, workspacess and all. You might have to be leary of the
sub-types but everything else could be exclusive. Back up the db before
attempting.

Good Luck.

Nathan Noll (817) 284-8680
NCS Fax (800) 538-7510
Certified Roundtable Consultants nathan@nollc.com

Check out F1 an integrated Change Request System that works
with Roundtable! www.nollc.com/f1
 
Top