Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SharePoint 2013 as a File repository

Posted on 2013-10-28
6
Medium Priority
?
470 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 1185 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

721 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