Solved

SharePoint 2013 as a File repository

Posted on 2013-10-28
6
423 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

777 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