Best way to move 75,000 files with attachments?
2 posts by 2 authors in: Forums > CMS Builder
Last Post: April 27, 2011 (RSS)
By nmsinc - April 27, 2011
[font "Times New Roman"]I have a new client with 75,000 plus data records - each record has a single tiff file associated with it. I need to move these records with attachments to a new website built with CMS.[/#000000]
[font "Times New Roman"] [/#000000]
[font "Times New Roman"]I have the new SQL database created within CMS – what is the best way to retrieve and move the data and associated attachments to the new database without loosing file associations with the attachments?[/#000000]
[font "Times New Roman"] [/#000000]
[font "Times New Roman"]Regards[/#000000]
[font "Times New Roman"]RBH[/#000000]
[font "Times New Roman"] [/#000000]
[font "Times New Roman"]I have the new SQL database created within CMS – what is the best way to retrieve and move the data and associated attachments to the new database without loosing file associations with the attachments?[/#000000]
[font "Times New Roman"] [/#000000]
[font "Times New Roman"]Regards[/#000000]
[font "Times New Roman"]RBH[/#000000]
nmsinc
Re: [nmsinc] Best way to move 75,000 files with attachments?
By Dave - April 27, 2011
Hi RBH,
There's no easy automated way, so it might take a bit of experimenting or some custom php/mysql code.
What format is the data in or are you able to get the data in? Ideally you'd want MySQL or CSV.
Next, is the attachment actually an attachment or just a URL or filepath? Do you need it to be represented as an upload in CMSB or could you just have that url/filepath in a text field?
Let me know some more details and I'll do my best to help. Thanks!
There's no easy automated way, so it might take a bit of experimenting or some custom php/mysql code.
What format is the data in or are you able to get the data in? Ideally you'd want MySQL or CSV.
Next, is the attachment actually an attachment or just a URL or filepath? Do you need it to be represented as an upload in CMSB or could you just have that url/filepath in a text field?
Let me know some more details and I'll do my best to help. Thanks!
Dave Edis - Senior Developer
interactivetools.com
interactivetools.com