We have database with several big tables which are core of our system. Everyhing is in one DB at moment, which I’ll call Core DB. We’re working on separating messaging subsystem to separate Msg DB, which will be connected to Core DB using replication. On Msg DB we would need to have some data from one of biggest tables in Core DB. That means that in Msg DB, from that big table, we would need to have only some fields and only records that satisfy certain conditions.
Standard replication doesn’t support this scenario.
Does anyone have any experience and suggestion on how to implement this?
Thank you in advance!