11/22/2024 9:55:45 AM
|
| |
| 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 designing applications to work with SalesLogix. View the code of conduct for posting guidelines.
|
|
|
|
Stop tables appearing in Remotes
Posted: 10 Sep 09 8:28 AM
|
Hello,
I have a bit of a problem. We've created some "archive" tables to store old HISTORY records, mainly to improve performance of the main views etc. I've unchecked the box "synchronise with remotes" in the DB Manager, but they're still being put into the remote databases when I cut them. How do I stop this data synching out to remotes?
I can't even edit the DTS job, because of the silly way 2005 uses a graphical editor - all the SLX tables turn into 2px-square icons. |
|
|
|
Re: Stop tables appearing in Remotes
Posted: 10 Sep 09 9:00 AM
|
Forgot to mention, I've tried removing the table from SLX's DB manager, but that seems to make no difference.
The "Creating Databases" dialog even says the following yet still creates the table.
[10/09/2009 14:52:15] Warning : The table "history_archive_db" exists in the database but not in RESYNCTABLEDEFS and will not be copied. |
|
|
|
Re: Stop tables appearing in Remotes
Posted: 10 Sep 09 12:19 PM
|
It's a bit devious, but how about moving the archive tables to another database and then creating views in the host database which access the archive tables ...?
Then just the views will sync out ... maybe (not tried it). |
|
|
|
Re: Stop tables appearing in Remotes
Posted: 11 Sep 09 8:18 AM
|
Interesting idea - might give that a go.
It looks like SLX is creating ALL tables when cutting the remote, and only using that checkbox in the designer to determine what to send to the clients after that. The only exception is the HISTORY table, which it limits by date. Annoying!
The alternative I suppose is to let SLX create a HUGE remote when cutting, but then attach/truncate/shrink/detach the remote before rolling it out. |
|
|
|
Re: Stop tables appearing in Remotes
Posted: 11 Sep 09 1:20 PM
|
| Yeah, your alternative should work fine. All these methods feel like hacks though. The view idea, if it works, would take a bit more effort to set up, but would require less ongoing intervention ... |
|
|
|
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!
|
|
|
|
|
|
|
|