Solved

SharePoint 2013 as a File repository

Posted on 2013-10-28
6
456 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 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
Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

 

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how the fundamental information of how to create a table.

617 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