3,086
edits
Changes
no edit summary
Please always use your database servers tool to import and export. So for example if you move the NoTouch Center database from an older MS SQL server to a newer version on a different server, properly export it on the old one using the Microsoft SQL Server tools and and import it on the new one. Make sure user account, password and privileges are intact on the new system as well.
NoTouch Center does not officially support cross-migration from Oracle to MS SQL or vice-versa (there may be third-party tools though), but you can migrate both formats to MySQL. In fact, this is done automatically, if you [[migrate standalone NoTouch Center into Virtual Appliance]]. There are command line tools you can use (at your own risk!) - unsupported. The command line tools "dbimport" and "dbexport" are located in the installation directory of NoTouch Center. * On Windows systems this is C:\Program Files\Stratodesk\NoTouch Center\lmc* On a [[Stratodesk Virtual Appliance]] it is /opt/center
== Exporting the database to a NoTouch Center XML file ==
The dbexport command is available as dbexport.cmd for Windows systems and dbexport.sh for Linux systems.
<pre>
Options:
-x | --help ... print this help
-f | --file ... data file (zip or xml) for export (MANDATORY)
-c | --config ... configuration properties file
-h | --dbhost ... database host (overrides config file setting)
-u | --dbuser ... database user (overrides config file setting)
-p | --dbpassword ... database password (overrides config file setting)
-t | --dbtype ... database type such as mysql, oracle, jtds (overrides config file setting)
-d | --dbname ... database name (overrides config file setting)
-e | --dbport ... database TCP/IP port (overrides config file setting)
</pre>
== Importing the database from a NoTouch Center XML file ==
The dbimport command is available as dbimport.cmd for Windows systems and dbimport.sh for Linux systems. The -f parameter followed by the file to import is mandatory. By default, the tool will read out the database information from the etc/tcmgr.properties file. You can specify another properties file with the -c switch or add database parameters using the command line.
dbimport works best if used on a new database. Refer to the instructions about preparing a database. If NoTouch Center has only been run once, it will have already created its table structure and database constraints.
<pre>
-x | --help ... print this help
-f | --file ... data file (zip or xml) for import (MANDATORY)
-c | --config ... configuration properties file
-o | --onlyimportant ... only mandatory tables, without peripheral inventory and log
--nodelete ... do not delete database contents before importing
--noinstall ... do not install tables
--nocleanup ... do not clean up ie delete records with missing foreign keys
-r | --resetpw ... reset admin password to default
-h | --dbhost ... database host (overrides config file setting)
-u | --dbuser ... database user (overrides config file setting)
-p | --dbpassword ... database password (overrides config file setting)
-t | --dbtype ... database type such as mysql, oracle, jtds (overrides config file setting)
-d | --dbname ... database name (overrides config file setting)
-e | --dbport ... database TCP/IP port (overrides config file setting)
-m | --maxrows X ... import at most X rows per table (debugging option)
--droponly ... delete everything in database and exit (no importing done) DANGEROUS
--noautoinstall ... do not autoinstall (i.e. the new parameter definitions)
</pre>
[[Category:NTC]] [[Category:Migration]]