Best strategy for data migration from one Teradata DB to Another Teradata DB(Different Data Model)

Database

Best strategy for data migration from one Teradata DB to Another Teradata DB(Different Data Model)

Hi All,

What is the best way to migrate a warehouse from one Teradata data data base (2NF) to new DB teradata DB(3NF) with same PIs.

1) Bteq Scripts(to prepare data in new format) along with MLOAD(to load for 3-4 baselines,or FASTLOAD to load in one go)

2) GCFR Patterns

3) Insert/Select

 

Which of these three will be most effective method.

  • Data Migration
  • Different Data Model
1 REPLY
Teradata Employee

Re: Best strategy for data migration from one Teradata DB to Another Teradata DB(Different Data Mode

Nothing is faster than insert-select (or merge) into an empty table.  That would also be the easiest way if they are on the same system.  Otherwise I would try to copy the data as-is to the second system and then use merge to create the new tables.  The method for copying the data might be DSA backup-restore, or Fast Export and then Fast Load.  I think any other approach would require more coding and would not save any time.