CARI
KATEGORI
KATEGORI
Home / FORUM / All / Tech / ... / Programmer Forum /
[ask] SQL - No SQL Server yg make database link?
KASKUS
51
244
https://www.kaskus.co.id/thread/5ee84cb6337f933a4e7cacd5/ask-sql---no-sql-server-yg-make-database-link

[ask] SQL - No SQL Server yg make database link?

sebelumnya just fyi ttg database link :
What Are Database Links?
A database link is a pointer that defines a one-way communication path from an Oracle Database server to another database server. The link pointer is actually defined as an entry in a data dictionary table. To access the link, you must be connected to the local database that contains the data dictionary entry.
A database link connection is one-way in the sense that a client connected to local database A can use a link stored in database A to access information in remote database B, but users connected to database B cannot use the same link to access data in database A. If local users on database B want to access data on database A, then they must define a link that is stored in the data dictionary of database B.
A database link connection allows local users to access data on a remote database. For this connection to occur, each database in the distributed system must have a unique global database name in the network domain. The global database name uniquely identifies a database server in a distributed system.


apakah ada RDBMS atau non-RDBMS yg memakai datalink selain oracle berdasarkan pengalaman agan2?

mohon info nya utk nambah pengetahuan emoticon-Big Grin
profile-picture
profile-picture
eternu5 dan nona212 memberi reputasi
Lihat 1 balasan
FEDERATED kan emang untuk akses data beda server.
The FEDERATED storage engine lets you access data from a remote MySQL database without using replication or cluster technology.

dulu(banget) pernah pake tapi hanya antar server dalam satu subnet LAN, gak bener-bener remote.
barusan iseng coba lagi mysql xampp(windows) ke mysql unix server, satu LAN juga, masih bisa ternyata.
Spoiler for ss hasil export struktur di xampp:
profile-picture
profile-picture
Kreamik dan eternu5 memberi reputasi
makasih gan, gw lupa kemarin gw dpt artikel dia ga bisa beda phisical server, btw jadi pilihan gw antara mysql dan oracle nih gan, makash ya,


GDP Network
© 2020 KASKUS, PT Darta Media Indonesia. All rights reserved
Ikuti KASKUS di