Service Desk Practitioners Forum
cancel

Attachment migration verification

SOLVED
Go to solution
Highlighted
Craig R Taylor
Honored Contributor.

Attachment migration verification

Hello folks,

We looking at uprading SP23 from Sp11 so one of the steps required is to migrate the attachments to the new directory structure. Is there a means to find out if the migration was successful or not?
You can observe a lot just by watching. - YOGI BERRA
5 REPLIES
George M. Meneg
Acclaimed Contributor.

Re: Attachment migration verification

Hello Craig,

Actually there is a pretty trivial way to check the new structure. Do the migration and then point your test server (I assume that you are going to do an upgrade at a test system first) to the new location. Find an item with the attachment and try to open it at the test server.
menes fhtagn
Craig R Taylor
Honored Contributor.

Re: Attachment migration verification

Is there a way to confirm that they all were copied over? (aside from opening them one by one) Or would I just check the directory info and it should tell me how many files are each?
You can observe a lot just by watching. - YOGI BERRA
George M. Meneg
Acclaimed Contributor.
Solution

Re: Attachment migration verification

Hello Craig,

Count ONLY the files (not directories). Then do the following:

select count (*) from dbo.REP_ATTACHMENTS
where AHS_ENT_OID is not null
and AHS_ATT_OID is not null and AHS_BASENAME is not null

the numbers should be roughly equal.
menes fhtagn
Craig R Taylor
Honored Contributor.

Re: Attachment migration verification

Excellent! Thanks again for your help George
You can observe a lot just by watching. - YOGI BERRA
Craig R Taylor
Honored Contributor.

Re: Attachment migration verification

Solution as George described
You can observe a lot just by watching. - YOGI BERRA