I have a need to make a copy of our DEV database to a sandbox environment. The hostnames are different, and from what I understand the names must match. Can anyone provide advice on the best way to copy a DEV cluster to a sandbox environment?
Check out "Replicating Tables and Schemas to an Alternate Database":
Or "Importing and Exporting Data Across Databases":