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"

Reply via email to