Sue, In theory this sounds alot easier than it is. In addition to changing the RoleTypeID and TableID, on both the ConXrefs and ConXrefDetails tables, you also need to change the ConXrefs.ID from ObjectID to ObjRightsID. This requires that you add an ObjRights Record for every record that has the applicable ConXref.
 
~Chad
On Wed, May 30, 2012 at 1:12 PM, Garton, Susan <[log in to unmask]> wrote:

Hi all,

 

I’m wondering if anyone else had rights related constituents entered in TMS before upgrading to TMS 2010? We have over 1,000 of them entered as acquisition related constituents, with roles of Copyright Owner and Copyright Contact. We’d like to move them into Rights Related Constituent Xrefs on the R&R screen, and I’m wondering if anyone has already written a SQL update to do this. Thank you in advance for sharing if so!

 

Sue Garton

Data Administrator

National Portrait Gallery

(202) 633-8554 / [log in to unmask]

 

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.


To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.