Post reply

Is there any way to setup Transsaction replication without running the first snapshot

  • April 28, 2005 at 1:22 pm

    #92948

    Is there any way to setup Transsaction replication without running the first snapshot?

    --snt

  • April 28, 2005 at 1:51 pm

    #555686

    If the subscriber already has the schema and data correctly you could specify that option when setting up through the gui.

    If you are concerned with table locking then you could always go with a concurrent snapshot.


    Shamless self promotion - read my blog http://sirsql.net

  • April 29, 2005 at 1:11 am

    #555789

    I had a problem with replication. When I was using transactional replication from SQL to oracle and one of these servers go down or restarts, the replication agent needs to restart. At this time, it tries to recreate the temp table MSSQL7 something. As it already exists it throws error and replication stops. Here, manual intervention is needed to delete this table and also replication reference is broken due to this deletion of the table.

    Have you done anything like this or troubleshooted such issue?

  • April 29, 2005 at 5:26 am

    #555841

    Sorry, I've no experience with replicating data to Oracle.


    Shamless self promotion - read my blog http://sirsql.net

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply