MyDAC ver. 4.40.025 / Delphi 2006
Using MyDump to restore a previous backup failes sometime when restoring views.
It seams that having a view with a name in sort order before then table using it, generates an error.
Example:
Table name is Test and viewname is atest. View "atest" generates view from table "Test".
During restoring I get an exception saying that "Test" not exists, and that must be because table "Test" not yet has been restoret/created.
From the backup file I have tried to move all "create views.." to the end of the document, and then it works correct.
Is there any solution do get around this problem.
Jan