I developed a CF application using MS Access as backend database. Now, our DBAs build the database in DB2 so we could migrate from Access to DB2. The DB2 database for now, only contains the tables. The DBA told me that I am supposed to be the one to populate the tables by using coldfusion.
Let say I have 3 tables in MS Access that currently have records of 60, 300, 600. I want to move all of these records at the same time to the tables in DB2, Should I do a select first and then do an insert? Please guide me. I already have the datasource in DB2.