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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-26 : 07:30:22
|
| Rommel writes "Good Day.I want to ask help on sql replication. Here is the scenario:I have two SQL Servers each on separate pc, SQL1 (Win2k3) and SQL2 (Win2000). SQL1 replicates DB1 to SQL2 by transactional replication , publication pub1 contains articles tblheader and tbldetails, and other tables. On SQL2, the replicated database is named DBrep. The process is doing fine.On SQL2. I want to replicate tblheader and tbldetails on DBrep to a database in SQL2 named DBTransfer. SO i set up SQL2 to be a publisher, then using merge replication (can't use transactional because of OS). I included in the publication tblheader and tbldetails. The agent is working fine.when i update a data on tblheader on SQL1, SQL2 receives the changes on tblheader. But the merge agent seem to be not working, it doesn't replicate the changes made to tblheader in DBrep to tblheader in DBtransfer. But it replicates the changes if I manually edit some rows on tblheader on DBrep, it doesn't seem to detect changes made by SQl1 replication. Hope that anyone can help me on my problem. Or is there any other way that i can solve this.. Thank you very much." |
|
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2005-10-26 : 08:06:07
|
| Hi,[url]http://www.mssqlcity.com/Articles/Replic/troubleshooting_replication.htm[/url][url]http://www.sql-server-performance.com/q&a24.asp[/url][url]http://www.sql-server-performance.com/replication_tuning.asp[/url]And refer [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=56936[/url]HTH-----------------------------------------------------------MSSQL Server encryption software http://www.activecrypt.com |
 |
|
|
|
|
|
Problems on Replication