AuditWizard - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard
From Layton Support
(Difference between revisions)
(New section: "Creating a New SQL Database") |
(Added subsection "Determining Which Version of SQL is in Use") |
||
| Line 3: | Line 3: | ||
=Overview= | =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. | ||
| + | |||
| + | ===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= | =Procedures= | ||
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.
