AuditWizard - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard

From Layton Support
(Difference between revisions)
Jump to: navigation, search
(Changed to a landing page. Previous contents moved to "Editing AuditWizard™ - Change Database Wizard - SQL Migration")
Line 2: Line 2:
 
This procedure is used any time you want to change to a different SQL Server database. Usually this would be when migrating from the embedded database to SQL Server.
 
This procedure is used any time you want to change to a different SQL Server database. Usually this would be when migrating from the embedded database to SQL Server.
  
−
<ol>
+
If you are migrating from the embedded database to SQL Server, [[Editing AuditWizard™ - Change Database Wizard - SQL Migration|see here for instructions]].
−
  <li>Go to Administration > General > Database Maintenance and click the Change Database button:<br><br>
+
−
  [[File:aw_change_db.png]]</li><br>
+
−
  <li>Click Next:<br><br>
+
−
  [[File:aw_change_db_02.png]]</li><br>
+
−
  <li>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><br>
+
−
  [[File:aw_change_db_03.png]]</li><br>
+
−
  <li>If you are migrating from the embedded database to SQL Server for the first time, click the ''Yes, migrate existing data to database'' radio button. Click Next:<br><br>
+
−
  [[File:aw_change_db_04.png]]</li><br>
+
−
  <li>Click Finish:<br><br>
+
−
  [[File:aw_change_db_05.png]]</li><br>
+
−
  <li>The database will be copied to SQL Server. Once done, this dialog will appear. Click OK:<br><br>
+
−
  [[File:aw_change_db_06.png]]</li><br>
+
−
</ol>
+
  
−
AuditWizard will restart and will now be connected to the newly created SQL Server database.
+
If you are changing your connection from one database to another, [[Editing AuditWizard™ - Change Database Wizard - SQL Connection Change|see here for instructions]].
 
<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 02:12, 3 November 2010

Btn back up.png Back to Contents

This procedure is used any time you want to change to a different SQL Server database. Usually this would be when migrating from the embedded database to SQL Server.

If you are migrating from the embedded database to SQL Server, see here for instructions.

If you are changing your connection from one database to another, see here for instructions.

Btn back up.png Back to Contents

Retrieved from "http://laytontechnology.com/support/index.php?title=AuditWizard_-_Using_AuditWizard_-_Administration_-_General_-_Database_Maintenance_-_Change_Database_Wizard&oldid=1482"
Personal tools
Namespaces

Variants
Actions
Main Page
Online User Guides
General Support
Release Notes
Toolbox