c# - Best way to sync remote SQL Server database with local SQL Server Compact database? -

-

i realise discussed topic suggestions see seem involve direct access sql server in our instance not ideal.

our scenario remote sql server database (say) 100 tables. developing lightweight desktop application use sql server compact database , sync subset of (say) 20 tables remote server periodically.

i have control on how replication occurs because speed major issue since remote server 1000's of miles away.

also don't need sync records in each table - relevant each user.

i quite sql merge facility requires client connected remote sql server. not possible , thinking of interfacing remote server through web service accessed through our application or other method.

any suggestions welcome.

update

just clarify, internet connection intermittent, that's main reason why need sync 2 databases.

the fact using compact db client puts pretty heavy limitations on available options in scenario.

given limitations , performance requirements desire, consider implementing service-based http endpoint keep desired tables in sync. if architecture allows it, doing asynchronously boost performance again, may not viable depending on architecture.

something else consider using web sockets rather standard http connections web service mentioned above. way keep clients synced real-time, since web sockets true duplex real-time connections. major catch either have ensure clients web-socket compliant or provide fall-back emulate websocket connection emulation framework clients aren't par.

not sure if helps any.


Comments

Post a Comment

Popular posts from this blog

java - Jmockit String final length method mocking Issue -

-
using jmockit 1.2 jar, trying mock string's length method getting unexpected invocation exception: failed: test java.lang.illegalstateexception: missing invocation mocked type @ point; please make sure such invocations appear after declaration of suitable mock field or parameter @ stringdemo.testa$1.<init>(testa.java:17) @ stringdemo.testa.test(testa.java:13) i using testng: @test public void test() throws exception { new expectations() { @mocked("length") string astring; { astring.length(); result = 2; } }; system.out.println(a.showa("test")); } } actual class a: public class { public static int showa(string str){ int a= str.length(); return a; } } this wrong way of recording expected results. shouldn't mock , record string's length() method, record showa() instead. here solution @suppresswarnings("unused&qu
Read more

asp.net - Razor Page Hosted on IIS 6 Fails Every Morning -

-
i have simple page in intranet uses razor/asp fetch single record table , display it, plus few graphic, dashboard display. meaning, no user intervention other first time open ie internal url. the problem having every morning ie displays "page not found or network error" message. refresh page, , it's stuck , doesn't display anything. try different pc, open ie internal url , it's stuck... ...until following: login server hosting page run inetmgr go web sites, etc right click on page that's giving me problem , select browse at moment, error message: server error in '/' application. -------------------------------------------------------------------------------- type of page not served. description: type of page have requested not served because has been explicitly forbidden. extension '.cshtml' may incorrect. please review url below , make sure spelled correctly. requested url: /application/dashboard.cshtml ---------------
Read more

c++ - wxwidget compiling on windows command prompt -

-
can please guide me on method,as how compile wxwidget using windows command prompt or msys. [i can't seem find on wxwiki/wxwidget official book/anywhere else] i have compiled wxwidget instructions have provided (using msys). from searching on internet seems 1 can (maybe?) through use of makefile (is correct?) if yes: directory & how should link wx libraries in makefile if no: way besides makefile? i know can use ide's code::block , make life simpler prefer compile using command prompt/msys. thanks in advance.
Read more