Solved

SharePoint 2013 as a File repository

Posted on 2013-10-28
6
428 Views
Last Modified: 2013-11-17
Hi,
I have SharePoint 2013/SQL 2012/Win Server 2012.
I want to migrate scan files from my File server into related Folders in a document Library  (Say.... D:\ drive, Size >5 GB).
What is better way of doing this migration -
1.any utility available free or can be developed via code ?
2.Is there any New  storage way in SQL server 2012 for repositing scan files into share-point 2013 Document Library.
Rgds/-
0
Comment
Question by:sharepointDepot
  • 4
  • 2
6 Comments
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 395 total points
ID: 39608215
Hi,
for migrating the content to a library you could use a Powershell script using SharePoint client object model (then you are able to set meta data if this is necessary).

About size: is this the size of the whole folder OR the max size of a single scan?

The max file size for SharePoint is still 2GB.
There is no new way of storage - just how deltas in files can be stored (e.g. changing a paragraph in a word doc). For handling huge files I would recommend to think about using RBS (Remote Blob Storage) for SQL Server/Sharepoint.

About editions:
Which editions of SQL Server and SharePoint are you talking about: Express/Foundation or Standard/Server or Enterprise/Enterprise?

KR
Rainer
0
 

Author Comment

by:sharepointDepot
ID: 39608372
Hi,
Powershell i have some idea on codeplex.

about Size,
 source Folder Size on File server >5 GB.
SharePoint Doc Lib->folder1,folder2,folder3, in these folder, we need to migrate scan files upto 10 MB in each folder.

SharePoint 2013 ENT,  SQL 2012 STD,  Win Server 2012 (all new series)
Rgds/-
0
 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 39619084
Hi,
then I would simply write a Powershell script as you have full control on it and it simply can exactly do what you want. Most tools I have seen are both costly and have always a limitation which ends up in manual work afterwards.

HTH
Rainer
0
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 

Author Comment

by:sharepointDepot
ID: 39655531
0
 

Author Comment

by:sharepointDepot
ID: 39655533
I've requested that this question be closed as follows:

Accepted answer: 175 points for RainerJ's comment #a39608215
Assisted answer: 0 points for sharepointDepot's comment #a39655531

for the following reason:

because after that i run some custom code, then it meet full scenario.
0
 

Author Closing Comment

by:sharepointDepot
ID: 39655534
ok
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question