Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Table Replication (localview problem)
Versions des environnements
Network:
Windows 2003 Server
Hello,
I have next problem. I need to make replication data from one table to another when new data appears in one of them.
I have 3 same database on diffrent locations. If "customerinfo" appears in one database - it must be replicated to rest 2
I try to make something like replication server. Separate database where 3 local view (one for each table) db1_view_customers , db2_view_cutomers, db3_viewcustomers...
Problem is.. when I open first view... rest use same database as first one! and not possible to update right table.
With remote view - its open correct table.. but not possible to update, because store procedre in database not supportable by odbc!
Need idea!
Thanks
Denis
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement