Post reply

DTS consequences

  • June 27, 2003 at 3:20 am

    #106768

    Hi 🙂

    I'm not sure whether this Q has been answered prior, I could not find any related thread here. So please don't kill me if 😉

    I'm new to DTS at all, just did a few tests on non-live systems.

    Now I need this functionality (Transactionreplication) to distribute a table from a source to two destination DB's. All servers run sqlsvr7sp3, and contain multiple DB's. No replication is configured so far.

    My question is, if I configure replication on the two destination systems for a newly set up DB, is there a possibility that this could cause the already existing DB's to change theire behavior in any way?

    I need to be sure on this 'cause I have no clue how the other DB's or the accessing software works. If I would break something ->

    thanks in advance 🙂

    is

    Edited by - infosukker on 06/27/2003 03:22:05 AM

  • June 27, 2003 at 4:05 am

    #463408

    Replication is enabled for specific databases and should not effect how the others operate. However, depending on push or pull an where the distributor is they can chnge the server loads which does effect overall performance.

    And DTS is not the same as replication although you can create a custom datamove similar to the concept of replication.

    Edited by - antares686 on 06/27/2003 04:05:44 AM

  • June 27, 2003 at 7:34 am

    #463461

    Thanks, I will try try to get this working. ...and to understand this feature 😉

    cheers

    is

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

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