K
Keith Sudbury
Guest
George is correct about the index you choose for the dump impacting the speed of the dump. Take care that it doesn't cause performance issues when the data is loaded though. As for using -RO for dump.. I have found some cases where that did indeed work better than with the server running. It seems to be directly related to how heavily (or not) your tables are intermixed with each other (Type I). Both are valid approaches to try on your specific databases. Bravepoint does have the PRO D&L product www.bravepoint.com/products-pro-dump-and-load.shtml but there is obviously a cost involved (and most likely some replication triggers added like the PRO2 series). It may or may not make sense if you are just trying to convert a few customers from Type I to Type II.
Continue reading...
Continue reading...