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. Web Development
  3. ASP.NET
  4. Fastest way to get data accross the internet

Fastest way to get data accross the internet

Scheduled Pinned Locked Moved ASP.NET
databasebusinesssysadminquestionannouncement
5 Posts 3 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.
  • R Offline
    R Offline
    Rhys Jacob
    wrote on last edited by
    #1

    I have some vague requirements at the moment but basically I need to take some data from a local database and use it to update the data in a remote database. The local application does not have direct access to the remote db. Because of the nature of the business, this data update needs to be a fast as possible. My first instinct would be to put up a webservice on the remote server and use this to update the remote database but does anyone know of a way that would be significatly quicker? Thanks very much

    J P 2 Replies Last reply
    0
    • R Rhys Jacob

      I have some vague requirements at the moment but basically I need to take some data from a local database and use it to update the data in a remote database. The local application does not have direct access to the remote db. Because of the nature of the business, this data update needs to be a fast as possible. My first instinct would be to put up a webservice on the remote server and use this to update the remote database but does anyone know of a way that would be significatly quicker? Thanks very much

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

      Your method sounds reasonable, if you can't get access to it via VPN or similar then a secured web service is going to have to be the way to go. Nothing's faster than a point to point really, the main concern I suspect would just be security.

      1 Reply Last reply
      0
      • R Rhys Jacob

        I have some vague requirements at the moment but basically I need to take some data from a local database and use it to update the data in a remote database. The local application does not have direct access to the remote db. Because of the nature of the business, this data update needs to be a fast as possible. My first instinct would be to put up a webservice on the remote server and use this to update the remote database but does anyone know of a way that would be significatly quicker? Thanks very much

        P Offline
        P Offline
        PSK_
        wrote on last edited by
        #3

        Why not a SSIS/DTS package for data transfer?

        Regards, Prakash Kalakoti

        R 1 Reply Last reply
        0
        • P PSK_

          Why not a SSIS/DTS package for data transfer?

          Regards, Prakash Kalakoti

          R Offline
          R Offline
          Rhys Jacob
          wrote on last edited by
          #4

          The local DB will probably be mySql and the remote will be Sql Server so I don't think that would work. Also the data is not replicated as such, it's used to alter the data in the remote db. I should also say that this transfer will occur pretty regularly but not at time defined intervals. So what I'm thinking is that there would be a local app to get data from the local db and to send it to a remote webservice which would use that information to update the remote db unless there is a faster way to do it? Is remoting likely to be faster? Thanks, Rhys

          P 1 Reply Last reply
          0
          • R Rhys Jacob

            The local DB will probably be mySql and the remote will be Sql Server so I don't think that would work. Also the data is not replicated as such, it's used to alter the data in the remote db. I should also say that this transfer will occur pretty regularly but not at time defined intervals. So what I'm thinking is that there would be a local app to get data from the local db and to send it to a remote webservice which would use that information to update the remote db unless there is a faster way to do it? Is remoting likely to be faster? Thanks, Rhys

            P Offline
            P Offline
            PSK_
            wrote on last edited by
            #5

            Remoting will be definitely faster if you choose TCP channel and the binary formatter.

            Regards, Prakash Kalakoti

            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