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 |
|
dudi777
Starting Member
4 Posts |
 Posted - 2007-07-16 : 04:14:23
|
| Hello,I have 2 SQL Servers (let's say server A and server B ). On the A server, I have database 'Adb' from which I need data to be viewed on the WinCE device, but the database ('Bdb' - application DB, where merge replication is configured) is on the B server. After every event of replication agent success, I transfer data with DTS from server A to server B to refresh data to be viewed. I delete all records from these tables and fill them again. After this operation and next replication I receive tables with no data on the device (on the server there are some records) - even if I replicate again and again... This cause, that data on the server differs data on the device.Is it caused by using DTS for insert records to publicated tables? Maybe there is another way to do it better? |
|
|
dudi777
Starting Member
4 Posts |
Posted - 2007-07-16 : 10:03:48
|
| Ok, I found that replication doesn't treat DTS Copy Column action as an Insert... So the topic can be closed. |
 |
|
|
|
|
|
Lost data when merge replication with WinCE device