Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Monday, June 17, 2024 
 
slxdeveloper.com Community Forums  
   
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!
 Administration Forums - Synchronization
Forum to discuss SalesLogix synchronization and remote database management. View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to Synchronization | New ThreadView:  Search:  
 Author  Thread: Synchronize individual table / deleted records - Help !
Nim
Posts: 2
 
Synchronize individual table / deleted records - Help !Your last visit to this thread was on 1/1/1970 12:00:00 AM
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 ?
[Reply][Quote]
Steve Robertson
Posts: 146
 
Re: Synchronize individual table / deleted records - Help !Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 08 Apr 09 2:57 AM
Nim,

Use the Administrator program and use the Execute SQL (Tools\Execute SQL..) function. You can execute SQL statements onthe Host and send them out to Remote users too.

Kind regards,

Steve
[Reply][Quote]
Steve Robertson
Posts: 146
 
Re: Synchronize individual table / deleted records - Help !Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 08 Apr 09 2:57 AM
Nim,

Use the Administrator program and use the Execute SQL (Tools\Execute SQL..) function. You can execute SQL statements on the Host and send them out to Remote users too.

Kind regards,

Steve
[Reply][Quote]
Nim
Posts: 2
 
Re: Synchronize individual table / deleted records - Help !Your last visit to this thread was on 1/1/1970 12:00:00 AM
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.
[Reply][Quote]
Phil Parkin
Posts: 819
Top 10 forum poster: 819 posts
 
Re: Synchronize individual table / deleted records - Help !Your last visit to this thread was on 1/1/1970 12:00:00 AM
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.
[Reply][Quote]
 Page 1 of 1 
  You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

   Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
 

 
 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 6/17/2024 2:40:16 PM