AuditWizard - Troubleshooting - Trouble Migrating SQL Compact Database to SQL Server

Back to Contents

Overview

If you can't migrate the built-in SQL Compact database to SQL Server without error, try this procedure.

Procedure

1. Navigate to C:\Program Files (x86)\AuditWizard v8\db\.
2. Copy aw_db.sdf elsewhere as a backup. This is the database file.
3. Run the Change Database Wizard to create a new SQL Server database called AuditWizard, without migrating data. This will give you a blank SQL Server database and will change AuditWizard's database connection to that SQL Server database.
4. When AuditWizard restarts, quit.
5. Navigate to C:\Program Files (x86)\AuditWizard v8\.
6. Open AuditWizardv8.exe.config in NotePad.
7. Find the string CompactDatabaseType.
8. Change the value of the key to True, i.e.
   
   <add key="CompactDatabaseType" value="True" />
   
   
9. Close and save the file. This changes the database connection back to the SQL Compact database.
10. Relaunch AuditWizard. The SQL Compact database will be the active connection.
11. Run the Change Database Wizard to migrate the data from SQL Compact to SQL Server. Note that instead of creating a new SQL Server database, you need to change the radio button to Connect to an existing database and choose the AuditWizard database from the menu.

Back to Contents