AuditWizard - Migration - Database Only
From Layton Support
(Difference between revisions)
(New page) |
m (Updated link) |
||
| (2 intermediate revisions by one user not shown) | |||
| Line 4: | Line 4: | ||
We highly recommend that you do not commit to the migrated installation until you are sure that the application is working without issues. | We highly recommend that you do not commit to the migrated installation until you are sure that the application is working without issues. | ||
| − | This procedure applies to SQL Server databases only. To migrate a SQL Compact database to SQL Server, follow '''[[ | + | This procedure applies to SQL Server databases only. To migrate a SQL Compact database to SQL Server, follow '''[[AuditWizard - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard - SQL Migration|these instructions]]'''. |
=Procedure= | =Procedure= | ||
#Back up your SQL Server database using Microsoft SQL Server Management Studio. | #Back up your SQL Server database using Microsoft SQL Server Management Studio. | ||
#Restore it to the new SQL Server. | #Restore it to the new SQL Server. | ||
| − | #Launch AuditWizard and run the '''[[ | + | #Launch AuditWizard and run the '''[[AuditWizard - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard - SQL Connection Change|Change Database Wizard]]''' to connect to the new SQL Server and database. |
<p align="right">[[File:btn_back_up.png|link=User Guide for AuditWizard]] [[User Guide for AuditWizard|<u>Back to Contents</u>]]</p> | <p align="right">[[File:btn_back_up.png|link=User Guide for AuditWizard]] [[User Guide for AuditWizard|<u>Back to Contents</u>]]</p> | ||
Latest revision as of 20:12, 9 January 2018
Contents |
[edit] Overview
We highly recommend that you do not commit to the migrated installation until you are sure that the application is working without issues.
This procedure applies to SQL Server databases only. To migrate a SQL Compact database to SQL Server, follow these instructions.
[edit] Procedure
- Back up your SQL Server database using Microsoft SQL Server Management Studio.
- Restore it to the new SQL Server.
- Launch AuditWizard and run the Change Database Wizard to connect to the new SQL Server and database.
