Banks, credit unions, insurance companies,
|Question||How do I migrate the Reporting databases to another MS SQL Server instance of a downgraded version?|
|Answer||There are a few options to downgrade the database from a higher version of SQL Server to a lower version of SQL Server. These options include:
- Configure product to the destination SQL Server , create product database and upload all historical data to it from the local repository folder with the Netwrix Auditor DB Importer tool (can be found in the product installation folder, by default: C:\Program Files (x86)\Netwrix\Active Directory Auditing );
- Migrate database with Generate Scripts wizard of SQL Server Management Studio. For it please perform the following steps:
1. Script the schema of the database on the source SQL Server instance using the Generate Scripts wizard of the SQL Server Management Studio interface.
1.1 In Object Explorer connect to the SQL server, right-click database, expand Tasks and choose“Generate Scripts…”.
1.7 After reviewing your selections on the Summary page, click Next to generate scripts.
2.1 In Object Explorer connect to the destination SQL Server instance and then in SQL Server Management Studio open the SQL Server script you saved in Step-1.