GitHub:https://github.com/ruffeechen/uapNC

Scene: 1, the system stored in a database table in the attachment, and take up a bigger space;

2, the attachment format is complex, a single file;

3, all the accessories need to be stored locally, for the old stored in the database file

Ensure the available under the "disk storage", provides a moving in the database file to disk tools,

# # instructions before reduction:

Database backup, backup application to a large enough disk space (virtual machine deployment)

Local, storage or FTP file server to store all feasible

# # database query script related attachment number and the size of the file:

Select count (*), sum (t.f length/1024/1024) from sm_filestoreview t

# # to deploy patch: hotwebs, modules to ensure hotwebs don't have the same files in a directory

# # configuration sysconfig

Sets the file storage mode to local storage, FTP or file server (file server to test whether can be normal to submit to download attachments)

# # custom accessories store path:

In the first place in the heart of the sysconfig document storage Settings for local file storage, and then modify the {nchome}/ierp/sf/documentConfig. XML file,

Modify parameters root. Dir. The value of the path value

This value can not change again after modification, the store path changes need to restart the service,

# # to restart service

# # to visit

http://ip: port/dc/remove/index. The JSP configuration data source, migration of executable files

# # test

Combined with the system to read and write speed, 12 g took an average of 30 minutes of migration time, if a disk read and write speed, is more save time!

# # the migration completed

After the migration, need to run the test over a period of time, after verification and correct, can delete the attachment data in a database table.

It is best to backup files intact

Attachment: document management center configuration



If you have needs, can contact with oneself!