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!

Architect Forums - Legacy Development
Forum to discuss SalesLogix legacy development including views, scripts, etc.. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Legacy Development | New Thread

View: Search:

Author

Thread: SLXRemote

Ian Fitzpatrick
Posts: 146

SLXRemote Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 28 Jun 06 5:12 PM

I am looking to install than one remote database on my computer (I support multiple SalesLogix implementations) and I was wondering if this is possible. Every time I try to attach a new remote DB it writes over my old one even if I rename it after I attach it, does anyone have any experience with this? I'm also on version 5.2.

Thanks!

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: SLXRemote Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 28 Jun 06 5:22 PM

You don't have to use the AttachRemote utility to attach a remote database. You can do it all manually, after all, it is just performing SQL commands that you yourself can execute and provide your own names for things.

However, a simple route to take is to use the "\admin" switch with the AttachRemote utility. This will allow you to type in your own value for the database name avoiding overwriting an existing database.

[Reply][Quote]

Mike Spragg
Posts: 1226

Re: SLXRemote Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 29 Jun 06 3:59 AM

Although, beware, you can't have a full remote environment on your machine - as the paths are hardcoded for sync purposes. You can, as Ryan says, attach the DB but you shouldn't attempt to sync multiple remotes.

[Reply][Quote]

Mike Spragg
Posts: 1226

Re: SLXRemote Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 29 Jun 06 3:59 AM

Of course, that should have said "... multiple full remotes...."

[Reply][Quote]

Jeremy Brayton
Posts: 491

Re: SLXRemote Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 30 Jun 06 11:09 AM

Beware with the \admin switch. It attaches the DB from wherever you specify it, so if you're anal like me and want all of this in the Microsoft SQL Server\Data\ directory then you're going to have to move it there first.

I believe without the admin switch it tries to copy the file there, but that may be ONLY for 6.2. For a long time I simply copied the files over and ran the utility even though a batch script using the osql.exe commands would have worked just as easily.

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: SLXRemote Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 30 Jun 06 11:19 AM

Quote:

Originally posted by Jeremy Brayton

For a long time I simply copied the files over and ran the utility even though a batch script using the osql.exe commands would have worked just as easily.

That is the way I do it too. Honestly, I can't say I have ever used the Attach Remote utility.

[Reply][Quote]

Frank Chaffin
Posts: 475

Re: SLXRemote Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 30 Jun 06 5:27 PM

Quote:

Originally posted by Jeremy Brayton

Beware with the \admin switch. It attaches the DB from wherever you specify it, so if you're anal like me and want all of this in the Microsoft SQL Server\Data\ directory then you're going to have to move it there first.

I believe without the admin switch it tries to copy the file there, but that may be ONLY for 6.2.

You are correct on both counts.

I use AttachRemote with the \admin switch all the time. It works great. BTW, you can also detach an existing database first if needed.

[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 8:48:23 AM