Hi Brian,
You've answered your own question. Yes, you must use the database dump/load
utilities. No pitfalls that I know of, other than the time. Expect it to be
significantly slower than backup/restore. My guess is that, for your size
database, you are looking at 24-36 hours.
Trevor
|