Solved

SharePoint 2013 as a File repository

Posted on 2013-10-28
6
413 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

by:sharepointDepot
Comment Utility
0
 

Author Comment

by:sharepointDepot
Comment Utility
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
Comment Utility
ok
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

728 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now