[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_display.php on line 885: unserialize(): Error at offset 21 of 47 bytes
ROBOT.LK • Connecting databases in two locations
Page 1 of 1

Connecting databases in two locations

Posted: Thu Aug 11, 2011 4:13 pm
by NadeekaDN
mata location 2kaka thiyana database 2k connect karanna ona. kramayak thiyeda????

Re: Network..

Posted: Thu Aug 11, 2011 4:17 pm
by Rksk
oyage prasnaya thawa tikak visthara samaga ahanna. ohoma ahuwama katawath therenne nane!

[ Post made via Mobile Device ] Image

Re: Connecting databases in two locations

Posted: Thu Aug 11, 2011 4:35 pm
by 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

Re: Connecting databases in two locations

Posted: Thu Aug 11, 2011 4:43 pm
by 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................

Re: Connecting databases in two locations

Posted: Thu Aug 11, 2011 4:45 pm
by NadeekaDN
virtual vpn software eakakin wage me wade karanna puluwan weida??? mage netwark knowelge 0. ea nisa karanna puluwan krama mata kiyanna..

Thanks.....
________________

Re: Connecting databases in two locations

Posted: Thu Aug 11, 2011 4:48 pm
by NadeekaDN
Replication sadaha vpn connection eakak awasyada??? mata static ip eakak purchase karala eakata connect karoth kohoma cost eakak yaida???

Thanks....... ;)

Re: Connecting databases in two locations

Posted: Thu Aug 11, 2011 6:39 pm
by 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.