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

    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.
  2. MohammedU New Member

  3. dhmdo20 New Member

    Int to BigInt for non null columns
  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.
  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.

Share This Page