July 23, 2005 at 10:41 am
Hello,
I'm using a database on a server and another one on a server in another city. Both are production databases for retail stores. I need to see here every day, the sales data from the other store.
Normally, the merge replication works just fine, but a month ago, I had a communication problem that lasted for 3 weeks. When the problem was fixed, the replication began to work normally again, but replicated the data of the last 2 weeks. It didn´t replicated the information from the first week the communication was down.
Does anyone know how can I get this week of data?????
Thanks for your help.
July 24, 2005 at 6:50 am
Hi Brenda
I think you should change the status of the rows to ADDED.
To do this make a tempTable and copy the specified rows into it.
Then delete the specified rows from master table and insert the copied rows from temp table again like this :
INSERT INTO [masterTable] (field names ..., , ,) Values (SELECT * FROM tempTable)
Then to merge the specified data run replication .
this is just a quick way to you ...
Bye
Tooraj
July 25, 2005 at 10:41 am
Hi Tooraj,
You know what? It worked. I took your idea, but I tried updating the rows, without changing any data. Like this: update [table_name] set [field_name] = [field_name] where [condition]. I did this for the 3 most important tables.
It worked perfectly. Thanks a lot.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply