Data migration project, SQL to SharePoint

In Progress

Old system (Source): MS SQL Server 2005 backend. Tables and data structure outlined below. Java Server Pages web application front end (irrelevant to the project, as the work will be done in the back end database, but just for reference).

New system (Target): SharePoint 2010 Enterprise Server (on premise):

Background on the application using this data. The existing JSP/SQL environment was developed 8 years ago and is being decommissioned. The application serves as a document storage library for Extranet customers (approx. 30,000 files). The new platform has been developed in SharePoint and we are ready for the data migration. Key points include:

- Retaining document permissions from old system to new is an absolute MUST.

- Users in the source system must be created in the new system as SharePoint FBA users.

- Customers from table 2 noted below are already present in the SharePoint environment as SharePoint Groups. FBA user accounts that are imported then need to be added to their appropriate customer group in SharePoint.

- Customer groups will have item level permissions (read only)

- Users will have item level permissions (read only).

Specific information on the source database:

• Database has 5 main tables that we need to deal with. I am summarizing this information, and my details are not precise, but here is a breakdown on those tables.

• Table 1 - Holds all files to be transferred into SharePoint. All files are in BinaryData form and are mostly made up of PDF files. There are approx. 29600 files. All of these need to be moved into a single SharePoint doc library.

• Table 2 – Customers (names/IDs of customers) Approx 535 rows

• Table 3 – Users (names of users who accessed the existing (Apache/JSP) web application. Approx 2730 rows. Each user is associated with a customer ID (from the table 2 mentioned above).

• Table 4 – Customer permission associations. This table gives customers in Table 2 access to documents in table 1. Looks to be around 5000 rows

• Table 5 – User permission associations. This table gives users specific access to documents outside the scope of customer associations outlined in table 4. For example, User1 might be associated with Customer1. That customer group has permissions to see Doc 1, 2 and 3, but table 5 would give user1 access to docs 4 and 5 as well. Looks to be around 5000 rows

• Total database size is 46 GB (all from table 1 binarydata obviously).

The tasks involved in this project include:

• Move all the files into the SharePoint doc library. Document metadata needs to be moved as well. This includes 3 columns (‘file name’, ‘title’ and ‘data modified’).

• Create SharePoint Extranet accounts for all users from table 3. We are using ‘SharePoint Solution’s Extranet Collaboration Manager’ to manage Extranet accounts. The user accounts can be imported using PowerShell.

• I then need each user account added to the appropriate Customer SharePoint Group according to their associations from table 3.

• Last, I need customer (SharePoint Group) permissions assigned to the appropriate documents in the doc library as defined from table 4 in the old system, AND user permissions assigned to the appropriate documents in the doc library as defined from table 5 in the old system.

Only highly qualified bidders will be considered, as this is a very crucial project that must be handled without difficulties. Timeframe to start the project is immediately and it must be completed by May 31st.

Thank you!

Skills: Database Administration, Sharepoint, Software Architecture, SQL

See more: powershell, permission migration file server, user group manager, tables in data structure, table data structure, system level architecture, sql pdf files, sql pdf file, project manager scope, new data structure, need of data structure, my sql create database, key data structure, java table data structure, java 1.5 doc, data structure with c, data structure that, data structure solution, data structure in java, data structure in, data structure example, c with data structure, c using data structure, c data structure library, c data structure

Project ID: #4503277

Awarded to:

mahinthan86

Hi Gary, I have gone through the description and please check the p.message for a crucial question regarding the project.

$26 USD / hour
(14 Reviews)
5.8

27 freelancers are bidding on average $38/hour for this job

meetesh

Please let us know... We would love to work on this

$36 USD / hour
(48 Reviews)
7.6
PSSPL2000

Hello, We are willing to assist you on this Project. Please check Private Message Board.

$35 USD / hour
(46 Reviews)
7.6
technosystem

Experts are here to work on your data migration project. Thanks

$38 USD / hour
(6 Reviews)
7.6
talhaamin

see PMB for details

$44 USD / hour
(7 Reviews)
7.4
SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$27 USD / hour
(30 Reviews)
6.6
qitsol

We are sharepoint expert.

$38 USD / hour
(31 Reviews)
6.0
mmsolutionz

Sir, We are expert team of Microsoft Technologies working on SharePoint and SQL Server for more than 5 years now! We have understood the requirements and are ready to jump in, we will be creating a utility/desktop ap More

$47 USD / hour
(42 Reviews)
5.3
FatalErr0r

Hi there, please find more details in the inbox.

$27 USD / hour
(8 Reviews)
5.3
daffodilsoftware

I have gone through the requirement you posted and we meet all of your technical requirements. Please see PMB for more details.

$31 USD / hour
(5 Reviews)
5.1
whizzaard

Dear customer please refer PMB for bid details.

$30 USD / hour
(66 Reviews)
5.0
akans3ha

Please check the PMB for bid details.

$35 USD / hour
(5 Reviews)
4.8
reechmeraj

Hello, I'm an expert in MS SQL, WSS,MOSS and other Microsoft Technologies. This work can be completed by the end of this month.For more information please check PMB.Thanks

$26 USD / hour
(6 Reviews)
4.1
cviorel

I've completed several SharePoint portals(WSS/Sharepint2007/2010) and I have the necessary knowledge to complete the project.I have 12+ years experience on web development experience (ASP,C#,VB.NET, javascript, AJAX) a More

$41 USD / hour
(1 Review)
3.6
MajidAsgari3

please check your pm

$39 USD / hour
(4 Reviews)
3.4
defactoinfotech

Dear Sir/Madam, I would like to take this opportunity to hopefully convince you to work with us. De facto Infotech is a Microsoft Partner with Silver Competency that offers Application Development, Integration and C More

$30 USD / hour
(1 Review)
2.6
velaskec

8+ years comercial software development for SharePoint: -Backup\Recovery -Migration

$50 USD / hour
(0 Reviews)
0.0
maustech

Independent/Freelancer SharePoint Consultant, having 10+ years of experience in Microsoft technologies - SharePoint Server, Project Server,ASP.NET, SQL Server, SSRS.

$33 USD / hour
(0 Reviews)
0.0
LightITGroup

Hello! We're interested in taking up your project. Please PM us and we'll discuss the details. Thank you!

$41 USD / hour
(0 Reviews)
0.0
amithkulkarni

We are a Microsoft Gold partner company and we can help you out on this. Pls. reach me for further discussion.

$41 USD / hour
(0 Reviews)
0.0
NextInfoServices

Certified Technology Specialist in Microsoft Sharepoint 2010 Configuration and Microsoft Sharepoint 2010 Application Development,I am able to work all the areas of sharepoint(i.e design,development,admin....).we have c More

$33 USD / hour
(0 Reviews)
0.0