M
mfurgal
Guest
The mention of Table Partitioning allows you to do a table-move, which essentially is a dump and load without any impact to the application. Very cool stuff. But you mention you are doing a platform migration. If you cannot deal with the downtime, check out this presentation I did last year at the PUG challenge: 410: Case Study: Platform and Data Migration with Little Downtime Basically, we leveraged the Pro2SQL product technology to do the platform migration. At the end of the day the downtime was 20 minutes to do the migration. This downtime would be irregardless of the database size as Pro2 replication is keeping the new database up to date with changes. You could do this yourself with the CDC product introduced in 11.7 as well. Mike -- Mike Furgal Director – Database and Pro2 Services PROGRESS Bravepoint 617-803-2870 mfurgal@progress.com
Continue reading...
Continue reading...