3 ms·
More complicated scenarios occur when migrating millions/billions of records to a completely new data structure. 1. Create new structure 2. Add trigger to old
by buckbova 12y ago
More complicated scenarios occur when migrating millions/billions of records to a completely new data structure.
1. Create new structure
2. Add trigger to old tables for insert/update to new tables.
3. Create batch job that migrates records that aren't added by 2 above.
4. Ship.
When migration of data is completed.
1. Deploy new application code to all servers.
2. Remove old tables & triggers only after code is deployed and verified.