SQL Server Performance

Change Data Type in Peer to Peer Transactional Replication

Discussion in 'SQL Server 2005 Replication' started by dhmdo20, Apr 10, 2008.

  1. dhmdo20 New Member

    Hello,
    I have 2 SQL 2005 servers setup in a Peer to Peer Transactional Replication. I am in the process of upgrading the in house code and need to make a change to a table data type. This table is part of the Peer to Peer Transactional Replication. What do I have to do before I can change this table date type? Thank you for your time and assistance.
    dhmdo20, Apr 10, 2008
    #2

  2. MohammedU New Member

    MohammedU, Apr 10, 2008
    #3

  3. dhmdo20 New Member

    Int to BigInt for non null columns
    dhmdo20, Apr 11, 2008
    #4

  4. satya Moderator

    Bear in mind if you have any SQL compact edition clients within this replication, they may fail and in this case you have re-initialize the subscription.
    satya, Apr 13, 2008
    #5

  5. dhmdo20 New Member

    We're a small SQL 2005 shop. All our SQL Clients for the replication are SQL 2005 Enterprise so this wont be an issue.
    dhmdo20, Apr 14, 2008
    #6

Share This Page