AuditWizard - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard
From Layton Support
(Difference between revisions)
(Added subsection "Determining Which Version of SQL is in Use") |
|||
| (5 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. | ||
| − | + | ==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 | + | ===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
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
- Go to 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.
[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.
