Connecting databases in two locations

[NadeekaDN]

mata location 2kaka thiyana database 2k connect karanna ona. kramayak thiyeda????

[Rksk]

oyage prasnaya thawa tikak visthara samaga ahanna. ohoma ahuwama katawath therenne nane!

[ Post made via Mobile Device ]

[Neo]

??? ?????? ?????? SQL Server ??? ???? ??? built-in ????? SQL Server replication ???? option ?? ????? ????? ???????. ??? link ?? ?????. http://msdn.microsoft.com/en-us/library/ms151198.aspx

?? ?????? ?????? Oracle ??? ?? link ?? ?????.
http://download.oracle.com/docs/cd/B193 ... 26/toc.htm

MySQL ??? ??? link ?? ?????
http://dev.mysql.com/doc/refman/5.0/en/replication.html

?????? ???? ??? ???? ?????? replication method ???? ?????? ?????. ??? ??? Network Sockets ???? communicate ??? ???? daemon application ???? server side ??? run ??? ?????? ???.

??? Internet ???? ??? ????? ?????, ADSL ??? ??? ??????? IP ????? ??? ???? ??? ???? ?? ?????? DSN ?? router configuration ????? ?????.

???? ?? ?? ??????? ???? ??????? ????? TOPIC ????? ????? ???????.

?? ??? ???????? type ????? ?? ??? ??? link ?? ????? ?????
https://robot.lk/viewtopic.php?f=91&t=1119

[NadeekaDN]

mekai wenna oni.. colombo head office thiyanawa. kandy branch eakak thiyanawa. mata puluwannda visual studio application eakakin head office database access karanna mona hari software hari mona hari technology eakak use karala..

___________________
Thanks................

[NadeekaDN]

virtual vpn software eakakin wage me wade karanna puluwan weida??? mage netwark knowelge 0. ea nisa karanna puluwan krama mata kiyanna..

Thanks.....
________________

[NadeekaDN]

Replication sadaha vpn connection eakak awasyada??? mata static ip eakak purchase karala eakata connect karoth kohoma cost eakak yaida???

Thanks.......

[Neo]

mekai wenna oni.. colombo head office thiyanawa. kandy branch eakak thiyanawa. mata puluwannda visual studio application eakakin head office database access karanna mona hari software hari mona hari technology eakak use karala..

Mama hithanne api meka already discuss kara kiyala. Static IP thiyenavanam lesiyenma karanna puluvan. Dynamic IP thiyenavanam tiak mahansi venna ona eth karanna puluvan. Api VPN ekak athuva ho nethuva link vela database ekata remote access karanna puluvan.

Oya replication setup karoth, oya set karana interval ekakata parak, eken automatically data synchronise venava. Manually karanna nam oya code eka liyanna ona. Oyata ekko directly database ekata connect venna puluvan. Nethnam podi server application ekak liyala sockets through communicate karanna puluvan.

virtual vpn software eakakin wage me wade karanna puluwan weida??? mage netwark knowelge 0. ea nisa karanna puluwan krama mata kiyanna..

Oyata static IP thiyenavanam VPN ekak onama nehe... Oya router eke port forwarding setup karama hari. SQL server nam database eka, eke port ekata ena okkoma packets adala PC eke adala port ekata yanna kiyala setup karanna thiyenne.

Replication sadaha vpn connection eakak awasyada??? mata static ip eakak purchase karala eakata connect karoth kohoma cost eakak yaida???

VPN ekak setup karagaththoth lesi. Namuth issella mama kiwwa vage nethuvath puluvan. Me link eka balanna.
http://www.replicationanswers.com/InternetArticle.asp

Cost eka:
Me link eka balanna: http://www.slt.lk/broadband/faq.html
Meke thiyena vidihata oya request karoth Web Pro, Web Pro Plus, Web Master, Web Master Plus kiyana packages valata oya request karoth Static IP ekak ganna puluvan. Additional charge ekak gevanna onada kiyana eka danne nehe. SLT ekata call ekak dila okkoma visthara denaganna puluvan.