# property file to be used by TeamCity database migration tool # Review and comment/uncomment necssary options, specify values. # You can enable debug logging during migration in Log4J configuration file (conf\teamcity-server-log4j.xml) #--------------------------------- # Source database properties #--------------------------------- # Internal TeamCity database sourceDriver=org.hsqldb.jdbcDriver sourceURL=jdbc:hsqldb:file:C:/Documents and Settings/Administrator.SMSDEV/.BuildServer/system/buildserver sourceUser=sa sourcePassword='' # Internal TeamCity database running in standalone mode # Starting HSQLDB in standalone mode: java -Xmx512M -cp \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://[:]/ #targetUser= #targetPassword= # 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= # MSSQL 2005 via jTDS targetDriver=net.sourceforge.jtds.jdbc.Driver targetURL=jdbc:jtds:sqlserver://smsbuild2.smsdev.local/TeamCity;instance=SQLEXPRESS targetUser=TeamCityUser targetPassword=asdfjkl;