{"id":3462,"date":"2016-02-10T14:19:00","date_gmt":"2016-02-10T13:19:00","guid":{"rendered":"https:\/\/www.derdack.com\/migration-of-enterprise-alert-and-or-database\/"},"modified":"2016-02-26T16:55:44","modified_gmt":"2016-02-26T15:55:44","slug":"migration-of-enterprise-alert-and-or-database","status":"publish","type":"post","link":"https:\/\/www.derdack.com\/de\/migration-of-enterprise-alert-and-or-database\/","title":{"rendered":"Migration of Enterprise Alert and \/ or Database"},"content":{"rendered":"<div>This article describes how to migrate Enterprise Alert to another machine with all its configurations, users and parameters. The first part describes the migration of the Enterprise Alert installation and the second part is about the related database migration. You can use both parts combined for a complete migration or separately in case you only want to migrate either Enterprise Alert or its database.<\/div>\n<div><\/div>\n<div style=\"border: solid #F38A00 1.0pt;padding: 0cm 0cm 0cm 0cm\">\n<div style=\"border: none;margin-bottom: 4pt;padding: 0cm\"><span style=\"color: #7f7f7f\">Note: Before migrating or changing any settings, we recommend to make a full backup of the Enterprise Alert server as well as of the database. Please contact Derdack support in order to clear any questions and to make sure someone will be available during the migration just in case.<\/span><\/div>\n<\/div>\n<div style=\"line-height: 100%;margin-bottom: 8.05pt\"><\/div>\n<div style=\"line-height: 100%;margin-bottom: 8.05pt\">Please also note, the steps below are a high-level description in order to provide you with the overall idea. Additional or adapted steps might be required in your specific scenario.<\/div>\n<h1><span style=\"font-size: large\">Migration of Enterprise Alert<\/span><\/h1>\n<div><span style=\"font-size: large\"><span style=\"font-size: small;line-height: 16px\">The following steps describe the migration of an existing Enterprise Alert installation to a new server.<\/span><\/span><\/div>\n<div>\n<ul>\n<li><span style=\"line-height: 16px;text-indent: -18pt\">Contact Derdack support in order to get a new license file for your installation and in order to clear possible preparation questions.<\/span><\/li>\n<li><span style=\"line-height: 100%;text-indent: -18pt\">Install the latest patches on your current Enterprise Alert installation. The versions of the current installation and the new one you are going to install need to be the same.<\/span><\/li>\n<li><span style=\"line-height: 100%;text-indent: -18pt\">Download the latest Enterprise Alert setup matching the version of your installation.<\/span><\/li>\n<li><span><span>&nbsp;<\/span><\/span><span style=\"line-height: 100%;text-indent: -18pt\">Install Enterprise Alert with the provided setup file on your new server. Select the same features as for the existing installation.<\/span><\/li>\n<li><span style=\"line-height: 100%;text-indent: -18pt\">During the installation point to the appropriate database:<\/span><\/li>\n<li style=\"margin-left: 16pt\"><span style=\"line-height: 100%;text-indent: -40pt\">If you would like to use the existing database, please, stop all Enterprise Alert services on the old server and in the installation point to the existing database (choose not to create the database from the installation).<\/span><\/li>\n<li style=\"margin-left: 16pt\"><span style=\"line-height: 100%;text-indent: -18pt\">If you would like to create a new database, you can point to that one during the installation and let the setup create the new database. You need to migrate your old database to the new one afterwards in order to migrate the data as well. The database migration is described below.<\/span><\/li>\n<li><span style=\"line-height: 100%;text-indent: -18pt\">Apply the new license file to the new installation.<\/span><\/li>\n<li><span style=\"line-height: 100%;text-indent: -18pt\">Stop all Enterprise Alert services on your new server.<\/span><\/li>\n<li><span style=\"line-height: 100%;text-indent: -18pt\">Copy all .xml files from your old Enterprise Alert folder (\u201cC:Program Files (x86)Enterprise Alert\u201d) including subfolders to the new Enterprise Alert folder and sub-folders, except the following files:<\/span><\/li>\n<li style=\"margin-left: 16pt\"><span style=\"line-height: 100%;text-indent: 0cm\">logman.xml<\/span><\/li>\n<li style=\"margin-left: 16pt\"><span style=\"line-height: 100%;text-indent: 0cm\">profman.xml<\/span><\/li>\n<li style=\"margin-left: 16pt\"><span style=\"line-height: 100%;text-indent: 0cm\">Files under \u201c\u2026.Enterprise AlertWebSites\u201d if this folder should exist<\/span><\/li>\n<li><span style=\"line-height: 100%;text-indent: -18pt\">Restart all Enterprise Alert services on the new server again.<\/span><\/li>\n<li><span style=\"line-height: 100%;text-indent: -18pt\">Test all your settings and re-enter all passwords in the settings.<\/span><\/li>\n<li><span style=\"line-height: 100%;text-indent: -18pt\">Enterprise Alert is migrated and you shall deactivate the old installation.<\/span><\/li>\n<\/ul>\n<\/div>\n<div style=\"line-height: 100%;margin-bottom: 8.05pt;margin-left: 35.25pt;margin-right: 0cm;margin-top: 0cm;text-indent: -18.0pt\"><\/div>\n<div style=\"line-height: 100%;margin-bottom: 8.05pt;margin-left: 35.25pt;margin-right: 0cm;margin-top: 0cm;text-indent: -18.0pt\"><\/div>\n<div style=\"line-height: 100%;margin-bottom: 8.05pt;margin-left: 35.25pt;margin-right: 0cm;margin-top: 0cm;text-indent: -18.0pt\"><\/div>\n<div style=\"line-height: 100%;margin-bottom: 8.05pt;margin-left: 35.25pt;margin-right: 0cm;margin-top: 0cm;text-indent: -18.0pt\"><\/div>\n<div style=\"line-height: 100%;margin-bottom: 8.05pt;margin-left: 35.25pt;margin-right: 0cm;margin-top: 0cm;text-indent: -18.0pt\"><\/div>\n<div style=\"line-height: 100%;margin-bottom: 8.05pt;margin-left: 72.0pt;margin-right: 0cm;margin-top: 0cm;text-indent: 0cm\"><\/div>\n<div style=\"line-height: 100%;margin-bottom: 8.05pt;margin-left: 72.0pt;margin-right: 0cm;margin-top: 0cm;text-indent: 0cm\"><\/div>\n<div style=\"line-height: 100%;margin-bottom: 8.05pt;margin-left: 35.25pt;margin-right: 0cm;margin-top: 0cm;text-indent: -18.0pt\"><\/div>\n<div style=\"line-height: 100%;margin-bottom: 8.05pt;margin-left: 35.25pt;margin-right: 0cm;margin-top: 0cm;text-indent: -18.0pt\"><\/div>\n<div style=\"line-height: 100%;margin-bottom: 8.05pt;margin-left: 35.25pt;margin-right: 0cm;margin-top: 0cm;text-indent: -18.0pt\"><\/div>\n<div style=\"line-height: 100%;margin-bottom: 8.05pt;margin-left: 72.0pt;margin-right: 0cm;margin-top: 0cm;text-indent: 0cm\"><\/div>\n<div style=\"line-height: 100%;margin-bottom: 8.05pt;margin-left: 72.0pt;margin-right: 0cm;margin-top: 0cm;text-indent: 0cm\"><\/div>\n<div style=\"line-height: 100%;margin-bottom: 8.05pt;margin-left: 72.0pt;margin-right: 0cm;margin-top: 0cm;text-indent: 0cm\"><\/div>\n<div style=\"line-height: 100%;margin-bottom: 8.05pt\"><span style=\"font-size: large\"><br \/><\/span><span style=\"font-size: large\"><b>Migration of the Enterprise Alert Database<\/b><\/span><\/div>\n<div style=\"margin-bottom: 8.05pt\">\n<div style=\"line-height: 100%\">The easiest way to migrate the database is to use the Migration Wizard of SQL Management Studio or you use detach \/ attach method.&nbsp;<\/div>\n<div style=\"line-height: 100%\"><\/div>\n<ul>\n<li style=\"line-height: 100%\"><span style=\"line-height: 100%;text-indent: -18pt\">Migrate the existing Enterprise Alert database to the new database server. Please take care that all logins, user accounts and permissions are available on the new database server for the Enterprise Alert database.<\/span><\/li>\n<li style=\"line-height: 100%\"><span><span>&nbsp;<\/span><\/span><span style=\"line-height: 100%;text-indent: -18pt\">From the application side you can modify the database connection string in the Web portal under \u201cSystem\u201d <\/span><span>\u00e0<\/span><span style=\"line-height: 100%;text-indent: -18pt\">\u201cGeneral\u201d <\/span><span>\u00e0<\/span><span style=\"line-height: 100%;text-indent: -18pt\"> \u201cDatabase\u201d. Here, replace the old connection string with the new one.<\/span><\/li>\n<\/ul>\n<div style=\"text-indent: -24px\"><span style=\"line-height: 16px\"><br \/><\/span><\/div>\n<div style=\"clear: both;text-align: center\"><a href=\"https:\/\/www.derdack.com\/wp-content\/uploads\/sites\/5\/2016\/02\/temp.png\" style=\"margin-left: 1em;margin-right: 1em\"><img loading=\"lazy\" border=\"0\" height=\"183\" src=\"https:\/\/www.derdack.com\/wp-content\/uploads\/sites\/5\/2016\/02\/temp-300x172.png\" width=\"320\" \/><\/a><\/div>\n<div style=\"text-indent: -24px\"><span style=\"line-height: 16px\"><br \/><\/span><\/div>\n<ul>\n<li style=\"line-height: 100%\"><span style=\"text-indent: -18pt\">Restart the IIS (e.g. using \u201ciisreset\u201d).<\/span><\/li>\n<li style=\"line-height: 100%\"><span style=\"text-indent: -18pt\">Restart all Enterprise Alert services.<\/span><\/li>\n<li style=\"line-height: 100%\"><span style=\"text-indent: -18pt\">Test the system in order to make sure all functionality works fine.<\/span><\/li>\n<li style=\"line-height: 100%\"><span style=\"text-indent: -18pt\">The database is migrated and you might want to deprovidion the old one.<\/span><\/li>\n<\/ul>\n<div style=\"text-indent: -24px\"><span style=\"line-height: 16px\"><br \/><\/span><\/div>\n<\/div>\n<div class=\"clearfix\"><\/div>","protected":false},"excerpt":{"rendered":"<p>This article describes how to migrate Enterprise Alert to another machine with all its configurations, users and parameters. The first part describes the migration of the Enterprise Alert installation and the second part is about the related database migration. You can use both parts combined for a complete migration or separately in case you only<\/p>\n<p class=\"cv-read-more-button\"><a class=\"cv-button button is-standard color-accent has-icon icon-after\" href=\"https:\/\/www.derdack.com\/de\/migration-of-enterprise-alert-and-or-database\/\">Continue Reading<i class=\"button-icon icon-right-open-big\"><\/i><\/a><\/p>\n","protected":false},"author":11,"featured_media":3636,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[278,276,240],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Migration of Enterprise Alert and \/ or Database<\/title>\n<meta name=\"description\" content=\"This article describes how to migrate Enterprise Alert to another machine with all its configurations, users and parameters. The first part describes the\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.derdack.com\/de\/migration-of-enterprise-alert-and-or-database\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Migration of Enterprise Alert and \/ or Database\" \/>\n<meta property=\"og:description\" content=\"This article describes how to migrate Enterprise Alert to another machine with all its configurations, users and parameters. The first part describes the\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.derdack.com\/de\/migration-of-enterprise-alert-and-or-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Derdack DE\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/derdack?ref=ts\" \/>\n<meta property=\"article:published_time\" content=\"2016-02-10T13:19:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-02-26T15:55:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.derdack.com\/de\/wp-content\/uploads\/sites\/5\/2016\/02\/temp.png\" \/>\n\t<meta property=\"og:image:width\" content=\"487\" \/>\n\t<meta property=\"og:image:height\" content=\"280\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:creator\" content=\"@derdack\" \/>\n<meta name=\"twitter:site\" content=\"@derdack\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"ronald\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.derdack.com\/de\/#website\",\"url\":\"https:\/\/www.derdack.com\/de\/\",\"name\":\"Derdack DE\",\"description\":\"Alarmierung und mobile St\u00f6rfallreaktion f\u00fcr kritische Systeme\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.derdack.com\/de\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"de-DE\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"de-DE\",\"@id\":\"https:\/\/www.derdack.com\/de\/migration-of-enterprise-alert-and-or-database\/#primaryimage\",\"url\":\"https:\/\/www.derdack.com\/de\/wp-content\/uploads\/sites\/5\/2016\/02\/temp.png\",\"contentUrl\":\"https:\/\/www.derdack.com\/de\/wp-content\/uploads\/sites\/5\/2016\/02\/temp.png\",\"width\":487,\"height\":280,\"caption\":\"Migration of Enterprise Alert and \/ or Database\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.derdack.com\/de\/migration-of-enterprise-alert-and-or-database\/#webpage\",\"url\":\"https:\/\/www.derdack.com\/de\/migration-of-enterprise-alert-and-or-database\/\",\"name\":\"Migration of Enterprise Alert and \/ or Database\",\"isPartOf\":{\"@id\":\"https:\/\/www.derdack.com\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.derdack.com\/de\/migration-of-enterprise-alert-and-or-database\/#primaryimage\"},\"datePublished\":\"2016-02-10T13:19:00+00:00\",\"dateModified\":\"2016-02-26T15:55:44+00:00\",\"author\":{\"@id\":\"https:\/\/www.derdack.com\/de\/#\/schema\/person\/45ea5442287c9b1738f56eb0b7770123\"},\"description\":\"This article describes how to migrate Enterprise Alert to another machine with all its configurations, users and parameters. The first part describes the\",\"breadcrumb\":{\"@id\":\"https:\/\/www.derdack.com\/de\/migration-of-enterprise-alert-and-or-database\/#breadcrumb\"},\"inLanguage\":\"de-DE\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.derdack.com\/de\/migration-of-enterprise-alert-and-or-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.derdack.com\/de\/migration-of-enterprise-alert-and-or-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.derdack.com\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Migration of Enterprise Alert and \/ or Database\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.derdack.com\/de\/#\/schema\/person\/45ea5442287c9b1738f56eb0b7770123\",\"name\":\"ronald\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de-DE\",\"@id\":\"https:\/\/www.derdack.com\/de\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a0dc470a8dfd7dcdcdc8a1f0e78de308?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a0dc470a8dfd7dcdcdc8a1f0e78de308?s=96&d=mm&r=g\",\"caption\":\"ronald\"},\"url\":\"https:\/\/www.derdack.com\/de\/author\/ronald\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Migration of Enterprise Alert and \/ or Database","description":"This article describes how to migrate Enterprise Alert to another machine with all its configurations, users and parameters. The first part describes the","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.derdack.com\/de\/migration-of-enterprise-alert-and-or-database\/","og_locale":"de_DE","og_type":"article","og_title":"Migration of Enterprise Alert and \/ or Database","og_description":"This article describes how to migrate Enterprise Alert to another machine with all its configurations, users and parameters. The first part describes the","og_url":"https:\/\/www.derdack.com\/de\/migration-of-enterprise-alert-and-or-database\/","og_site_name":"Derdack DE","article_publisher":"https:\/\/www.facebook.com\/derdack?ref=ts","article_published_time":"2016-02-10T13:19:00+00:00","article_modified_time":"2016-02-26T15:55:44+00:00","og_image":[{"width":487,"height":280,"url":"https:\/\/www.derdack.com\/de\/wp-content\/uploads\/sites\/5\/2016\/02\/temp.png","type":"image\/png"}],"twitter_card":"summary","twitter_creator":"@derdack","twitter_site":"@derdack","twitter_misc":{"Verfasst von":"ronald","Gesch\u00e4tzte Lesezeit":"3 Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/www.derdack.com\/de\/#website","url":"https:\/\/www.derdack.com\/de\/","name":"Derdack DE","description":"Alarmierung und mobile St\u00f6rfallreaktion f\u00fcr kritische Systeme","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.derdack.com\/de\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"de-DE"},{"@type":"ImageObject","inLanguage":"de-DE","@id":"https:\/\/www.derdack.com\/de\/migration-of-enterprise-alert-and-or-database\/#primaryimage","url":"https:\/\/www.derdack.com\/de\/wp-content\/uploads\/sites\/5\/2016\/02\/temp.png","contentUrl":"https:\/\/www.derdack.com\/de\/wp-content\/uploads\/sites\/5\/2016\/02\/temp.png","width":487,"height":280,"caption":"Migration of Enterprise Alert and \/ or Database"},{"@type":"WebPage","@id":"https:\/\/www.derdack.com\/de\/migration-of-enterprise-alert-and-or-database\/#webpage","url":"https:\/\/www.derdack.com\/de\/migration-of-enterprise-alert-and-or-database\/","name":"Migration of Enterprise Alert and \/ or Database","isPartOf":{"@id":"https:\/\/www.derdack.com\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.derdack.com\/de\/migration-of-enterprise-alert-and-or-database\/#primaryimage"},"datePublished":"2016-02-10T13:19:00+00:00","dateModified":"2016-02-26T15:55:44+00:00","author":{"@id":"https:\/\/www.derdack.com\/de\/#\/schema\/person\/45ea5442287c9b1738f56eb0b7770123"},"description":"This article describes how to migrate Enterprise Alert to another machine with all its configurations, users and parameters. The first part describes the","breadcrumb":{"@id":"https:\/\/www.derdack.com\/de\/migration-of-enterprise-alert-and-or-database\/#breadcrumb"},"inLanguage":"de-DE","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.derdack.com\/de\/migration-of-enterprise-alert-and-or-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.derdack.com\/de\/migration-of-enterprise-alert-and-or-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.derdack.com\/de\/"},{"@type":"ListItem","position":2,"name":"Migration of Enterprise Alert and \/ or Database"}]},{"@type":"Person","@id":"https:\/\/www.derdack.com\/de\/#\/schema\/person\/45ea5442287c9b1738f56eb0b7770123","name":"ronald","image":{"@type":"ImageObject","inLanguage":"de-DE","@id":"https:\/\/www.derdack.com\/de\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a0dc470a8dfd7dcdcdc8a1f0e78de308?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a0dc470a8dfd7dcdcdc8a1f0e78de308?s=96&d=mm&r=g","caption":"ronald"},"url":"https:\/\/www.derdack.com\/de\/author\/ronald\/"}]}},"_links":{"self":[{"href":"https:\/\/www.derdack.com\/de\/wp-json\/wp\/v2\/posts\/3462"}],"collection":[{"href":"https:\/\/www.derdack.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.derdack.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.derdack.com\/de\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.derdack.com\/de\/wp-json\/wp\/v2\/comments?post=3462"}],"version-history":[{"count":2,"href":"https:\/\/www.derdack.com\/de\/wp-json\/wp\/v2\/posts\/3462\/revisions"}],"predecessor-version":[{"id":3718,"href":"https:\/\/www.derdack.com\/de\/wp-json\/wp\/v2\/posts\/3462\/revisions\/3718"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.derdack.com\/de\/wp-json\/wp\/v2\/media\/3636"}],"wp:attachment":[{"href":"https:\/\/www.derdack.com\/de\/wp-json\/wp\/v2\/media?parent=3462"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.derdack.com\/de\/wp-json\/wp\/v2\/categories?post=3462"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.derdack.com\/de\/wp-json\/wp\/v2\/tags?post=3462"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}