Rather than have to query two separate databases on separate servers, I was thinking of somehow automatically replicating the table of data I need from one d/b to another on a weekly basis.
Can anyone advise as to the best way of achieving this?
More detail:
I have product information in one d/b and supplier information in another - both have to be kept separate (don't ask!!), but I'd rather not have to open a connection to both d/bs every time I need to select information. I though the best solution would be to combine the two using some form of automatic data copying routine, bringing one set of data over to the other d/b on a regular basis.
Can anyone advise as to the best way of achieving this?
More detail:
I have product information in one d/b and supplier information in another - both have to be kept separate (don't ask!!), but I'd rather not have to open a connection to both d/bs every time I need to select information. I though the best solution would be to combine the two using some form of automatic data copying routine, bringing one set of data over to the other d/b on a regular basis.
