DATA MIGRATION
In your experience, when doing data migration from one table to another, whats the best way? i can write a sql script but considering the data can be in milions, i also think i may need some kind of retry policy
1 Reply
there isn't a one-size-fits-all solution, it depends on a bunch of conditions, how big the total data size is (MBs, GBs), can you lock the tables (or stop the services), does table have a pk column, are there fks or triggers, how important is the data, are the types all the same, is the table in the same schema, and so on
for example you could consider exporting records to a sql to a file and then executing it on the new table