Re: [concrete] Moving uploads table to new database
Hi,
I have heard of this coming up before. It's actually pretty tricky, since the uploads table needs to track the tableName of the record's section, but also it's record number. If you are combining two tables, both of these fields will change, breaking the associations.
The best approach here, I think, would be to write a custom script that would take care of the move. It would be able to move the target record from one section to another, and then update the uploads table with the new tableName, and record number. The script itself would be pretty simple and would help eliminate errors and record num collisions.
If you are interesting in this, please send an email to
consulting@interactivetools.com and we can go over some options.
Hope this helps
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/