Attachments are compressed by the server before being sent to the database and the code to decompress them is not available other than via AR API. You need to use the server to get the attachments out in their original format.
Mark I work for BMC, I don't speak for them. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Terje Moglestue Sent: 28 September 2011 13:05 To: [email protected] Subject: Get attachments from View Forms or direct SQL? ** I am looking into some possible migrations from different databases (SQL 2005) to BMC 7.6.04 (SQL 2005). I can access the external databases (not AR SYSTEM) using View Forms. The plans is to build workflow and then migrate some of the data. How can I best solve attachments? I understand that field type 'image' is not support by view forms. external databases uses the same field format 'image' as AR System. It should be possible to get these attachments by direct SQL? Any tips? Any utilities? ~ Terje _attend WWRUG11 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
