11/21/2024 3:50:37 PM
slxdeveloper.com
Now Live!
|
|
| |
| 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 32108 times
|
Rating:
 - 5.0 out of 5 by 9 users |
|
|
|
fiogf49gjkf0d
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
|
|
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
|
|
|
|
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]
|
|
|
- subject is missing.
- comment text is missing.
|
|
|
| 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 | |
|
| 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. | |
|
| 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.
| |
|
| 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:
| |
|
| 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 | |
|
| 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. | |
|
| 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...
|
|
|
|
|
|