Migration HSQL --> MySQL creates targets tables, but doesn't insert data

We are running TeamCity Professional Version 3.1.1 (build 6828) on a Linux box. We have been using the default HSQL server, and are migrating in-full to MySQL 5.0.51a. The migration tool creates the target tables, but does not populate them with data.

I ran the migration tool's "preserve" option. The resulting directory contained the following:


How does the data get migrated?

Thanks,
Steve
-


Contents of sourceSchema.sql:

3 comments

Steve,

Please check that the source database is configured properly in the dbMigration.properties file.

What is the content of the file in your case?
Where is TeamCity datat directory (.BuildServer) is located?

Please also note the full migration tool log.

--
Best regards,

Yegor Yarko
Project Manager
JetBrains, Inc
http://www.jetbrains.com
"Develop with pleasure!"

0

The .BuildServer directory is named /local/.../TeamCity. This directory is configured in teamcity-server.sh:


dbMigration.properties (with sensitive fields obscured):

\WEB-INF\lib\hsqldb.jar org.hsqldb.Server -database.0 \buildserver -dbname.0 buildserver
#sourceDriver=org.hsqldb.jdbcDriver
#sourceURL=jdbc:hsqldb:hsql://localhost/buildserver
#sourceUser=sa
#sourcePassword=''

#---------------------------------
# Target database properties
#---------------------------------

# MySQL
# do not forget to place MySQL driver (mysql-connector-java-*.jar) into \WEB-INF\lib directory
targetDriver=com.mysql.jdbc.Driver
targetURL=jdbc:mysql://MACHINE_RUNNING_MYSQL:3306/NEW_SCHEMA
targetUser=teamcity
targetPassword=xxxxxx

# PostgreSQL
#targetDriver=org.postgresql.Driver
#targetURL=jdbc:postgresql://[:]/
#targetUser=
#targetPassword=

# Oracle
# do not forget to place Oracle driver (ojdbc*.jar) into \WEB-INF\lib directory
#targetDriver=oracle.jdbc.driver.OracleDriver
#targetURL=jdbc:oracle:thin:@::
#targetUser=
#targetPassword=
]]>

0

Steve,


You should probably try to specify
sourceURL=jdbc:hsqldb:file:/local/xxxxxx/TeamCity/system/buildserver
in the dbMigration.properties

What messages do you have as migrateDB.sh output?

--
Best regards,

Yegor Yarko
Project Manager
JetBrains, Inc
http://www.jetbrains.com
"Develop with pleasure!"

0

Please sign in to leave a comment.