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:
.........(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.
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