Re: Subscribing to a Transactional Publication


"Sheldon" <Sheldon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F74DC31A-CB80-4399-8A29-434A4628D835@xxxxxxxxxxxxxxxx
Hello -

I have a database table [TableA] that continuously has information
inserted
into it. That information is never changed.

I need to create another database containing [TableB] on another server
(ServerB) that continously takes the information from [TableA] on ServerA.

[TableB] needs to be updateable, but TableB will never be used to update
[TableA].

I think what I need for [TableB] is a subscription to a Transaction
Publication [TableA], but I'm not sure.

Can someone let me know if there is a better choice to make in this
scenario?

And how does this relate to VB? I'm guessing I'm just missing something.

--
Mike
Microsoft MVP Visual Basic



.

Relevant Pages

  • Re: Query with mathematics criteria!!?? Help!
    ... I might not even add the new record to the database if it doesn't ... > Create a Cartesian join query by adding TableA and TableB to the query ...
    (microsoft.public.access.queries)
  • Re: Cursors (again)
    ... What does it matter if TableB is temporary? ... or tableA. ... open cTableB ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL: Working with huge tables of chronological data
    ... TableB is ~30 millions row and contains (timestamp, ... from tableA TA1 left outer join tableB TB on (TA1.timestamp < ... that portion of the plan was executed. ...
    (comp.databases.oracle.server)
  • Re: Dazed and Confused
    ... related to the records in TableB, *and* how EACH record in TableB is related ... to the records in TableA. ... Purchase Order Details Table to a Purchase Order Table ... Junction table to the Purchase Requisition table. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: SQL: Working with huge tables of chronological data
    ... TableB is ~30 millions row and contains (timestamp, ... from tableA TA1 left outer join tableB TB on (TA1.timestamp < ... the predicate information for ID 9 come from? ...
    (comp.databases.oracle.server)
Loading