CFCDataMapper is a tool that will allow you to map data from one database to another database with out writing any SQL.

You can map columns from one table to another within the same database or into another database, you can also run custom ColdFusion code before the datamapper select the data from the source or can run custom ColdFusion code after the data has been inserted into the target you can even have custom ColdFusion code run per column for example if you’re using uuid as a primary key you can generate that key and have that insert into the target.