Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Friday, January 18, 2019 
 
Quick DB Setup - Quickly setup new SalesLogix Databases  
Description:  Does anyone else get sick of the hoops you have to jump through to get an unattached slx database mdf or backup file to the state where it can actually be logged into by a sales client? Well I sure was, so I built this nifty utility.

Category:  Utilities
Author:  Nathan Baulch
Submitted:  2/20/2004
   
Stats: 
Article has been read 29414 times

Rating: - 5.0 out of 5 by 9 users
 

fiogf49gjkf0d
Quick DB Setup - Quickly setup new SalesLogix Databases

Does anyone else get sick of the hoops you have to jump through to get an unattached slx database mdf or backup file to the state where it can actually be logged into by a sales client?

Well I sure was, so I built this nifty utility.



Simply specify an unattached mdf or a backup file, give it a name and Quick DB Setup will:

  • Copy it locally if the file is on the network.
  • Restore or attach the file into the default data directory.
  • Perform the sysdba fix.
  • Blank the admin password (and restart the SLX Server if necessary).
  • Add an SLX Server alias.
  • Set the pingserver and pingport.
  • Add a client data link.
  • Make that data link the current.
As per usual, all comments/suggestions/bug reports welcome.

Nato


 Click here to download the utility

.NET Framework required
 

About the Author

Nathan Baulch


fiogf49gjkf0d
Music: Amon Tobin, Shpongle, Boards of Canada
Activities: Snow Boarding, Weights, Cycling
Hobbies: Software, Digital Electronics, Indian Food
Languages: Java, C#, VB.net, C++


View online profile for Nathan Baulch
 

[ back to top] [ send to a friend]  

Rate This Article you must log-in to rate articles. [login here] 
 
Please log in to rate article.
 

Comments & Discussion you must log-in to add comments. [login here] 
 
Author Article Comments and Discussion
Ryan Farley

slxdeveloper.com Site Administrator
slxdeveloper.com Forum Top 10 Poster!

Re: Quick DB Setup - Quickly setup new SalesLogix Databases
Posted: 3/8/2004 10:43:00 AM
fiogf49gjkf0d
Nathan,

I assume that this utility just uses the local default instance of SQL, right? So with that being the case, you have to run this on the SQL server itself. Would this cause any problems if you do not have the SLX server installed or even the SLX provider for that matter on that same box?

Also, this does not give you any way to specify which SQL instance you want to restore to. That would be a great addition to the app. Is there any possibility of doing that now? (ie: specify which instance?)

Thanks, Ryan
 
Nathan Baulch
 

Re: Quick DB Setup - Quickly setup new SalesLogix Databases
Posted: 3/17/2004 1:28:32 AM
fiogf49gjkf0d
The reason why you can't select an arbitrary SQL Server on your network is because the backup/detached file must be on a disk on the server’s local machine. The attach and restore commands do not support UNC file locations.
To get it to work, you would either need to have a domain admin password and write to C$ on the server or somehow find a writable/deletable share on the server machine and detect its corresponding local location.

As for your second suggestion, it has been added to the TODO list, as follows:
- Fix a spelling error in the create DataLink code.
- Handle database in use when dropping.
- Restore from a local active database.
- Stop button.
- Specify an SQL Server instance if multiple exist.
 
William Key
 

Re: Quick DB Setup - Quickly setup new SalesLogix Databases
Posted: 1/29/2005 9:16:01 AM
fiogf49gjkf0d
Great job with this utility. One feature you might want to add is a tbSYSDBAPassword value for the sysdba password in your .XML setting file.

I am going to install your utility on a USB pen drive to setup 60 training DB’s for a client. Being able to default the sysdba password (and running it automatically from a command line switch) would make the process a little faster. None the less, thank you for sharing your utility, great job! It is going to make the job much easier.
 
Mike Pawlowski
 

Re: Quick DB Setup - Quickly setup new SalesLogix Databases
Posted: 5/5/2005 11:54:44 AM
fiogf49gjkf0d
I love this utility, and use it all the time. Is there a version for 6.2 databases? Currently I can only use the "Create Server Alias" and "Create Data Link" features for 6.1 databases.

A couple of suggestions for a new version:
 
Mike Pawlowski
 

Re: Quick DB Setup - Quickly setup new SalesLogix Databases
Posted: 5/5/2005 11:58:26 AM
fiogf49gjkf0d
1- Add a checkbox for deleting the syncserver logging path. Nine times out of ten, when I'm attaching customer databases to my own server, I need to destroy sync. It'd be nice to be able to do this here.

2- A database version selection, so that I can use it for 6.1 or 6.2 databases
 
Steve Dyson
 

Re: Quick DB Setup - Quickly setup new SalesLogix Databases
Posted: 7/14/2005 1:52:19 PM
fiogf49gjkf0d
is this only for 6.1, or can i use for 5.2.
 
Ryan Farley

slxdeveloper.com Site Administrator
slxdeveloper.com Forum Top 10 Poster!

Re: Quick DB Setup - Quickly setup new SalesLogix Databases
Posted: 7/18/2005 4:39:52 PM
fiogf49gjkf0d
Steve,

It only works for v6, v5.x uses BDE alias and things get quite a bit different there.

-Ryan
 
 

       Visit the slxdeveloper.com Community Forums!
Not finding the information you need here? Try the forums! Get help from others in the community, share your expertise, get what you need from the slxdeveloper.com community. Go to the forums...
 



 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2019 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): 1/18/2019 2:33:21 AM