InterviewSolution
| 1. |
What is linked datastore? Explain with an example? |
|
Answer» There are various database vendors which only provides one way communication path from one database to another database. These paths are known as database links. In SQL Server, Linked server allows one way communication path from one database to other. Example − Consider a local database Server name “Product” stores database link to access information on remote database server called Customer. Now users that are connected to remote database server Customer can’t use the same link to access data in database server Product. User that are connected to “Customer” should have a separate link in data dictionary of the server to access the data in Product database server. This communication path between two databases are called database link and Datastores which are created between these linked database relationships is known as linked Datastores. There is a possibility to connect Datastore to another Datastore and importing an external database link as option of Datastore. |
|