Hi, Almost 100% correct. The attachments are compressed/inflated on the client side, via the API.
I would suggest doing this via the free RRR|Chive utility that is very very good at doing Delta Data Migrations between servers of different types, and applications that look slightly different. This small config will synchronize your old server to the new server in a single run. The first will be slow, but the consecutive ones will be lightning fast (maybe 30 minutes if you have ~ 10,000,000 records in your system). source_server = old source_user = Demo source_password = target_server = new target_user = Demo target_password = multipleforms = * splitsearch = YES transfertype = SYNCTOTARGET logfile = AUTO progressbar = YES Download and configure the tool at: https://www.rrr.se/cgi/rrrchive/main Best Regards - Misi, RRR AB, http://rrr.se > 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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

