AuditWizard - Migration - Database Only
From Layton Support
(Difference between revisions)
m (Jpainter moved page AuditWizard™ - Migration - Database Only to AuditWizard - Migration - Database Only: Removed the TM symbol for a cleaner URL) |
m (Updated link) |
||
| Line 9: | Line 9: | ||
#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> | ||
Revision as of 20:11, 9 January 2018
Contents |
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.
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.
