please help me in evaluating new possibilities with MS SQL Server 2008. For the last 3 years I have had an MS SQL 2000 Server Merge Replication with a Publisher and two Subscribers on duty, the backup of the database on one instance is as big as 19 GB. On each location data is inserted, updated and deleted. Everything works like a charm through a WAN with something like 10 mbit/s.
Now we change the platforms to win2008 and sql2008 and so arise new questions. The first: Is Peer-to-Peer replication a replacement for a merge-replication?
Update: In front of the answers, let me be more precise: We have on the publisher some tables which are not member of the replication. We also have more than one merge-replication on this database, a second separate one on some tables which were added later. (How many replicatons make sense; for each table her own replication?) There are no selections on a table so when a table is replicated all rows are delivered. Each table has an identity column. An additional Question: Are columns with type timestamp allowed with replication?