We have a few tables and views in db1 defined like <db2 name>..<table name>. Both db1 and db2 are currently residing in same server. Now, we are planning to split db1 and db2 in separate servers. We are weighing on our options for creating Proxy Database Vs Proxy Tables.

Can any one list the pros and cons of Proxy Databases vs Proxy tables.

We are using Sybase ASE 15.7 ESD #2. We are planning to use the same sybase version in both the servers.

Appreciate quick clarification in this. Thanks in advance. Let me know if you need more details.