DeskNow Knowledge Base
 
      
Home Backup and migration How do I migrate from one database to another?

How do I migrate from one database to another?

Apart from the migration from the old internal database format (see /kb/idx/9/132/article/ ), DeskNow does not provide a functionality to migrate a database to another.

However there are several utilites available that can perform this task. Try searching on your favourite search engine for 'migrate mysql to postgresql' (for example). Make sure to stop DeskNow before migrating your data.

Important: after the migration, make sure to edit the table 'PROPERTIES' in the new database, and change the value of the field 'pvalue' that corresponds to the pkey 'DATABASE'. Possible values are:

  • SQLSERVER_2000 for SQL Server 2000 and 2005
  • POSTGRESQL_7 for PostgreSQL 7.1 and later (including 8, 9, etc)
  • MYSQL4 for MySQL 4 and later (including 5, etc)

Important: database migration is a delicate process. DeskNow uses very standard field types and no triggers, autoincrement columns or constructs that are specific to a particular db. However problems may still occur. If you experience problems after the migration, double check the migration process and results. If you need to contact our customer support service after a migration has occurred (even much later), please always clearly indicate that the database was migrated.

Email Article Email
Print Article Print


How helpful was this article to you?
Related Articles
article How do I migrate from the old McKoi database to an external database?
Please note: depending on the amount of data...

  May 25, 2006    Views: 21216   
article How do I migrate DeskNow from Windows to Linux/Unix?
It is possible, and usually straightforward, to...

  May 13, 2004    Views: 65133   
article How do I migrate my data from Linux to Windows?
It is possible, and usually straightforward, to...

  May 25, 2004    Views: 58893   



Powered by Lore :: (c)2003 Pineapple Technologies.