You can use a change management script to copy
data from one table to another. The tables can be in the same database
or different databases.
Overview of migrating data
Migrating data can be useful when you normalize
tables and need to move data from one table to another or when you
want to copy data between environments. For example, you might want
the data in the test environment to closely resemble the data in the
production environment.