Responisibilities of Sybase Replication Server

[crazYoga]

• Move data from one source to another.
• Move only a subset of data from source to destination. So, you can ‘subscribe’ to a subset of data, or a subset of the columns, in the source table, e.g. select * from clients where state = ‘NY’
• Manipulation/transformation of data when moving from source to destination. E.g. it can map data from a data-type in DB2 to an equivalent in Sybase.
• Provide a warm-standby system. Can be incorporated with Open Switch to provide a fairly seamless fail-over environment.
• Merge data from several source databases into one destination database (could be for a warehouse type environment for example).
• Move data through a complicated network down to branch offices, say, only sending the relevant data to each branch.