HQRIO Relsease Deployment - BBCWiki/IPos-Internal GitHub Wiki

How to Release HQRIO

To release the latest version of HQRIO, follow these steps:

  1. Access the Remote Desktop Connection:

    • Connect to the IP address: 10.5.6.156.
  2. Open Visual Studio:

    • Launch Visual Studio once connected to the remote desktop.
  3. Get the Latest Version of HQRIO:

    • Ensure you have the latest version of the HQRIO.
  4. Use Schema Compare:

    • In Visual Studio, use the Schema Compare tool with the following connection string:
      10.5.6.156,1433.HQRIO
      
  5. Perform the Comparison:

    • Click the Compare button located in the top left corner.
  6. Update the Database:

    • After the comparison has finished, press the Update button.
  7. Verify the Update:

    • Check the console to confirm that the update has completed successfully.

How to Deploy HQRIO

To deploy HQRIO, follow these steps:

  1. Connect to SQL Server:

    • Use SQL Server 2012 to connect to the following:
      10.5.6.156,1433
      
    • Username: ipos
    • Password: Use the default password for SQL.
  2. Search for HQRIO Database:

    • Locate the HQRIO database in the SQL Server.
  3. Create a Backup:

    • Create a backup of the HQRIO database using the following format:
      HQRIOyyyymmdd
      
  4. Restore the Backup:

    • Restore the backup to your desired location.