SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Thread: Online Database

  1. #1
    SitePoint Enthusiast
    Join Date
    Jul 2008
    Posts
    39
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Online Database

    Hi all,

    I was writing a description of a new site needed to my programmer. But came to think that there must be many people who have the same need. So I am hoping that you guys know of a solution/product that could solve this need.


    Database features needed:

    Situation:
    We have a increasing amount of data accumulation in Excel and across a number of computers. So a common problem is to located the most recent data.

    We would like to store this data on a online database, from which we can:

    * Access and view data
    * Change data
    o By manually data typing.
    o By uploading Excel sheets with data.
    * Extract data
    o To excel
    o Should be easy to select the needed data, also save often used data extractions.
    * Easy back up to home computer
    * Inexpensive to expand with new parameters.
    * High security.
    * Different user profiles, with different access.

    Hope this made sense.

    Thanks!

  2. #2
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Location
    Washington, DC
    Posts
    10,629
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Sharepoint and office excel server do this very well.

  3. #3
    SitePoint Enthusiast
    Join Date
    Jul 2008
    Posts
    39
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for your answer.

    The Sharepoint solution could work. Do you know how much a license costs?

    Does there exist other solutions, where we can save files on a server? I assume that the solutions works as if the server is just an extra harddrive in "my computer".

    /Eco

  4. #4
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Location
    Washington, DC
    Posts
    10,629
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Sharepoint itself is free if you already have Windows Server licenses, but the Office Excel Server is pretty pricey (at least last time I checked) and requires SQL server (which you might already have, if not, it is also pretty pricey).

    Sharepoint can be mapped to a drive, but looking at your requirements, the trick isn't saving things to a central location but rather all of the aggregation and pushing back out requirements.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •