AuditWizard - Migration - Database Only
From Layton Support
(Difference between revisions)
m (Updated link) |
m (Updated link) |
||
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= |
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.