Migrate / Restore from backup DB dump to SQL fails Follow
I was trying to migrage from HSLQ to OracleDB using maintaindb / migrate script (./maintainDB.sh migrate -T /home/test/.BuildServer/config/database.oracle.properties) ; During the process the script creates backup zip with database dump files.
However while trying import from the database dump the SQL database >>
The backup file contains tables that are unknown for the TeamCity core system:
usergroup_notification_events
users
db_version
canceled_info
remote_run_build_types
personal_build_relative_path
duplicate_diff
usergroup_roles
.........(list of all tables).....
These tables will not be restored. Most probably the tables were used by plugins and the plugin data will be lost.
Finishing
Restoring finished with warnings
Rendering all the tables empty..!!
Exactly same thing happens even while trying to import to database from database dumps that were created by "maintaindb backup -D" and restore using
maintaindb.sh restore -D -F /home/test/.BuildServer/backup/TeamCity_Backup_20100927_085427.zip -T /home/test/.BuildServer/config/database.oracle.properties
Please sign in to leave a comment.
Hello Ranjith,
which version of TeamCity software do you use?
What kind of OS - Unix-like one or Windows?
Could ypu please provide me with the 'teamcity-maintenance.log' files covered this case (both backup and restores actions)? could you please provide me also with the destination database properties file (without password, of course)?
Thank you,
Leonid
Do you solved this issue?
I have such error with migration to MSSQL 2008, will be very appreciate if you can help with it.
What is the version of your TC installation?
This problem can occur if you're using maintainDB version that is mismatch the version of your database when both versions less than 6.0.
Before TC 6.0, the maintainDB tool could work only with database which version is exactly same as the tool version.
What is the collation of your new database (where you're attempting to import data)?
Thanks,
Leonid
How can I check maintaindb version?
SQL_Latin1_General_CP1_CI_AS
same for tempdb
Sorry this is wrong, copy-pasted from old backup file.
Here is from latest backup:
Version: 6.5.1
Build number: 17834
Data format version: 454
It seems to me you're using migratedDB version 5.1.x for working with database version 6.0.x.
I would like to recommend you to download TeamCity 6.5.2, install it and then try to migrate/update.
Best regards,
Leonid
How can it be, if I updated TeamCity to version 6.5.1 yesterday?
But well, I’ll update TeamCity to 6.5.2 and then try to migrate again.
Thank you.
Two additional moments:
Best regards!
I has created backup from 6.5.1, has installed new 6.5.2 version into new folder and tried to restore 6.5.1 backup with maintaindb from new location. I've used database.properties configured to mssql and got the same error.
Any thoughts what's try next?