Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. Design and Architecture
  4. Website design help

Website design help

Scheduled Pinned Locked Moved Design and Architecture
pythondatabasewcfdesignhelp
6 Posts 4 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Offline
    S Offline
    Simon_Whale
    wrote on last edited by
    #1

    I trying to find the best way to structure the company website. They want the website to now be off site in a hosted location, BUT the database that it uses are to stay here in the office as it is integrated into the back office systems. The site currently has a public area and 2 sub sites (these talk to the database regularly) that are membership based and also has web services that are used by external parties. My thoughts are to host the all of the above in the hosted location and have it talk to the database in our office through a web service but I am not sure that this is the best approach.

    Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

    J L 2 Replies Last reply
    0
    • S Simon_Whale

      I trying to find the best way to structure the company website. They want the website to now be off site in a hosted location, BUT the database that it uses are to stay here in the office as it is integrated into the back office systems. The site currently has a public area and 2 sub sites (these talk to the database regularly) that are membership based and also has web services that are used by external parties. My thoughts are to host the all of the above in the hosted location and have it talk to the database in our office through a web service but I am not sure that this is the best approach.

      Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

      J Offline
      J Offline
      jschell
      wrote on last edited by
      #2

      What happens to the website if if can't talk to the database in the office?

      S 1 Reply Last reply
      0
      • J jschell

        What happens to the website if if can't talk to the database in the office?

        S Offline
        S Offline
        Simon_Whale
        wrote on last edited by
        #3

        Then our claims handlers and brokers can't retrieve specific information from our back office database.

        Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

        J 1 Reply Last reply
        0
        • S Simon_Whale

          Then our claims handlers and brokers can't retrieve specific information from our back office database.

          Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

          J Offline
          J Offline
          jschell
          wrote on last edited by
          #4

          The point however is that you need a business decision about how that impacts the business functionality of the site. That in turn impacts the implementation. Some possible implementations. 1. The site is unusable, and tells the user that. 2. Some specific parts are unusable and tells the user that. 3. Data from the office is cached, with perhaps appropriate expiration times (which again might require some user error if.) 4. Any down time at all is unacceptable thus a replication scheme is needed. Not to mention of course that you want some way to be notified if the web site can't see the database.

          1 Reply Last reply
          0
          • S Simon_Whale

            I trying to find the best way to structure the company website. They want the website to now be off site in a hosted location, BUT the database that it uses are to stay here in the office as it is integrated into the back office systems. The site currently has a public area and 2 sub sites (these talk to the database regularly) that are membership based and also has web services that are used by external parties. My thoughts are to host the all of the above in the hosted location and have it talk to the database in our office through a web service but I am not sure that this is the best approach.

            Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

            L Offline
            L Offline
            Lost User
            wrote on last edited by
            #5

            If the web application must use the database in your office, then go for a web service (a WCF service in case of a .NET solution) in between your web site and the database, otherwise you may want to have a separate database for your web site. I find it easy to have separate databases for each app and make them share data as needed instead of one big "do-it-all" database that is hard to maintain.

            D 1 Reply Last reply
            0
            • L Lost User

              If the web application must use the database in your office, then go for a web service (a WCF service in case of a .NET solution) in between your web site and the database, otherwise you may want to have a separate database for your web site. I find it easy to have separate databases for each app and make them share data as needed instead of one big "do-it-all" database that is hard to maintain.

              D Offline
              D Offline
              dschumann
              wrote on last edited by
              #6

              Is replication an option in this case? Hopefully this is ok. If not, sorry. http://www.sql-tutorial.net/sql-replication.asp[^]

              1 Reply Last reply
              0
              Reply
              • Reply as topic
              Log in to reply
              • Oldest to Newest
              • Newest to Oldest
              • Most Votes


              • Login

              • Don't have an account? Register

              • Login or register to search.
              • First post
                Last post
              0
              • Categories
              • Recent
              • Tags
              • Popular
              • World
              • Users
              • Groups