Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Download Apelon Docker project
git clone https://bitbucket.org/opencds/apelon-docker.git 
Get into apelon-docker folder and download apelon-dts-3.5.2.203-linux-mysql.tar.gz
cd apelon-docker
wget http://sourceforge.net/projects/apelon-dts/files/dts-linux/3.5.2/apelon-dts-3.5.2.203-linux-mysql.tar.gz

If you need to transfer content from another database you can place your dts_dump_file.sql file in apelon-docker folder and uncomment the lines that refer to dts_dump_file.sql on Dockerfile and config_mysql.sh. 

Dockerfile, dts_dump_file.sql
# Set up MySQL
ADD dts_dump_file.sql /dts_dump_file.sql
ADD config_mysql.sh /config_mysql.sh
RUN chmod 755 /config_mysql.sh
RUN /config_mysql.sh; rm config_mysql.sh 
RUN rm dts_dump_file.sql
ADD my.cnf /etc/my.cnf
config_mysql.sh, dts_dump_dile.sql
__start_mysql() {
echo "Running the start_mysql function."
mysqladmin -u root password mysqlPassword
mysql -uroot -pmysqlPassword -e "CREATE SCHEMA IF NOT EXISTS dts DEFAULT CHARACTER SET latin1 COLLATE latin1_bin;"
mysql -uroot -pmysqlPassword -e "CREATE USER 'dts'@'localhost' IDENTIFIED BY 'dts';"
mysql -uroot -pmysqlPassword -e "GRANT ALL PRIVILEGES ON dts.* TO 'dts'@'localhost' WITH GRANT OPTION;"
mysql -uroot -pmysqlPassword -e "FLUSH PRIVILEGES;"
mysql -uroot -pmysqlPassword dts < /dts_dump_file.sql
killall mysqld
sleep 10
}

 

References

ApelonDTS 

http://apelon-dts.sourceforge.net/ 

Migrate MS-SQL apelon tontent to MySQL

http://salrod.blogspot.co.uk/2015/02/migrate-ms-sql-apelon-content-to-mysql.html

  • No labels