Proxy_Table…………….Amol P Ingle
Proxy tables
Proxy tables are the key to location transparency. A proxy table is a local table containing metadata which points to a remote object. The remote table is mapped to the proxy table to make it appear as if it were a local table.
If there are two servers such as Server A and Server B and user want to create proxy table from server A to Server B.
Then please do the following Steps:
In Server A:
1. Make the entry of interfaces file of server B into server A.
2. Add server sp_addserver “Server B”
3. Create one table in master/or any db for testing.
4. suppose create table amol.
5 Insert Values Into table amol
6. Check with the select command
1> select * from amol
2> go
name
--------------------
amol
Login into server B
1. Make the entry of interfaces file of server A into server B.
2. Add server sp_addserver “Server A”
3. Create table amol at "Server_A.db_name.dbo.amol"
go
4. Check with the select command
1> select * from amol
2> go
name
--------------------
amol
For
Proxy tables
Proxy tables are the key to location transparency. A proxy table is a local table containing metadata which points to a remote object. The remote table is mapped to the proxy table to make it appear as if it were a local table.
If there are two servers such as Server A and Server B and user want to create proxy table from server A to Server B.
Then please do the following Steps:
In Server A:
1. Make the entry of interfaces file of server B into server A.
2. Add server sp_addserver “Server B”
3. Create one table in master/or any db for testing.
4. suppose create table amol.
5 Insert Values Into table amol
6. Check with the select command
1> select * from amol
2> go
name
--------------------
amol
Login into server B
1. Make the entry of interfaces file of server A into server B.
2. Add server sp_addserver “Server A”
3. Create table amol at "Server_A.db_name.dbo.amol"
go
4. Check with the select command
1> select * from amol
2> go
name
--------------------
amol
For
Thank you so much for sharing your sybase experience to all of us with your easy to understand language....it helps me a lot
ReplyDelete