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

From Layton Support
(Difference between revisions)
Jump to: navigation, search
(Added subsection "Determining Which Version of SQL is in Use")
 
(12 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
<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>
 +
__FORCETOC__
 +
=Overview=
 
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>
+
==Determining Which Version of SQL is in Use==
  <li>Go to Administration > General > Database Maintenance and click the Change Database button:<br><br>
+
#Go to '''[[AuditWizard - Using AuditWizard - Administration - General - Database Maintenance|Administration > General > Database Maintenance]]'''.
  [[File:aw_change_db.png]]</li><br>
+
#The database you are currently connected to appears in the ''Change Database'' panel. It will be either SQL Compact or SQL Server.
  <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.
+
===SQL Compact===
 +
The embedded SQL Compact Edition 3.5 database that all AuditWizard installations begin with.
 +
 
 +
    C:\Program Files\AuditWizard v8\db\aw_db.sdf
 +
 
 +
===SQL Server===
 +
If a SQL Server database is connected, you will see a SQL Server version and the SQL Server name.
 +
 
 +
    You are currently connected to : SQL Server XXX.X.XXXX.X
 +
    Data source : SERVER\INSTANCE, Database : AuditWizard
 +
 
 +
=Procedures=
 +
=='''[[AuditWizard - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard - SQL Migration|Migrating from Built-in (SQL Compact) Database to SQL Server]]'''==
 +
If you are migrating from the embedded SQL Compact Edition (CE) database to SQL Server, '''[[AuditWizard - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard - SQL Migration|click here for instructions]]'''.
 +
 
 +
=='''[[AuditWizard - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard - SQL Connection Change|Migrating from SQL Server to SQL Server]]'''==
 +
If you are connecting to an existing SQL Server database, '''[[AuditWizard - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard - SQL Connection Change|click here for instructions]]'''.
 +
 
 +
=='''[[AuditWizard - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard - New SQL Database|Creating a New SQL Database]]'''==
 +
If you are creating a new SQL Server database, for testing or starting anew, '''[[AuditWizard - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard - New SQL Database|click 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>

Latest revision as of 23:40, 19 January 2020

Btn back up.png Back to Contents

Contents

[edit] Overview

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.

[edit] Determining Which Version of SQL is in Use

  1. Go to Administration > General > Database Maintenance.
  2. The database you are currently connected to appears in the Change Database panel. It will be either SQL Compact or SQL Server.

[edit] SQL Compact

The embedded SQL Compact Edition 3.5 database that all AuditWizard installations begin with.

   C:\Program Files\AuditWizard v8\db\aw_db.sdf

[edit] SQL Server

If a SQL Server database is connected, you will see a SQL Server version and the SQL Server name.

   You are currently connected to : SQL Server XXX.X.XXXX.X
   Data source : SERVER\INSTANCE, Database : AuditWizard

[edit] Procedures

[edit] Migrating from Built-in (SQL Compact) Database to SQL Server

If you are migrating from the embedded SQL Compact Edition (CE) database to SQL Server, click here for instructions.

[edit] Migrating from SQL Server to SQL Server

If you are connecting to an existing SQL Server database, click here for instructions.

[edit] Creating a New SQL Database

If you are creating a new SQL Server database, for testing or starting anew, click here for instructions.

Btn back up.png Back to Contents

Personal tools
Namespaces

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