AuditWizard - Troubleshooting - Trouble Migrating SQL Compact Database to SQL Server
From Layton Support
(Difference between revisions)
(New Page) |
m (Minor text changes) |
||
Line 8: | Line 8: | ||
#When AuditWizard restarts, quit. | #When AuditWizard restarts, quit. | ||
#Go to C:\Program Files (x86)\AuditWizard v8\. | #Go to C:\Program Files (x86)\AuditWizard v8\. | ||
− | #Open '' | + | #Open ''AuditWizardv8.exe.config'' in NotePad. |
#Find the string ''CompactDatabaseType''. | #Find the string ''CompactDatabaseType''. | ||
#Change the value of the key to ''True'', i.e.<br /><br /><code><add key="CompactDatabaseType" value="True" /></code><br /><br /> | #Change the value of the key to ''True'', i.e.<br /><br /><code><add key="CompactDatabaseType" value="True" /></code><br /><br /> |
Revision as of 00:07, 24 September 2019
Contents |
Overview
If you can't migrate the built-in SQL Compact database to SQL Server without error, try this procedure.
Procedure
- 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.
- When AuditWizard restarts, quit.
- Go to C:\Program Files (x86)\AuditWizard v8\.
- Open AuditWizardv8.exe.config in NotePad.
- Find the string CompactDatabaseType.
- Change the value of the key to True, i.e.
<add key="CompactDatabaseType" value="True" />
- Close and save the file. This changes the database connection back to the SQL Compact database.
- Relaunch AuditWizard. The SQL Compact database will be the active connection.
- 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.