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

From Layton Support
(Difference between revisions)
Jump to: navigation, search
m (Updated links)
(Added subsection "Determining Which Version of SQL is in Use")
 
(10 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.
  
If you are migrating from the embedded database to SQL Server, [[AuditWizard™ - Change Database Wizard - SQL Migration|see here for instructions]].
+
==Determining Which Version of SQL is in Use==
 +
#Go to '''[[AuditWizard - Using AuditWizard - Administration - General - Database Maintenance|Administration > General > Database Maintenance]]'''.
 +
#The database you are currently connected to appears in the ''Change Database'' panel. It will be either SQL Compact or SQL Server.
  
If you are changing your connection from one database to another, [[AuditWizard™ - Change Database Wizard - SQL Connection Change|see here for instructions]].
+
===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