Find Jobs
Hire Freelancers

Data migration project, SQL to SharePoint

$25-50 USD / hour

进行中
已发布将近 11 年前

$25-50 USD / hour

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!
项目 ID: 4503277

关于此项目

27提案
远程项目
活跃11 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
Hi Gary, I have gone through the description and please check the [login to view URL] for a crucial question regarding the project.
$26 USD 在35天之内
4.8 (14条评论)
5.8
5.8
27威客以平均价$38 USD/小时来参与此工作竞价
用户头像
Please let us know... We would love to work on this
$36 USD 在40天之内
4.7 (48条评论)
7.6
7.6
用户头像
Hello, We are willing to assist you on this Project. Please check Private Message Board.
$35 USD 在30天之内
4.9 (46条评论)
7.6
7.6
用户头像
Experts are here to work on your data migration project. Thanks
$38 USD 在30天之内
4.9 (6条评论)
7.6
7.6
用户头像
see PMB for details
$44 USD 在40天之内
5.0 (7条评论)
7.4
7.4
用户头像
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 在10天之内
4.6 (30条评论)
6.6
6.6
用户头像
We are sharepoint expert.
$38 USD 在40天之内
4.7 (31条评论)
6.0
6.0
用户头像
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 application that will run on SharePoint Server and will do the data migration! We will be using Client Object Model to add all data to SharePoint... Please let us know if that sounds good... Thanks, Arsalan
$47 USD 在12天之内
4.9 (42条评论)
5.3
5.3
用户头像
Hi there, please find more details in the inbox.
$27 USD 在25天之内
4.5 (8条评论)
5.3
5.3
用户头像
I have gone through the requirement you posted and we meet all of your technical requirements. Please see PMB for more details.
$31 USD 在45天之内
4.6 (5条评论)
5.1
5.1
用户头像
Dear customer please refer PMB for bid details.
$30 USD 在40天之内
4.9 (66条评论)
5.0
5.0
用户头像
Please check the PMB for bid details.
$35 USD 在40天之内
5.0 (5条评论)
4.8
4.8
用户头像
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) and database designing ( MS SQL 2000/2005/2008 ,MySQL). I'm available for you all the time
$41 USD 在40天之内
5.0 (1条评论)
3.6
3.6
用户头像
please check your pm
$39 USD 在3天之内
4.9 (4条评论)
3.4
3.4
用户头像
I am a MCTS Certified in SharePoint 2010 and have Awesome Experience in working on webbased portals using OOB,Customization.
$53 USD 在2天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 completed several SharePoint portals with full SDLC. Extensive exposure of migration from other applications to sharepoint.
$33 USD 在40天之内
0.0 (0条评论)
0.0
0.0
用户头像
HI, I'm a certified SQL Server Database architect [MCP, MCDBA, MCTS, MCITP] with 11 Years of experience in SQL Server database administration and development, and I'm very interested in your job post involving these skills.
$44 USD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
I´m expert certified in SQL and integration (BI/ETL). This Project needs knowledge in SharePoint and .NET coding to integrate data and permissions properly; and I´m the right professional in both areas. Please check PM for details
$41 USD 在30天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hi, We have more than 4 years of experience in commercial software development, installations and support for Microsoft products. We are working on SharePoint with leading European and USA companies. On time delivery is guaranteed Thanks. Please check PMB
$41 USD 在30天之内
0.0 (0条评论)
0.0
0.0
用户头像
We are experienced and Microsoft Certified Technical Specialists - SharePoint resource group. We are working a team and implement best practices of SharePoint. Also, had experience in several versions of SharePoint - 3.0, 2007, 2010, and 2013. We are offering our service for this project.
$27 USD 在30天之内
0.0 (0条评论)
0.0
0.0
用户头像
We are a Microsoft Gold partner company and we can help you out on this. Pls. reach me for further discussion.
$41 USD 在3天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
Scottsdale, United States
5.0
1
付款方式已验证
会员自1月 25, 2013起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。