spartacus
16th December 2002, 14:31
Is ist possible to create a seq. dump of a table, and import that data to another table with the same structure?
I would like to know that, because I would just change the table name during migration from triton to ERP.
Thanks
Spartacus
ulrich.fuchs
16th December 2002, 17:16
I think the table names are coded into the dump files, so you would have to somehow modify that dump.
But how about using exchange? If you have a simple table-to-table migration without any logic behind it (you couldn't do that with a dump, also), then Exchange should be very fast to set up - I think it would be easier than writing perl scripts or whatever to mess around with a dump file...
Francesco
16th December 2002, 19:38
Yep, exchange would definitely be the way to go on this one.
spartacus
16th December 2002, 21:36
OK, looks as though as would should use exchange!
Thanks
Spartacus
csekhar
17th December 2002, 00:12
Hello,
If you use bdbpre6.1 -N tablename -t "|" option then you should be able to use bdbpost6.1 to import into another table as long as the structure of the table is same.