Upgrading SQL Server database schemas
For most versions of WorldServer, you can upgrade SQL Server databases on the database server machine only one version at a time. For example, you cannot upgrade directly from version 10.4.3 to 11.0.1; you have to upgrade from version 10.4.3 to version 10.4.4 first, then you can jump from version 10.4.4 to version 11.0.0, and only then can you upgrade from version 11.0.0 to version 11.0.1. Always take into account the versions of the available upgrade scripts before planning your upgrade.
Before you begin
- Make sure you selected Mixed Mode Authentication when installing SQL Server.
- Make sure you have a database for the WorldServer version you want to upgrade from. For example, if you want to upgrade from version 10.4.3, make sure you have a 10.4.3 database. The name of the database must not start with a number.
- Perform the following procedure with the sa user and select SQL Server Authentication from the Authentication list when you log in to Microsoft SQL Server Management Studio.
- If you want to use the System Monitor tool, run the following command: GRANT VIEW SERVER STATE TO <user name>, where <user name> is the name of the database user.
By doing so, you are giving the user READ rights on the following tables:
- sys.dm_tran_locks
- sys.dm_os_waiting_tasks
- sys.partitions
- sys.dm_exec_requests
- sys.dm_exec_sessions
- sys.databases
- sys.dm_exec_connections
- sys.dm_exec_query_stats
Procedure
Results
What to do next
Validate your upgrade. Make sure you have finished running all the database upgrade scripts before you test your upgrade with the testschema script.