informXL SQL Server Migration Summary
Updated: April 13, 2023
Applicable to: informXL Analyzer and informXL Datamart, versions 4.0 and higher
Access and Server Requirements:
- Microsoft Windows 10 / Windows Server 2012 or higher
- Access to SQL Server Management Studio
- Access to Microsoft® Excel 2016 or higher
- SQL login account with local SQL Server sysadmin rights. This will allow us to restore and configure the informXL objects within the new SQL Server instance.
Following the migration, we no longer require SQL Server sysadmin rights.
What is migrated:
Analyzer & Datamart databases
- informXL
- informXL_dm
What you do:
- Backup informXL databases from the legacy SQL Server instance
- Place copies of the .bak backup files in a folder accessible by our login account
If you are unable to perform the above steps, contact us and we can help!
What we do:
informXL Analyzer and Datamart
- Restore informXL databases on the new SQL Server
- Reset the informXL application login accounts
- Reconfigure informXL Analyzers to point to the new SQL Server
- Update any required SQL Server Agent Jobs
- Re-build any necessary indexes
- Test informXL Analyzer, refresh informXL Datamart
Documentation we provide: