The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Synchronize individual table / deleted records - Help !
Posted: 07 Apr 09 9:57 PM
|
I am new to Saleslogix and have a question regarding synchronization.
There were some incorrect records in the association table and i went
ahead and deleted the incorrect records throught he sql query analyzer.
Now the remote databases do not reflect the change.
I restored the database and used the scribe adapter to deleted the
records again from the table but i guess since the records were already
deleted no sync files were created.
How do i synchronize the table ? |
|
|
| |
| |
|
Re: Synchronize individual table / deleted records - Help !
Posted: 08 Apr 09 1:21 PM
|
Hi Steve,
Thank you for your reply. The deletion was done to synchronize our erp database with the crm association table. So to delete the records i will have to run a sql query using the linked server. Will this work on the clients ?
Regards,
Nim. |
|
|
|
Re: Synchronize individual table / deleted records - Help !
Posted: 08 Apr 09 10:27 PM
|
No it won't.
You'll need to somehow generate a list of the IDs to be deleted and then use Steve's suggestion:
DELETE FROM table
WHERE ID IN (ID1, ID2, ..., IDn)
You could generate the ID list by grabbing a backup of one of the remote dbs and running some SQL to compare it with the host db. |
|
|
|