Solved

Problem - Database Storage

Posted on 2016-11-02
4
40 Views
Last Modified: 2016-11-06
To cut a long story short I have a piece of software that uses an an encrypted database file. What I want is to install the software and store the database file either in one drive of SharePoint.

  • The change in data media needs to be a UNC path
  • Users do not have admin and neither do i, cant map drives etc
  • We are a pure cloud solution, no on prem servers

Can this be done? How do I get the UNC of OneDrive for Business (preferred choice), I can set permissons for everyone to access etc, just need to get a proper UNC to add to the data set up in the software.

Ta
0
Comment
Question by:John Davies
4 Comments
 
LVL 78

Expert Comment

by:David Johnson, CD, MVP
ID: 41871546
I would not suggest sharepoint or onedrive but instead azure storage or amazon s3 storage. The question is more to the point of do you have the tools to move the database anywhere.  If you are using sql server you can setup a sql database on azure
https://azure.microsoft.com/en-us/pricing/details/sql-database/
0
 

Expert Comment

by:jwhdavies
ID: 41871681
Hi David, thanks for this. The file is just a flat file that is imported into the software, reason for.storing in onedrive or sharepoint. There is no sql or server software required.

Any help appreciated with unc for onedrive or sharepoint for business
0
 
LVL 32

Accepted Solution

by:
shalomc earned 500 total points
ID: 41875380
I have an idea but it is unverified as I currently do not have access to Onedrive.

Windows has the ability to map a drive to a webdav server. Sharepoint and Onedrive both support webdav. So you should be able to map a windows drive to either one.

Here is a relatively new article on the process, explaining it for Windows 10 and Onedrive.
 
https://www.thurrott.com/cloud/microsoft-consumer-services/onedrive/3638/onedrive-tip-map-your-cloud-storage-as-a-drive-in-file-explorer
0
 

Author Closing Comment

by:John Davies
ID: 41876027
Thank you for your help, appeciated
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
Find out what Office 365 Transport Rules are, how they work and their limitations managing Office 365 signatures.
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

707 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

12 Experts available now in Live!

Get 1:1 Help Now