title: Multiple Publishers, Single Subscriber (Data Warehouse)
body: <p>I'm trying to figure out the best way to populated the staging database in a
  data warehouse.  I will have a number of databases (identical schema, SQL
  Server 2005 Standard).  Ideally I'd set up each as a publisher, with the
  same publication.  There will be a single subscriber database (SQL Server
  2005 Enterprise) that will subscribe to each of the publisher databases.
  Data in the publisher databases will be modified.  The subscriber database
  will only be updated by its subscriptions, and therefore does not need to
  send changes back to any of the publishers.  Publisher databases don't need
  to update each other.  Replication will be occurring over the internet
  (although VPN could be used).</p>
  
  <p>I'm
  not clear on what kind of replication I should be using for this. 
  Can I do it with replication? what about Incremental fields?</p>