Chris,
We're not talking about a deployed system so I haven't set it up to do anything yet. What I have now is 2 completely separate client (one VB other ASP) applications sharing "one" MSSQL DB that'll need to be separated at deployment.

If you're asking if the updates on both DB needs to merge, of course (at least once a day if not more frequently). That's the architectural question I want some suggestions to. How can I set this up so that the replication between the two DB is as seamless as possible? Thanks.

>Is there any replication between the two databases? In other words, if records are updated on the subset database, do they at some point get merged to the main database?