5/22/2025 7:26:32 PM
|
| |
| 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!
Forum to discuss general T-SQL questions and help with queries related to SalesLogix data. View the code of conduct for posting guidelines.
|
|
|
|
How to recover a deleted account
Posted: 05 Dec 07 10:09 PM
|
| I need to recover an account that was deleted with all of the associated records. I restored a backup with the latest data, and I am able to insert the records one table at a time. I saw some other posts that looped through table associations. Does anybody have a utility that will recover a deleted account and all associated tables? |
|
|
|
Re: How to recover a deleted account
Posted: 06 Dec 07 11:07 AM
|
| I personally don't have a utility to do this - I have written SQL like you have, and then I just kept the SQL in a separate file. Any time I need to move a deleted account over from a backup, I just find the account ID in the backup, add it to my script, and then I run the script through. This doesn't take into account remotes, but I can fortunately run it on my remote office database as well due to a giant LAN setup. You can create a utility pretty easily by creating a new form in SalesLogix that takes in parameters on the database name and which record to move back over, and then you can grab the information by creating your own connection string that hooks up directly to SQL Server, and you can run all your scripts that way. |
|
|
|
Re: How to recover a deleted account
Posted: 06 Dec 07 12:37 PM
|
There is a SLX utility in programfiles\saleslogix\GroupCopy.exe that I used for moving data between Borland, SQL Server, and Oracle many years ago. Someone told me to try it here, and it worked great. Once I found the deleted records in a backup, I created a group with the deleted accounts. Then I used the GroupCopy utility to move the deleted records back to production. After trying it out on a test copy first of course. The nice thing about this utility is that it also found all of the records in custom 1:1 and 1:many tables.  |
|
|
| |
|
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!
|
|
|
|
|
|
|
|