Multimaster replication confusion!

Hello all,

Okay, so here's my dilemma:

I have 5 databases--let's call them A, B, C, D, and E--that have distinct data (schemaA, schemaB...). I am trying to "consolidate" all of my data into a new, single database, F, and then propogate THAT data (F.schemaA, F.schemaB...) out to 10 or 15 workstations, so that each has a local copy of the data the other applications (Databases A-E) are affecting.

So, what I did was:

I created database F, and rolled up the schema from the original five servers (F.schemaF) onto it. Now, for my test environment, I wanted to have each of the first five servers, as well as the new, sixth server, able to share all of that data. But, when I tried to set-up Multi-master Replication (via Enterprise Manager), I was only able to push the schema (F.schemaF) from my "Master Site" (F) to the other five databases.

The problem is, I want to make schemas F.schemaA, F.schemaB, etc., but right now, I have F.schemaF, A.schemaF, B.schemaF, etc. In other words, I would have to re-write my applications to allow them to write to, and read from, <machine>.schemaF!

I know this sounds like it should be pretty elementary, but the Wizard doesn't seem to allow me to make F.schemaA...F.schemaE, only to create a NEW schema which holds the replicated objects. I have RTFM'd over the past two days, and still nothing...so I thought that I would beseech all of you.

Thanks for the read...and thanks in advance for any insight!

Regards,

Julius Cooper Received on Thu Jun 02 2005 - 14:39:16 CDT