Sybase Replication Quick HELP!!

~

Replication Server is Sybase's multiplatform system for distributing data over networks and maintaining server synchronization. Replication Server increases the flexibility and lowers the costs of managing multiple data management platforms. Sybase RepServer can replicate data across Sybase databases to Sybase/MS SQL databases, Sybase database tables to Any RDBMS scema tables - vice versa, and also from Any RDBMS schema tables to Any RDBMS schema tables.

Replication can improve your data infrastructure:

· High availability – Sales associates, branch offices, chain retail locations and more are able to exchange and share data from point-of-sale applications through regional and district offices to the corporate level and back again.

· Highly distributed – Consider sales and service companies where users are disconnected during the day but need to update orders/inventories and other information automatically after normal working hours. Advantage Replication provides an easy solution when data must be highly distributed.

· Offline Reporting or Data Warehousing – Moving data from production servers to reporting servers removes the processing loads of complex reports or data mining operations from production environments. Increase the speed and efficiencies of reporting without impacting day-to-day operations.

It's not so easy to start with Replication as it involves multiple Servers/Databases, but little Querying would give you overview and once you got the flow/architecture you can tune in.

You should know the ID Server (The 1st Replication Server installed on the System) and the ASE of the RepServer RSSD to start understanding the replication topology. you can use following T-SQL to start with. Many DBAs have doubts to know what kind of replication is in their environment (like W/S, MSA or table).

Query the RSSD to get info:

To find all the Replication Server names:

select id, name from rs_sites

To find all the warm standby databases in the replication including the Server name:

select distinct dsname, dbname from rs_databases

where ltype='L'

To find all the table-level/MSA databases in the replication including the Server name:

select distinct dsname, dbname from rs_databases

where ltype='P'

To find all the database repdefs list:

select dsname, dbname,dbrepname from rs_dbreps rd, rs_databases rs

where rs.dbid=rd.dbid

order by dsname, dbname

To find all the table repdefs list:

select dsname, dbname, objname, phys_tablename,deliver_as_name from rs_objects ro, rs_databases rd

where ro.dbid=rd.dbid

order by dsname, dbname

To find all the subscriptions list:

select dsname, dbname,subname from rs_subscriptions rs, rs_databases rd

where rs.dbid=rd.dbid

order by dsname, dbname

I hope with this information you can identify the replication flow and also type. Keep replicating this stuff too...

Thank you all..

Your Qs and Tips are highly appreciated and welcome...

~