Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
khalik
Constraint Violating Yak Guru
443 Posts |
 Posted - 2009-01-05 : 10:21:48
|
| hi GuysI have to design a system which will do data sync for a smart client.smart client have poor net connectivity.1. Webservices which will return the entire data(zip format)2. DTS package converted to .net code 3. SSIS calling from .netthe problem is i have huge data and i cannot afford to hold transaction on either sides. i need a quick and stable option to sync the data.guys please help me in giving the best known options. any of above or any thign you feel is good.ThanksKhalik======================================Ask to your self before u ask someone |
|
|
khalik
Constraint Violating Yak Guru
443 Posts |
Posted - 2009-01-06 : 05:46:25
|
| is there no one who can throw some light?======================================Ask to your self before u ask someone |
 |
|
|
khalik
Constraint Violating Yak Guru
443 Posts |
Posted - 2009-02-16 : 07:36:29
|
| GuysI have framed a model which will help me doing data Sync with in limited time. need your suggestion if i am improve any thingi have a web services which calls a SP, Sp uses bcp command and generates the txt files with data. web services zip the txt files and return the zip file.client app unzip the file and using bulkinsert insert into a table and then perform insert and update operation on actual table.if any one has a better model to do this or any improve the performance do let me know========================================Project Manager who loves to code.===============Ask to your self before u ask someone |
|
|
|
|
|
|
Smart client Data sync