I doubt that you can use any direct SQL to store these fields as an ARS attachment is a BLOB and has proprietary compression applied.
Meta-Update uses the API so it too would be restricted on reads for external "Image' fields but can be used with a simple pre-step of extracting the attachments from SQL to the file system. Meta-Update can then rename the attachments correctly upon insertion into ARS using the API. Cheers Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: <mailto:[email protected]> Ben.Chernys _AT_ softwaretoolhouse.com Web: <http://www.softwaretoolhouse.com> www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Terje Moglestue Sent: September-28-11 14: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 ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
