0. Download
Click here to download the current english version.
 
1. License information
SanDbMan is freeware. You may copy it, install it and use it as you want. You may not sell it, sell any modified version of it or sell any software containing it (in whatever functionality). You may modify it as long as you mark the modified versions as such and include this license information.
SanDbMan comes the way it is with no obligation for support, updates or anything else. There is no guarantee for it to work properly and no responsibility will be taken for whatever damage is being done by using it in whatever way.
If you like SanDbMan, we’d appreciate if you donate an amount of your choice to sales@sansoft.biz using Paypal (www.paypal.com). This will help us maintaining and supporting it in the future.
If you would like to sell SanDbMan, sell any modified version of it or sell any software containing it (in whatever functionality) please contact us at sales@sansoft.biz to obtain a valid business license.
SanDbMan is © 2004 by SanSoft (www.sansoft.biz)
 
2. General information
Most applications that process any kind of information use a database. The problem with databases is that they need to be installed, uninstalled and updated just like an application, but unlike for applications there are barely any tools providing these setup tasks for databases.
SanDbMan is a tool allowing average users to perform exactly these setup tasks for databases running on a Microsoft SQL Server or Microsoft SQL Server Desktop Engine. Database developers can easily configure and customize SanDbMan and thus create reliable and user friendly database releases. Have a look and if you like it, download it – SanDbMan is freeware!
 
3. Technical information
SanDbMan is a database setup wizard allowing average users to install, update, delete, backup and restore databases in a user friendly way. It has the same look and feel as most other setup wizards and doesn’t require any technical knowledge. It can be easily configured and customized by database developers and therefore is the perfect user interface for every database setup task.
SanDbMan supports the following 6 different setup tasks:
 
Task Name Description
1 Installation (Script) Installs a new database by executing SQL script files.
2 Installation (Restore) Installs a new database by restoring a backup file.
3 Restore Restores a backup file.
4 Backup Creates a backup file.
5 Delete Deletes a database.
6 Update Updates a database by executing SQL script files.
 
Database developers can define which of these setup tasks or, more precisely, how many variations of each one they want SanDbMan to offer. Each variation of a setup task is called a database action and can be assigned a separate custom name. For example, one possible configuration of SanDbMan could look about like this:
 
Action Task Name
1 Installation (Script) Install a new database version 3.
2 Update Update a database from version 2 to 3.
3 Update Update a database from version 1 to 3.
4 Delete Delete a database.
 
A user running SanDbMan would then have to select one of these four database actions. Every time SanDbMan is started, only one database action can be selected; of course it can be run as many times as desired.
Depending on what setup task the selected database action belongs to, SanDbMan will perform the following different wizard steps (the columns named 1 to 6 represent the different setup task numbers as specified above; the entry X means supported; the entry O means optional):
 
Step Description 1 2 3 4 5 6
Welcome Shows a welcome dialogue. X X X X X X
ReadMe Shows the content of an RTF file. O O O O O O
Action Asks the user to select a database action. X X X X X X
Server Asks the user to enter information to log on to the server. X X X X X X
Database Asks the user to enter a database name (1, 2, 3) or to select an existing database (4, 5, 6). X X X X X X
Backup Asks the user to enter the path and file name for the temporary file (2), the backup file to restore (3) or the backup file to create (4, 5, 6).   X X X O O
Ready Shows the information gathered so far and asks the user to confirm. X X X X X X
Progress Shows the progress of performing the current database action. X X X X X X
Finished Shows a dialogue indicating that the database action either succeeded, failed or was canceled. X X X X X X
 
Additionally database developers may specify a custom image file that SanDbMan will display on top of every dialogue and a custom RTF information file that will be displayed during the wizard step ReadMe.
 
Now what exactly do you have to do in order to create your database release with SanDbMan?
 
1. Write down which database actions you want SanDbMan to offer to your users.
2. Prepare the necessary script and backup files for your database installation and update actions.
 
Some notes on backup files:
  • They contain a snapshot of a database at a specific moment. Therefore they can be used for installation actions, but not for update actions.
  • They include the structure and data of a database.
  • They can be restored in one quick step.
  • They are relatively large in file size.
  • They can be generated (for example) by using the Enterprise Manager application which is part of the Microsoft SQL Client Tools. Just select a database and start the “Create Backup” function.
  •  
    Some notes on script files:
  • They contain a number of SQL commands that when executed generate a copy of a database or modify an existing database. Therefore they can be used for both installation and update actions.
  • They may include the structure and data of a database, but only the SQL commands for the structure can be generated automatically. Caution: Adding a large amount of data by script is not very effective!
  • They need to be executed and depending on the number and complexity of the contained SQL commands this might take a while (and may generate errors).
  • They are relatively small in file size.
  • They can be generated (for example) by using the Enterprise manager application which is part of the Microsoft SQL Client Tools. To generate an installation script just select a database and start the “Generate Script” function. Caution: Do NOT include the “Create Database” statement in scripts used with SanDbMan! To generate an update script open a diagram of a database, make the necessary modifications and before saving open the script dialogue. There you will find the respective SQL commands for the modifications you just made and can copy-paste them into a script file. To manually edit and test SQL commands you can use the Query Analyzer which is also part of the Microsoft SQL Client Tools. Caution: Writing SQL commands manually may become very time consuming!
  •  
    3. Optionally you may prepare an image file to be displayed on top of the wizard (size should be 500px wide and 70px high) and/or an RTF information file to be displayed during the wizard step ReadMe.
    4. Create a new folder and copy the files SanDbMan.exe and SanDbMan.config from the folder where you installed SanDbMan into this new folder. If you want SanDbMan to support German regional settings, also copy the subfolder de from the folder where you installed SanDbMan into this new folder. Then copy the necessary script and backup files (see point 2) and optionally the custom image and/or information file (see point 3) into the new folder. Finally, open the file SanDbMan.config in the new folder with an XML editor.
    5. To have a custom image file displayed, open the setting-node Banner and enter the respective filename as parameter. To have a custom information file displayed, open the setting-node ReadMe and enter the respective filename as parameter. Finally add an action-node for each of your database actions (see point 1) specifying the necessary parameters according to the following table (id can be any expression but must be unique; name can be any expression; type must be a setup task number from 1 to 6 as specified above; scriptfiles must be one or more filenames separated by a semicolon (;); backupfile must be a filename; the column Backup indicates whether the “Create Backup” option will be available at the wizard step Action):
     
    Task Required parameters Backup
    Installation (Script) id
    name
    type
    scriptfiles
    No
    Installation (Restore) id
    name
    type
    backupfile
    No
    Restore id
    name
    type
    No
    Backup id
    name
    type
    No
    Delete id
    name
    type
    Yes
    Update id
    name
    type
    scriptfiles
    Yes
     
    6. SanDbMan is now ready to perform the configured database actions. Before releasing it you should do some testing to make sure that everything is working the way you expect it.
    7. For the release you can simply give a copy of the folder with all files (see point 5) to your users and have them execute the file SanDbMan.exe. Another more elegant solution (especially when the release will be downloaded from the internet) is to create a self-extracting archive. This second solution is suggested, but not mandatory.
     
    Some notes on self-extracting archives:
  • They contain the folder and all files mentioned in point 5 in one compressed archive file.
  • They have the file ending exe and can be executed by any user. When executed, they unpack all contained files in a temporary folder, launch one of the unpacked files and delete the temporary folder after the launched file has terminated.
  • They can be customized.
  • They can be generated (for example) by using the WinZip Self-Extractor which can be downloaded for free at http://www.winzip.com and is easy to use. Just follow the wizard instructions.
  •  
    4. Setup information
    Simply download and run the SanDbMan setup file and follow the installation wizard. After the installation you can immediately test SanDbMan with the included demo configuration. In order to create your own database releases, follow the instructions at the technical information section.
     
    5. Error finding
    There is no error finding section yet, but you may send an email to support@sansoft.biz instead.
     
    6. FAQ
    There is no FAQ section yet, but you may send an email to support@sansoft.biz instead.
     
    7. Technical specification
    SanDbMan runs as a Windows Application and has been developed using C# under Visual Studio .NET 2003. It works as a database setup wizard and can be used for databases running on a Microsoft SQL Server or Microsoft SQL Server Desktop Engine.