Undo a Conversion - The Database Update Framework

If you have made a conversion from Embedded (.dat) to SQL of one or more tables with the framework and you want to "undo" these changes to be able to run the conversion again, here's what you can do;

Note: Remember that the following will only work if you left your original .dat files intact.

1.Delete the SQL tables you have converted with the framework with an SQL back-end tool like the Microsoft SQL Management Studio.

2.Compile and run the framework's DbUpdateFrameworkTests program. On the fourth tab-page titled "Utility Functions", see the bottom-most group titled "Remove Database Identifications". You can drag & drop a filelist.cfg on to that group. As you have made a conversion with the framework from embedded to SQL your filelist.cfg will contain references to the SQL tables. When you press the "GO" button all of those references will be removed, making the filelist.cfg point to your .dat files again.

3.Start DbExplorer and reset the DbVersion table value back to its previous value - which may be zero. (Else the conversion won't be run again).

4.Run the conversion again by starting your program which will convert from embedded to SQL.