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

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. Go to Administration > General > Database Maintenance and click the Change Database button:
   
   


2. Click Next:
   
   


3. 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:
   
   


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


5. Click Finish:
   
   


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

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

Back