By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,363 Members | 1,470 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,363 IT Pros & Developers. It's quick & easy.

dataset transfer from client to server

P: 41
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.
May 20 '08 #1
Share this Question
Share on Google+
1 Reply

code green
Expert 100+
P: 1,726
I had similar problems uploading a full DB and the database could get corrupted.
I chose this route.
Expand|Select|Wrap|Line Numbers
  1. .bat file to create Database dump (sql file) 
  2. FTP file to location.
  3. 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
May 21 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.