Manter duas bases sincronizadas
22/03/2006
0
Gandalf.nho
Posts
22/03/2006
Edilcimar
22/03/2006
Aroldo Zanela
Se eu entendi, o cara pode digitar em ambos e depois quer também que as informações digitada em cada um esteja nos dois.
Pensei em criar uma coluna para identificar a origem (filtro) e outra para identificar o registro.
Algo assim:
+----Filtro | Tabela A ------------------------------V---------- 001213123131545465464654546465465465454A0000000001 646487979646463131315646131316461313212A0000000002 +----Filtro | Tabela B ------------------------------V---------- 649794646464564979846464987946464646487B0000000001 649794646464564979835464975138564646487B0000000002 649797979879654654646464987946464646487B0000000003 649794646464565464646498876413134646487B0000000004 631354646465464979846464987946464646487B0000000004 149794646464564979846464645646464646487B0000000005 649794645146646464656464987946464646487B0000000006 131313156464564979846464987946464646487B0000000007 ^ ^ | | +--------+--- Chave no arquivo +---------+--- Chave de sincronização Sincronizando A c/ B | | V V 001213123131545465464654546465465465454A0000000001 646487979646463131315646131316461313212A0000000002 649794646464564979846464987946464646487B0000000001 649794646464564979835464975138564646487B0000000002 649797979879654654646464987946464646487B0000000003 649794646464565464646498876413134646487B0000000004 631354646465464979846464987946464646487B0000000004 149794646464564979846464645646464646487B0000000005 649794645146646464656464987946464646487B0000000006 131313156464564979846464987946464646487B0000000007 Sincronizando b c/ a 649794646464564979846464987946464646487B0000000001 649794646464564979835464975138564646487B0000000002 649797979879654654646464987946464646487B0000000003 649794646464565464646498876413134646487B0000000004 631354646465464979846464987946464646487B0000000004 149794646464564979846464645646464646487B0000000005 649794645146646464656464987946464646487B0000000006 131313156464564979846464987946464646487B0000000007 001213123131545465464654546465465465454A0000000001 646487979646463131315646131316461313212A0000000002
22/03/2006
Gandalf.nho
22/03/2006
Marcio.theis
Clique aqui para fazer login e interagir na Comunidade :)