Hey Andrew, I do use redgate (love it!), but I need to be able to transfer objects from a number of tables, and there is also lots of JSON encoded data that itself contains id references from other records and file path references for media. Also, for each 'object' there is a specific directory structure and supplemental files. Its hella complicated :(
Anyhow, I already wrote the code to copy the forms and its really multipurpose as customers often ask to transfer/copy forms between accounts aswell. So now we can do that via a web ui, and also port a problematic form to our debugging server where we can replay their failed commit (we store the commit array which describes each change made before saving) and find where the problem is. Brook -----Original Message----- From: Andrew Scott [mailto:[email protected]] Sent: January-30-12 11:02 AM To: cf-talk Subject: Re: CFFILE to \\tsclient\c$\ Because of your comment "this system is intended to transfer the objects from a production server to another server used specifically for debugging ", I think there has to be a better way to sync and debug than what you're doing. I mean why can't you use red-gate for MS SQL server sync and beyond compare for files, to your testing environment? Or even backup your database and transfer it to your testing server, and restore the database to a local SQL Server, and file sync the files. Just throwing some ideas out there, as I do not know much about your situation. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Tue, Jan 31, 2012 at 5:53 AM, Brook Davies <[email protected]> wrote: > > I do? Why? > > -----Original Message----- > From: Andrew Scott [mailto:[email protected]] > Sent: January-30-12 10:11 AM > To: cf-talk > Subject: Re: CFFILE to \\tsclient\c$\ > > > Sounds like you need a better debugging strategy then. > > > -- > Regards, > Andrew Scott > WebSite: http://www.andyscott.id.au/ > Google+: http://plus.google.com/108193156965451149543 > > > > On Tue, Jan 31, 2012 at 5:01 AM, Brook Davies <[email protected]> > wrote: > > > > > Yeah, that's an option, I could create a zip file.. really though this > > system is intended to transfer the objects from a production server to > > another server used specifically for debugging. So I wanted to leverage > the > > same code base that used UNC file paths to copy the data. Being able to > > plugin my localhost as a list of available servers to copy the data to > > would > > have been nice, but its not a 100% requirement. > > > > Brook > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:349677 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
