What a big disappointment, Dave. It wont connect to a remote database to update, only to a web service. Who the hell inserts 40,000 records into a database using a web service???
So instead i have to have the tool create a big SQLscript. I have to run a 85MB SQLscript. by cutting and pasting it into my Query Analyser. It's been running 8 minutes now, and i hope it isnt going to timeout on me. Not fillng me with confidence, but at least it's a move forward. Thanks for suggesting it. Cheers Mike Kear On Mon, Jan 5, 2009 at 3:20 PM, Mike Kear <[email protected]> wrote: > No I havent, Dave, and I'm surprised that in all the whinging I've > done to Microsoft in the last 3 years, no one there has mentioned it. > I'ave gone at them over this issue so many times, i have had to ease > off in the last few months lest i be classed as a "vexatious support > caller" and get myself banned. > > Perhaps my pestering over the years resulted in an outcome, but no one > there figured it was worth telling me. > > I dont know but i'll give it a try. On the face of it, this looks > like the solution for me. Thanks! > > Cheers > Mike Kear > Windsor, NSW, Australia > Adobe Certified Advanced ColdFusion Developer > AFP Webworks > http://afpwebworks.com > ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month > > > On Mon, Jan 5, 2009 at 3:06 PM, Dave Watts <[email protected]> wrote: >>> Can someone please give me some help... IN the old days I used to have a >>> DTS task running overnight automatically, copying databases to and >>> from my dev environment to the production web sites. >> >> Have you tried this? >> http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en >> >> Dave Watts, CTO, Fig Leaf Software >> http://www.figleaf.com/ >> >> Fig Leaf Software provides the highest caliber vendor-authorized >> instruction at our training centers in Washington DC, Atlanta, >> Chicago, Baltimore, Northern Virginia, or on-site at your location. >> Visit http://training.figleaf.com/ for more information! >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317377 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
