10/12/2009 7:32:13 AM permalink
Tuomas Posts 9	By default TypingMaster Intra uses an internal database to store all user data. However if you have lots of users and many teachers creating complex reports the internal database may slow down. In such a case we recommend using a separate database server such as MySQL or Microsoft SQL Server. These products offer better performance and improved data integrity. We have created a tool for migrating your data from the internal database to a separate server. This tool will dump the contents of the internal database into a standard sql dump file and allow you to migrate this data to a new SQL server. Please follow these steps to transfer your data to a new database: First stop your TypingMaster Intra server from the TypingMaster Intra Start -menu. Then download the database dump tool from here: http://download.typingmaster.com/misc/tmintra_db2sql.zip Unzip this package to the "webapps\tmintra\appdata" subfolder of your TypingMaster Intra installation folder. (Usually this is "C:\Program Files\tmintra\webapps\tmintra\appdata") Once you have done this, run the db2sql.bat This will create a dump.sql with all the data of the database as SQL INSERT commands. Now you will need to create a new database for TypingMaster Intra with the new database server you are going to use. Note: Most databases come with administrative tools that let you import SQL data from a dump file. If you have not installed these kinds of tools for your database, do so now. Create a database and a database user for TypingMaster Intra in your database server. Then create a database structure for the new database by running a database creation script which can be found in the "webapps\tmintra\appdata" subfolder. Open the following the script file which corresponds to your database server in a text editor. The files are as follows: MySQL: com.mysql.jdbc.Driver.sql Oracle: oracle.jdbc.OracleDriver.sql Other SQL databases: default.sql Internal HSQLDB database: internal.sql Now copy all rows except the last one (beginning with INSERT INTO) to the clipboard. Paste the copied CREATE TABLE commands to your database tool's SQL window and click on "Execute all commands" or similar. Once you have created the structure, import the data by importing the dump.sql file with your database tool. If your database tool does not support importing script/dump files you can try to copy and paste the contents of the file. However, you may have to do this in multiple steps because the file may be too big for the clipboard. Now that you have imported your data delete the custom_lmsconfig.properties from your "appdata" subfolder. This file has the old database settings stored. Now start the TypingMaster Intra server and go to the web address of your TypingMaster Intra. You will be taken to the setup screen. There enter in the information for your new database. If you have not downloaded a JDBC driver for your database, the setup will guide you in installing this. After you have entered your database information, you will be taken into the login screen, since the program will notice that your database has already been set up and is running. Now all your data is moved to the new server and you can log in normally to TypingMaster Intra. -- Best Regards, Tuomas T. TypingMaster Team
pages: 1

|