| Subject | Re: [firebird-support] FB 2.5 backed-up DB cannot be restored, msg about Malformed String and "Use -FIX_FSS_DATA option." |
|---|---|
| Author | Dimitry Sibiryakov |
| Post date | 2018-02-20T15:47:18Z |
20.02.2018 16:36, dcoops@... [firebird-support] wrote:
ODS used in 2.0.1 allowed malformed string literals in stored objects and data tables,
ODS for 2.5 prohibit that.
If you see this error, it means that you'd better migrate database between version by
creation of brand new database from script and then pump data from old database. During
this process you'll encounter errors that you must fix by changing script or source database.
-FIX_* switches must be used very carefully by experienced DBA only. In wrong hands
they will lead to data corruption beyond recovery.
--
WBR, SD.
> I've Googled a lot about this and that -FIX_FSS_DATA option seems to only really beVersion of engine doesn't matter in this case. ODS does.
> relevant when restoring DBs from much earlier versions of FB - but this is from the same
> version!
ODS used in 2.0.1 allowed malformed string literals in stored objects and data tables,
ODS for 2.5 prohibit that.
If you see this error, it means that you'd better migrate database between version by
creation of brand new database from script and then pump data from old database. During
this process you'll encounter errors that you must fix by changing script or source database.
-FIX_* switches must be used very carefully by experienced DBA only. In wrong hands
they will lead to data corruption beyond recovery.
--
WBR, SD.