Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
geossl
Yak Posting Veteran
85 Posts |
 Posted - 2011-11-29 : 23:34:11
|
| Dear All, There is a scenario that there is a number of files (more than 20 files ) with total size exceeds 90Mbyte. It needs to copy these files to associated networked file folders and update the related records in the database. What is the best solution to this? Version 1: Copy the files, start transaction, update DB, commit Version 2: start transaction, copy files, update db, commit Version 3: Copy files to tmp folder in networked folder, start transaction, updatedb, rename network folder, commit? Version 4: Use SharePoint? or other solution? |
|
|
|
|
|
System Solution Design with large blob