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


If you had originally chosen to install WorkgroupShare using a JET database and have since found that you have outgrown it, you can upgrade to either full MS-SQL Server (separate Microsoft licenses required), SQL Express 2005 or SQL Express 2008 R2. By following this procedure your original JET database will be preserved although it is always advisable to take a backup copy. Should you experience any problems and need to revert back to JET, you will likely just need edit the system DSN (Data source name) via ODBC to point back to your existing JET database.


The WorkgroupShare setup program does not currently recognize SQL Server Express 2008 R2 so you will need to download this manually from the links provided below. This article also explains how to work around the installer's current deficiency enabling you to use WorkgroupShare will SQL Express 2008 instead of SQL Express 2005 if that is your preferred option.


Firstly ensure that your WorkgroupShare application (executable or service) is not running. If originally installed as a Windows service open the 'Services' applet (in Control Panel >> Administrative Tools >> Services) and stop the WorkgroupShare service. If originally installed as an executable then right-click on the application 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 below. 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:

The link below provide SQL Express 2008 R2 with the Management Tools packaged in.

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.


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 this 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

Should you for any reason need to revert back to a JET database, please see: this link



  • All versions
(0 votes)
This article was helpful
This article was not helpful