• State Not Answered
  • Replies replies
    2
  • Subscribers subscribers
    19
  • Views views
    88
  • Users 0 members are here

WebInspect DB server migration - Best practices for testing

meghsharma

Hi,

I am migrating the WebInspect DB server from a host which has reached EOL. Here's how I plan to test the migration:

1. Install MS SQL server 2019 on a test VM with new OS.

2. Migrate the data.

3. Point the Production WebInspect agents to the test DB instance.

4. Verify the latest jobs, and previous ones are available

5. Run a scan using the test db instance. Review the scan result with the previous production run

6. Point the WebInspect agent to the present production DB.

I am concern if step#5 could cause any issue when I point the WebInspect agent back to the production DB, considering that I have run a test job in it? Would greatly appreciate if someone could provide some feedback on the plan.

Thanks!

  • 0  

    Are you referring to the database for WebInspect standalone or one of the enterprise products? What version of WebInspect? Will the version of WebInspect be the same post migration? If the WI version doesn't change post migration, there shouldn't be any issues. Please ensure you have a backup of your database before performing any of these actions.

    I'm also concerned you mentioned multiple WI agents to the same database.

  • 0 in reply to   

    Thanks for your response.

    I am using a standalone WebInspect  21.1 instance , 2 agents ,  2 databases hosted on a single instance of MS SQL Server 2012(which is already EOL).

    I plan to upgrade WI version to 24.2 but that will be done after the DB has been upgraded.

    We are going to upgrade to MS SQL Server 2019.

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.