Topic: Basis data migration security2.fdb-> security3.fdb at passage FB 2.1-> FB 2.5-> FB 3.0
There was at me a task of passage from version FB 2.1.3 on the last accessible version, FB 3.0.2 (both are installed on Windows Server 2003 R2). As intermediate I use FB 2.5.7, installed on the ordinary computer with Win 10 x64. All FireBird' are installed 64-digit.
Bases overtook using backup-restore from 2.1 in 2.5, then in 3.0. Problems were, but dared removal/editing of malformed data in bases. Bases earned in FB 3.0, all is.
Further it is required to transfer logins and passwords of users which are stored in security2.fdb (about 300 users)
Overtook basis using backup-restore on the server with FB 3.0 (in the test directory), it was connected by means of IBExpert, checked up that the data on a place and all looks as well as on 2.5 and 2.1
a subject at this forum, in it there was a message with a script
Then found how-to-migrate-copy-users-from-security2-fdb-firebird-2-5-to-security3-fdb
So understood this script it is intended for isql from a dial-up most FireBird, found the information on that how to launch this script, saved it in a file and adapted (corrected ways).
Checked up that the basis recovered by me security2.fdb has ODS=12.0
From the first did not quit since I specified working basis security3.fdb and received that there are no such rights at user SYSDBA, ungearing server FB (stopped service) copied basis in the test directory, launched service reversely, corrected a way to target basis security3.fdb, launched a script and thought that already everything, but are not present... Received an error:
SQL> input C:\DB\migration.sql;
Database: ' C:\DB\newsecurity3.fdb ', User: SYSDBA
Statement failed, SQLSTATE = 22001
arithmetic exception, numeric overflow, or string truncation
-string right truncation
-expected length 32, actual 96
-At block line: 56, col: 5
After line 3 in file C:\DB\migration.sql
Having a look that at me in bases through IBExpert saw a difference in the volumes which have been led out under the data, understood about what speech in an error
security2.fdb a screenshot
security3.fdb a screenshot
Respected, prompt as it is possible to quit this situation? I can something passed or I do not understand?