Thanks for the tip Cameron, I will definitely research SELECT INTO as suggested, all I was hoping for was a pointer like that. I have a lot of tables to transfer but not all require any massaging of the data so I might be able to use CF for some and SQL for the others.
Cheers :) On 12 December 2012 16:23, Cameron Childress <[email protected]> wrote: > > On Wed, Dec 12, 2012 at 11:16 AM, Edward Chanter <[email protected]> > wrote: > > > my first question is whether CF is best for > > this or if I should try to do this with SQL queries. If the answer is 2 > can > > anyone point me in the right direction as to how I would go about doing > > this in native SQL? Or is there a more efficient way to do this in CF? > > > > Making all the data do a round trip to CF and then back to the Database is > always going to be slightly slower. Doing this 90K times in a row may > magnify this effect. If it's slow in CF, then yes, write it in SQL. Only > you can answer this question. If it's a one time migration though, who > cares if it's slow as long as it happens. > > Explaining how to write the SQL to do this is beyond the scope of a simple > email, but I would start by taking a look into the syntax for "SELECT > INTO", which will allow you to select data from one table directly into > another. If you need to massage the data first, then it will get more > complicated. > > -Cameron > > -- > Cameron Childress > -- > p: 678.637.5072 > im: cameroncf > facebook <http://www.facebook.com/cameroncf> | > twitter<http://twitter.com/cameronc> | > google+ <https://profiles.google.com/u/0/117829379451708140985> > > .... > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353441 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
