AuditWizard - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard - SQL Migration
From Layton Support
(Difference between revisions)
m (moved - SQL MigrationAuditWizard™ - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard - SQL Migration to [[AuditWizard™ - Using AuditWizard - Administration - General - Database Maintenance - Change Datab) |
m (Updated numbered-list style) |
||
| Line 3: | Line 3: | ||
This procedure uses the migration feature to copy the data from the embedded database to SQL Server. | This procedure uses the migration feature to copy the data from the embedded database to SQL Server. | ||
| − | + | #Go to ''Administration > General > Database Maintenance'' and click the ''Change Database'' button:<br><p>[[File:aw_change_db.png]]<br></p> | |
| − | + | #Click Next:<br><p>[[File:aw_change_db_02.png]]<br></p> | |
| − | + | #Click the ''Create a new database'' radio button. Click the browse button next to the Server Name field and select your SQL Server name. The database name ''AuditWizard'' will be entered by default. Click Next:<br><p>[[File:aw_change_db_03.png]]<br></p> | |
| − | + | #Click the ''Yes, migrate existing data to database'' radio button. Click Next:<br><p>[[File:aw_change_db_04.png]]<br></p> | |
| − | + | #Click Finish:<br><p>[[File:aw_change_db_05.png]]<br></p> | |
| − | + | #The database will be copied to SQL Server. Once done, this dialog will appear. Click OK:<br><p>[[File:aw_change_db_06.png]]<br></p> | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | </ | + | |
AuditWizard will restart and will now be connected to the newly created SQL Server database. | AuditWizard will restart and will now be connected to the newly created SQL Server database. | ||
<p align="right">[[File:btn_back_up.png|link=AuditWizard™ - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard]] [[AuditWizard™ - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard|<u>Back</u>]]</p> | <p align="right">[[File:btn_back_up.png|link=AuditWizard™ - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard]] [[AuditWizard™ - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard|<u>Back</u>]]</p> | ||
Revision as of 00:56, 10 February 2015
This procedure uses the migration feature to copy the data from the embedded database to SQL Server.
- Go to Administration > General > Database Maintenance and click the Change Database button:
- Click Next:
- Click the Create a new database radio button. Click the browse button next to the Server Name field and select your SQL Server name. The database name AuditWizard will be entered by default. Click Next:
- Click the Yes, migrate existing data to database radio button. Click Next:
- Click Finish:
- The database will be copied to SQL Server. Once done, this dialog will appear. Click OK:
AuditWizard will restart and will now be connected to the newly created SQL Server database.
