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 - Database Administration
Forum to discuss SQL Server or Oracle database administration related to SalesLogix databases. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Database Administration | New Thread

View: Search:

Author

Thread: Creating Remote Office Database

Patricia Capuz
Posts: 49

Creating Remote Office Database Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 11 Dec 07 7:41 PM

I have installed a Remote office but I saw that the store procedures didn't create from Main office Database...

Why....????

Could anybody help me???

Patty

[Reply][Quote]

Jeff Weight
Posts: 219

Re: Creating Remote Office Database Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 13 Dec 07 10:21 AM

On this one, you can't be helped. SalesLogix does not support custom stored procedures at all. However, you could create a large SQL script that will setup all the stored procedures on the remote office, and run that anytime you have to reinstall the remote office. I do have a set of scripts I have to run every time I create a remote office.

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Creating Remote Office Database Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 16 Dec 07 12:07 PM

Quote:

Originally posted by Patricia Capuz

I have installed a Remote office but I saw that the store procedures didn't create from Main office Database...

Why....????

Could anybody help me???

Patty

Never has... not even in the latest version(s) (v7.2.1) Stored procedures are not "supported" since they are below teh provider and cannot generated TEFS.. therefore any changes to data they make will NOY sync.
--
rjl

[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 \|

page cache (param): 11/25/2024 4:54:36 PM