AuditWizard - Troubleshooting - Trouble Migrating SQL Compact Database to SQL Server
From Layton Support
(Difference between revisions)
m (Minor text changes) |
m (Minor text changes) |
||
Line 5: | Line 5: | ||
=Procedure= | =Procedure= | ||
+ | #Navigate to C:\Program Files (x86)\AuditWizard v8\db\. | ||
+ | #Copy ''aw_db.sdf'' elsewhere as a backup. This is the database file. | ||
#Run the '''[[AuditWizard - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard - New SQL Database|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. | #Run the '''[[AuditWizard - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard - New SQL Database|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. | #When AuditWizard restarts, quit. | ||
− | # | + | #Navigate to C:\Program Files (x86)\AuditWizard v8\. |
#Open ''AuditWizardv8.exe.config'' in NotePad. | #Open ''AuditWizardv8.exe.config'' in NotePad. | ||
#Find the string ''CompactDatabaseType''. | #Find the string ''CompactDatabaseType''. |
Latest revision as of 00:16, 24 September 2019
Contents |
[edit] Overview
If you can't migrate the built-in SQL Compact database to SQL Server without error, try this procedure.
[edit] Procedure
- Navigate to C:\Program Files (x86)\AuditWizard v8\db\.
- Copy aw_db.sdf elsewhere as a backup. This is the database file.
- 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.
- Navigate 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.