Knowledgebase: Softalk Share Server
HOW TO: Upgrade a JET driven Softalk Share Server database to use SQL Server Express 2008 R2

First ensure that Softalk Share Server application (executable or service) is not running. If Softalk Share Server is running as a Windows service then open the Services applet (in Control Panel >> Administrative Tools) and stop the Softalk Share Server service. If Softalk Share Server is running as an executable then right-click on the Softalk Share Server icon in the taskbar notification area and select Shutdown from the context menu.

It is strongly advisable that the JET database be compacted and repaired before moving to an SQL database.

To help reduce the future size of the SQL Express database you are moving to, it is possible to configure the Softalk Share Server to store messages and other binary data outside of the database and into the file system. The actual database itself will therefore reference this binary data and subsequently is able to keep the overall size of the database as small as possible.

You have the choice of either downloading SQL Express 2005 or SQL Express 2008 R2 shown below5 or SQL Express 2008 R2. A fundemental difference between the two versions is their capaciousness. More information on how to configure the system to store messages outside of the database and for capacity differences between SQL Express 2005 and 2008 can be found here as BlobsasReferences.

You should be able to pull down a copy of SQL Express 2008 R2 from either of the following locations:
http://www.microsoft.com/betaexperience/pd/SQLEXP08V2/enus/

The link below provide SQL Express 2008 R2 with the Management Tools packaged in.
http://www.microsoft.com/download/en/details.aspx?id=23650

We strongly advise pulling down the 32 bit version.

Part way through the installation you may be prompted to install product dependences such as .NET and/or Microsft Installer add-ins although the necessary links will be provided for you to easily install these required components. Upon installation of these add-ins, you may reboot the server at this point and re-run the original SQL Express installer and proceed until it has completed.

If during the installation you are asked whether you wish to install the SQL Management Studio (basic), please do so providing you have the necessary disk space availble. If you are not prompted for this, see details below for how to obtain this.

Re-run your Softalk product setup file and guide it to the database page as per your usual configuration. Choose to select the SQL Server database radio button and then check the Transfer existing data from JET to SQL checkbox and click next. You will need to select the correct SQL Server instance, usually SQL Server (SQLEXPRESS). On the database server page in the server combobox, type the computer name or IP address of your computer immediately followed with \SQLEXPRESS. So, for instance, if you computer is called SERVER then SERVER\SQLEXPRESS should be entered into the server combo box. Click next. If SQL server is installed correctly, then you should not be prompted for server credentials as the current user credentials should be used first and this should succeed. If you are prompted for credentials then please double-check the server-name and that MS-SQL Server Express is running. If you have to change the details, then you will need to restart setup for the changes to be effected.


DETAILS

If you wish to manage and maintain your database, then you may do so with SQL Management Studio Express. One of the pre-requisites for 2008 appears to be .NET 3.5 SP1 (specifically). This can be found here

Should you need Service Pack 3, this can be retrieved here

Alternatively, you may find you can access the managament tools from the installed SQL Server Installation Center. Please see this useful external link which provides a step-by-step instruction on installation and usage. Please see this link

(1 votes)
This article was helpful
This article was not helpful