I need little guidance.
I am having a requirement in which I have to replicate the data of 1 DB into the other DB.
For example, Let say we have two DB's(A&B). So, If I create a table in DB A then it should be automatically created in DB B.
ok, 1 more thing..I am going through the link which you have shared. Here they have used the term "standby". So, I just wanted to know In Replication will both DB's will be online..I mean whether user will be able to access both the DB's?
My first question on reading your post was what are your plans with this replicated database? Do you want a standby? Do you want the multiple versions of your database active for use?
By your last question, sounds like you want both active for some reason. With both active, do you want changes from B reflected in A as well? Also, you just mention DDL being replicated from A to B. What about DML?
Be a little more descriptive about what you are wanting to do with replication and we can offer better options/advice.