MyDump / Delphi 2006
Posted: Sat 22 Mar 2008 17:10
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
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