blog




  • Essay / The Evolution of Data and Database Migration - 1219

    The Evolution of Data and Database MigrationLarge-scale projects such as multiple site mergers, green IT initiatives, Virtualization projects, database server consolidation, and technology refresh cycle are common in the database world. A common theme across all of these is data migration. From a database management perspective, data migration has traditionally been treated as an exception to normal operations. Data migration also appears to coincide with unforeseen challenges that result in extended downtime and the need to cancel, cancel, and defer activity. In larger environments, data migration is no longer an intermittent distraction but a regular activity that consumes a growing number of organizations. hours. As with seemingly everything infrastructure related, there are many technology options to choose from. Choosing the right approach is highly dependent on infrastructure limitations, data types and platforms, as well as time constraints and staff capabilities. Using scripts is no longer best practice, although there is plenty of commercially available software that can make this task easier. Using the custom script approach to migrate data into today's data-centric applications leaves a fatal flaw, according to Rob Karel, principal analyst at Forrester Research Inc., based in Cambridge, Mass. (Smalltree) "A custom script won't do anything about unnecessary data, it will just move it around," Karel explained. (Little tree)