I am attempting to move sharepoint list items from a main list to an archive list. I am using WSS 3.0 Both of these lists were created from the same template so the column structure matches perfectly.
I have attempted to do this migration my altering two sql tables. alldocs and alluserdata
in the alluserdata table i have modified two columns TP_ListID and TP_DirName.
in the alldocs table i have modifed the same two columns TP_ListID and TP_DirName.
after making these modifications to an item in the main list they do not show up in the archive list. i have compared the records side by side with an item that was manually created in the archive list and i cannot see any differneces between a list item created in sharepoint to one that i manually move in this fashion.
I feel as tho i am missing a table that needs to be changed in a similar fasion. I know i can use a datasheet view and copy and paste the records however i am attempeting to maintain the version history between the two lists. The reson i am choosing t-sql is i would like to schedule a job to archive these records once a month as the main list is taking several minutes to load due to the amount of records in the list.
I have attempted to do this migration my altering two sql tables. alldocs and alluserdata
in the alluserdata table i have modified two columns TP_ListID and TP_DirName.
in the alldocs table i have modifed the same two columns TP_ListID and TP_DirName.
after making these modifications to an item in the main list they do not show up in the archive list. i have compared the records side by side with an item that was manually created in the archive list and i cannot see any differneces between a list item created in sharepoint to one that i manually move in this fashion.
I feel as tho i am missing a table that needs to be changed in a similar fasion. I know i can use a datasheet view and copy and paste the records however i am attempeting to maintain the version history between the two lists. The reson i am choosing t-sql is i would like to schedule a job to archive these records once a month as the main list is taking several minutes to load due to the amount of records in the list.