dataset transfer from client to server

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dipalichavan82
    New Member
    • Feb 2008
    • 41

    #1

    dataset transfer from client to server

    I am developing .net application (.net remoting) where i am sending (currently) whole database from client to server n vice versa, so that updation made at client can be updated to server. and also changes at server can be updated at every appropriate branch(client). this application run at every time interval since i am assigning this application to windows scheduler.
    problem is currently i am sending whole databse (in datasets) from client to server n vice versa.But i want to reduce network traffic and load on server. how can i solve this problem.If i send data at datatable level instead of dataset , will there be any problem(if data corrupted i think it will be difficult to recover data , in this case). any other solution?
    please reply.thanks in advance.
  • code green
    Recognized Expert Top Contributor
    • Mar 2007
    • 1726

    #2
    I had similar problems uploading a full DB and the database could get corrupted.
    I chose this route.
    Code:
    .bat file to create Database dump (sql file) 
    FTP file to location.
    Script to run sql file.
    I chose to DROP each table and rebuild.
    May not be an exact solution but FTP could be worth considering

    Comment

    Working...