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

From Layton Support
(Difference between revisions)
Jump to: navigation, search
m (Updated link)
m (Implemented new numbered-list format)
Line 2: Line 2:
 
This procedure is used any time you want to change the connection to a different SQL Server database, without copying data, which would be done in a [[AuditWizard™ - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard - SQL Migration|migration]]. Once migrated to SQL Server, you can't go back to SQL Compact, but you can change the connection to different AuditWizard SQL Databases.
 
This procedure is used any time you want to change the connection to a different SQL Server database, without copying data, which would be done in a [[AuditWizard™ - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard - SQL Migration|migration]]. Once migrated to SQL Server, you can't go back to SQL Compact, but you can change the connection to different AuditWizard SQL Databases.
  
−
<ol>
+
#You may have been sent a database by Layton Technology that has been upgraded from the embedded database (Compact) or version 7. If you haven't done so already, restore the database to your SQL Server. We suggest that you use the default database name ''AuditWizard''. If your database has been upgraded by us, it may have a different name.
−
  <li>You may have been sent a database by Layton Technology that has been upgraded from the embedded database (Compact) or version 7. If you haven't done so already, restore the database to your SQL Server. We suggest that you use the default database name ''AuditWizard''. If your database has been upgraded by us, it may have a different name.</li>
+
#Go to Administration > General > Database Maintenance and click the Change Database button:<br><p>[[File:aw_change_db.png]]<br /></p>
−
  <li>Go to Administration > General > Database Maintenance and click the Change Database button:<br><br>
+
#Click Next:<br><p>[[File:aw_change_db_02.png]]<br /></p>
−
  [[File:aw_change_db.png]]</li><br>
+
#Click the ''Connect to an existing database'' radio button. Click the browse button next to the Server Name field and select your SQL Server name. Choose the database name. Click Next:<br><p>[[File:aw_change_db_conn_03.png]]<br /></p>
−
  <li>Click Next:<br><br>
+
#Click the ''No, do not migrate data'' radio button. Click Next:<br><p>[[File:aw_change_db_conn_04.png]]<br /></p>
−
  [[File:aw_change_db_02.png]]</li><br>
+
#Click Finish:<br><p>[[File:aw_change_db_05.png]]<br /></p>
−
  <li>Click the ''Connect to an existing database'' radio button. Click the browse button next to the Server Name field and select your SQL Server name. Choose the database name. Click Next:<br><br>
+
#The new database connection setting will be saved. Once done, this dialog will appear. Click OK:<br><p>[[File:aw_change_db_06.png]]</p>
−
  [[File:aw_change_db_conn_03.png]]</li><br>
+
−
  <li>Click the ''No, do not migrate data'' radio button. Click Next:<br><br>
+
−
  [[File:aw_change_db_conn_04.png]]</li><br>
+
−
  <li>Click Finish:<br><br>
+
−
  [[File:aw_change_db_05.png]]</li><br>
+
−
  <li>The new database connection setting will be saved. 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 SQL Server database.
 
AuditWizard will restart and will now be connected to the SQL Server database.
 
<p align="right">[[File:btn_back_up.png|link=AuditWizard™ - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard]] [[AuditWizard™ - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard|<u>Back</u>]]</p>
 
<p align="right">[[File:btn_back_up.png|link=AuditWizard™ - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard]] [[AuditWizard™ - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard|<u>Back</u>]]</p>

Revision as of 05:28, 15 May 2015

Btn back up.png Back

This procedure is used any time you want to change the connection to a different SQL Server database, without copying data, which would be done in a migration. Once migrated to SQL Server, you can't go back to SQL Compact, but you can change the connection to different AuditWizard SQL Databases.

  1. You may have been sent a database by Layton Technology that has been upgraded from the embedded database (Compact) or version 7. If you haven't done so already, restore the database to your SQL Server. We suggest that you use the default database name AuditWizard. If your database has been upgraded by us, it may have a different name.
  2. Go to Administration > General > Database Maintenance and click the Change Database button:

    Aw change db.png

  3. Click Next:

    Aw change db 02.png

  4. Click the Connect to an existing database radio button. Click the browse button next to the Server Name field and select your SQL Server name. Choose the database name. Click Next:

    Aw change db conn 03.png

  5. Click the No, do not migrate data radio button. Click Next:

    Aw change db conn 04.png

  6. Click Finish:

    Aw change db 05.png

  7. The new database connection setting will be saved. Once done, this dialog will appear. Click OK:

    Aw change db 06.png

AuditWizard will restart and will now be connected to the SQL Server database.

Btn back up.png Back

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

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