Connecting databases in two locations
Connecting databases in two locations
mata location 2kaka thiyana database 2k connect karanna ona. kramayak thiyeda????
Last edited by Neo on Thu Aug 11, 2011 4:17 pm, edited 1 time in total.
Reason: Given a good topic title
Reason: Given a good topic title
Re: Network..
oyage prasnaya thawa tikak visthara samaga ahanna. ohoma ahuwama katawath therenne nane!
[ Post made via Mobile Device ]
[ Post made via Mobile Device ]
Re: Connecting databases in two locations
??? ?????? ?????? 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
?? ?????? ?????? 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
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................
___________________
Thanks................
Re: Connecting databases in two locations
virtual vpn software eakakin wage me wade karanna puluwan weida??? mage netwark knowelge 0. ea nisa karanna puluwan krama mata kiyanna..
Thanks.....
________________
Thanks.....
________________
Re: Connecting databases in two locations
Replication sadaha vpn connection eakak awasyada??? mata static ip eakak purchase karala eakata connect karoth kohoma cost eakak yaida???
Thanks.......
Thanks.......
Re: Connecting databases in two locations
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.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..
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.
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.virtual vpn software eakakin wage me wade karanna puluwan weida??? mage netwark knowelge 0. ea nisa karanna puluwan krama mata kiyanna..
VPN ekak setup karagaththoth lesi. Namuth issella mama kiwwa vage nethuvath puluvan. Me link eka balanna.Replication sadaha vpn connection eakak awasyada??? mata static ip eakak purchase karala eakata connect karoth kohoma cost eakak yaida???
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.