There is AT LEAST one glaring flaw with eastsideangus' method: all your product and customer and order numbers in the new store will start at the number where the old store left off, and NOT at 1.

REMEMBER: USE AT OWN RISK