Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004
    Posts
    1

    Exclamation Unanswered: Sql Server Replication

    Hi everybody
    I would like to ask a question, maybe stupid. I've got a sql server database and i would like to implement replication. First of all i would like to know if there's any special requirements that my database must meet before implementing replication. All of my tables got a column named "ID" wich is an int 4, identity. Can i implement replication without making any changes to my database ?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I suppose that depends on which kind of replication and what you consider changes.

    Transactional replication requires a defined primary key, so that might require an ALTER TABLE command to provide one. As long as your ID values are unique, that constitutes "administrivia" in my book, not a significant change.

    Snapshot replication requires very little. You could probably do that and only change system tables within your database.

    I guess the short answer boils down to the ever popular: It depends.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •