Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
KingSexy182
Starting Member
7 Posts |
 Posted - 2003-10-09 : 23:20:32
|
| Hi every1,STATUS:Ive created a 1-WAY transactional replication, and instead of applying a snapshot (initialisation) I have backupped & restored the database (manually synchonisation - subscriber already has schema & data) as a subscribing database.Everything is working ok, I would just like to ask a few questions:1) Im not 100% sure that the Foreign Keys inherited from the publishing database will or will not cause unecessary prevention of data updates. ?DOES the Log Reader Agent mark the transactions in chronological order & apply it in that order? (If so, then I would not have any ISSUES with the FK Constraints) Im not sure in that regards, however i do know that the Distribution agent distributes the updates in chronological order 2) On the subscribing db, i changed the Foreign Keys so that it wont CHECK upon INSERT/UPDATES, however I cant change the option to 'NOT FOR REPLICATION'.?EVEN though, Ive set the FK as "NOCHECK", would the data validation or FK Constraint fire upon replication?--IM GUESSING 'YES'. Now if it is 'YES', this would lead me back to the first ISSUE.Please if u have an opinion or article on the issues that im encountering; I would thankful if u would reply.THANKS ALL |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-10 : 12:44:11
|
| Yes it is in chrnological order. If it wasn't, I suspect a lot of people wouldn't be able to use replication.Yes the foreign key will be checked with replication.It is always a good idea to test this stuff out though.SQL Profiler would help you out with question 1. Running a series of INSERTS/UPDATES would work for 2.Tara |
 |
|
|
KingSexy182
Starting Member
7 Posts |
Posted - 2003-10-12 : 19:33:43
|
| Thankyou Tara.I wasnt not entirely sure about how the LOG Reader Agent & how it organizes and applies the changes. |
|
|
|
|
|
|
Replication - FK Constraints