How to upgrade from v7.x (estimate 30 min.)
- License key is upgraded
- The database is upgraded
- The management console is upgraded
- Sign.exe is upgraded
How to upgrade the license key
Forward your license key to firstname.lastname@example.org, and we'll return your upgraded license key and download instructions.
With current software maintenance your license key is upgraded without any cost.
How to upgrade the SQL database
Upgrading your database does not mean that you need to upgrade from e.g. SQL Server 2005 to 2012, but only means that you need an updated database schema as the software develops over time and with all the new and planned benefits you need more space to contain the required information. This means that only new tables are added as well as new fields within your tables.
Special considerations for SQL Server 2012:
Please note that you need to take this into consideration when upgrading to SQL 2012:
Microsoft MSDN article: Save (Not Permitted) Dialog Box.
No matter which version you are running now, we can supply you with a script that will do the database upgrade for you.
And even better - you generate the script yourself! To generate your own update script please follow these guidelines carefully:
Download emailsignatureschema.zip and extract the two files to one directory (e.g. c:\temp):
- Open the admin console and retrieve the connection string to the your database. Remove the part containing "Provider=sqloledb;".
Example: - Your connection string is:
Provider=sqloledb;Data Source=SQLSERVER1;Initial Catalog=emailsignature;User Id=emailsignature_superuser;Password=changemenow;
Use only this part:
Data Source=SQLSERVER1;Initial Catalog=emailsignature;User Id=emailsignature_superuser;Password=changemenow;
- Open a command prompt and navigate to the directory where you unzipped the two files to. Then run this command:
dbschemaupdater.exe /c:"Data Source=SQLSERVER1;Initial Catalog=emailsignature;User Id=emailsignature_superuser;Password=changemenow;"
Note! Remember to replace with your own connection string and keep '/c' in lower case.
- This generates a file in your folder called script.sql. This file is your database upgrade script.
- Open SQL Server Management Studio and log on. Select your database (which is called 'eMailSignature' per default).
Run your upgrade script and your database is now successfully upgraded.
How to upgrade Sign.exe
Copy Sign.exe file from the install folder to your NETLOGON share - or wherever you execute it:
C:\Program Files (x86)\eMailSignature\Sign.exe
You have now upgraded successfully, and users will update the Status Monitor when they execute Sign.exe.
Activate the upgraded database with your upgraded license key
Open the admin console > Configuration, copy/paste your upgraded license key:
You have now upgraded successfully, and users will update the Status Monitor when they logon to the domain.
How to verify upgrade OK
The console and Status Monitor show latest version.