| Author |
Replication to another independent database
|
|
| Juraj Nevesely 2005-07-28, 7:23 am |
| Hello
Is it possible to replicate a table(s) from one database to another
database, which contains completly different data except for that table(s)?
For your imagination - it would act as an order interchange system between
two companies, where these tables are automatically replicated if order is
made.
Is this concept technically possible or do you have a better solution how to
get data into a remote database automatically without weed of export-import?
Thank you.
| |
| Dmitri 2005-07-28, 7:23 am |
| Juraj Nevesely wrote:
> Is it possible to replicate a table(s) from one database to another
> database, which contains completly different data except for that table(s)?
Yes.
Dmitri.
| |
| Juraj Nevesely 2005-07-28, 7:23 am |
| Thank you, Dmitri. I suppose it needs some tricky techniques to get it work.
Can somebody suggest me how to get data from consolidated database to
another one (which already exists) and make it replicate?
The databases run on ASA 8.0.3.
Thank you.
"Dmitri" <NOdimSPAM@mail15.com> napisal v sprave
news:42e8b1d0@forums
-1-dub...
> Juraj Nevesely wrote:
>
>
> Yes.
>
> Dmitri.
| |
| Dmitri 2005-07-28, 7:23 am |
| Juraj Nevesely wrote:
> I suppose it needs some tricky techniques to get it work.
I don't think so. If a table that is going to be replicated has the same
definition in both databases then SQL Remote should work fine (from the
replication standpoint, everything outside of tables participating in
replication doesn't exist). With Mobilink, you can replicate even across
databases from different vendors having different schemas.
> Can somebody suggest me how to get data from consolidated database to
> another one (which already exists) and make it replicate?
There are tutorials in ASA User Guide for both SQL Remote and Mobilink -
have you tried them?
Dmitri.
| |
| Raymond Kwong 2005-07-28, 8:23 pm |
| Can you elaborate on what "if order is made" mean? Is it reflected in
the value of a column? Or some sort of join logic which can be
represented by WHERE conditions in articles?
On 28 Jul 2005 02:13:38 -0700, "Juraj Nevesely" <arieli@funradio.sk>
wrote:
>Hello
>Is it possible to replicate a table(s) from one database to another
>database, which contains completly different data except for that table(s)?
>For your imagination - it would act as an order interchange system between
>two companies, where these tables are automatically replicated if order is
>made.
>Is this concept technically possible or do you have a better solution how to
>get data into a remote database automatically without weed of export-import?
>Thank you.
>
|
|
|
|