you may also want to read up on stored procedures,custom functions cursors, and bulk inserts which would help in converting cfml to TSQL
On Wed, Dec 12, 2012 at 4:28 PM, Edward Chanter <[email protected]> wrote: > > 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:353442 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
