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 ?
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.