Upgrade Microsoft SQL Server (32 bit) to Microsoft SQL Server (64 bit)

Before you upgrade the Microsoft SQL Server, make sure that you have the following:

• A license file for the Symphony Server from the XNET
• The database name and instance name of the database

  You can find the database name and instance name in the Symphony setup wizard.
  
  

To upgrade from the Microsoft SQL Server (32 bit) to Microsoft SQL Server (64 bit), complete the following tasks:

1. Back up the database.

   You can use the Microsoft SQL Server Management Studio to detach and back up the Symphony database. For more information, see here.

   To back up the Symphony database using the command prompt, complete the following steps:

   1. Open the command prompt as an administrator.
   2. Run dbupdater “BACKUP DATABASE database_name TO DISK = 'C:\Temp\database_name.bak'”
      Where database_name is the name of your Symphony database. The default database name is aira.
      
      
      
2. Uninstall the Microsoft SQL Server (32 bit).

   On the computer that host the Microsoft SQL Server, complete the following steps:

   1. Open Apps and Features.
   2. Find the Microsoft SQL Server entry and click Uninstall.
      
   3. Click Remove.
      
   4. Select the instance and click Next.
      
      
   5. Select all features and click Next.
      
      
   6. Click Close.
      
      
      
3. Install the Symphony Server. After the installation is complete, you must run the setup wizard to configure the Symphony Server for the database restoration to be successful.

   During the setup, you must select the Microsoft SQL Server 2019 Express (64 bit) as the database provider.
   

   During the setup, type the password for the Microsoft SQL database. You should use the same password as the Symphony database you want to restore.
   
   

   To confirm that the Microsoft SQL Server 2019 Express (64 bit) installed correctly, complete the following steps:

   1. Open the command prompt as an administrator.
   2. Run dbupdater “SELECT @@VERSION”
      
      
      
4. Restore the database.

   You can use the Microsoft SQL Server Management Studio to restore the Symphony database. For more information, see here.

   To restore the Symphony database using the command prompt, complete the following steps:

   1. Open the command prompt as an administrator.
   2. Run dbupdater ”RESTORE DATABASE database_newname FROM DISK = 'c:\Temp\database_name.bak' WITH REPLACE”
      Where database_name is the name of your previous Symphony database and database_newname is the name that you will use for the restored database (you cannot use the same name for the restored database). 
      
      
   3. To confirm that the Symphony Server is reading the restored database, run sts
      
      
5. Run the setup wizard again to configure the Symphony Server to use the restored database.