{"id":332,"date":"2016-07-11T20:35:53","date_gmt":"2016-07-11T20:35:53","guid":{"rendered":"http:\/\/verticalagetechnologies.com\/?p=332"},"modified":"2016-07-11T20:59:40","modified_gmt":"2016-07-11T20:59:40","slug":"citrix-xaxd-7-9-sql-migration-express-to-standard-mirror","status":"publish","type":"post","link":"https:\/\/verticalagetechnologies.com\/index.php\/2016\/07\/11\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror","title":{"rendered":"Citrix Xenapp\/Xendesktop 7.9 Database Migration &#8211; SQL Express to Mirror"},"content":{"rendered":"<p style=\"text-align: center;\">For brand new Xenapp\/Xendesktop implementations you are given the option to build out the Site quickly using SQL Express. \u00a0While SQL Express may be supported, it&#8217;s certainly not recommended. \u00a0Any Citrix XA\/XD production site\/farm should be installed into a full version of SQL. \u00a0Many Citrix projects start out as &#8216;Proof of Concept&#8217; or Trial phase, get vetted out, then move to production. \u00a0Since many of these POCs are built with SQL Express (an option when building out a new farm\/site), many production environments still utilize this technology.<\/p>\n<p><a href=\"https:\/\/verticalagetechnologies.com\/wp-content\/uploads\/2016\/07\/SQL-Mirror.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-338 alignleft\" src=\"https:\/\/verticalagetechnologies.com\/wp-content\/uploads\/2016\/07\/SQL-Mirror.jpg\" alt=\"SQL-Mirror\" width=\"337\" height=\"229\" \/><\/a>This blog will focus on migrating an existing Citrix Xendesktop\/Xenapp 7.9 Site from a SQL Express 2008R2 database to a SQL 2012 R2 Standard database in a mirrored configuration. \u00a0SQL server high availability is a key component in a stable environment. \u00a0SQL Mirroring or &#8216;Always On&#8217; are the two preferred methods. \u00a0Mirroring seems to be more prevalent due to the SQL Enterprise license required for Always On. \u00a0This changes in SQL Server 2016 Standard.\u00a0<a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt614935.aspx\" target=\"_blank\">https:\/\/msdn.microsoft.com\/en-us\/library\/mt614935.aspx<\/a>. Although there are some limitations. \u00a0Ultimately I chose a SQL Mirror configuration in the end.<\/p>\n<p>Citrix has a great article (<a href=\"http:\/\/support.citrix.com\/article\/CTX140319\" target=\"_blank\">http:\/\/support.citrix.com\/article\/CTX140319<\/a>) detailing this process, so most of the steps and powershell commands\u00a0I used was from there. \u00a0The article also explains some prerequisites that are needed. For instance, the database recovery model must be set to &#8216;Full&#8217;.<\/p>\n<p>I&#8217;ll assume you can setup your own 3 SQL Servers (2 SQL Standard, 1 Express Witness). \u00a0Confirm the recovery model and other points of interest from Citrix&#8217;s article above. \u00a0When you have the mirror configuration in place, you can then proceed to run the powershell commands. \u00a0\u00a0I separate this out into 4 batches of code:<\/p>\n<p><strong>First batch<\/strong> &#8211;\u00a0This batch of code disables logging, sets the database server\/name variables, and tests out the connections to confirm there are no errors before proceeding<\/p>\n<p><strong>Second batch<\/strong> &#8211;\u00a0This batch of code Sets the Database connection strings to $NULL<\/p>\n<p><strong>Third batch<\/strong> &#8211; This batch of code confirms all the Connection Strings are set to $NULL.<\/p>\n<p><strong>Fourth batch<\/strong> &#8211;\u00a0This batch of code sets the currently NULL&#8217;ed out Database Connection Strings to the new datbase server location and adds the &#8216;failoverpartner&#8217; server to complete the Mirrored setup.<\/p>\n<p>Here was a couple gotchas:<\/p>\n<ol>\n<li>When testing with one delivery controller\n<ol>\n<li>Citrix policy \u2013 \u2018prohibit\u2019 enable auto update of controllers<\/li>\n<li>Insert GPO to send VDA to one controller<\/li>\n<li>Remember to remove the policy and put back the 2<sup>nd<\/sup> controller when done testing\/moved.<\/li>\n<\/ol>\n<\/li>\n<li>Once disabling site logging and monitoring\n<ol>\n<li>Do this on both controllers<\/li>\n<li>Then backup database<\/li>\n<\/ol>\n<\/li>\n<li>Issues with \u00a0Set-AppLibDBConnection \u2013DBConnection $null\n<ol>\n<li>Restart Delivery Controller server<\/li>\n<li>Had to stop the citrix delegated administration service<\/li>\n<li>Then command worked.<\/li>\n<\/ol>\n<\/li>\n<li>Setting Citrix Database Connections to $Null\n<ol>\n<li>Make sure all services show up as DBUnconfigured<\/li>\n<li>Do not proceed unless they all are<\/li>\n<\/ol>\n<\/li>\n<li>When you get to the enable site logging and monitoring\n<ol>\n<li>Do this on both controllers before proceeding<\/li>\n<\/ol>\n<\/li>\n<li>If changing the database name, avoid using spaces<\/li>\n<\/ol>\n<p>Below is the Powershell code I used. \u00a0I categorized them in batches from &#8216;First&#8217; to &#8216;Fourth&#8217;. \u00a0However, when I actually ran the code, <strong>I EXECUTED\u00a0THIS LINE BY LINE<\/strong>. \u00a0This is so I could granularly confirm each output from the command\u00a0was processed successfully and with desired results.<\/p>\n<h2 style=\"text-align: center;\">FIRST:<\/h2>\n<blockquote><p>## This batch of code disables logging, sets the database server\/name variables, and tests out the connections to confirm there are no errors before proceeding<\/p>\n<p>#Disable Configuration Logging<\/p>\n<p>Set-LogSite -State &#8220;Disabled&#8221;<\/p>\n<p>write-host &#8220;Close and Reopen Studio&#8221;<\/p>\n<p>Set-MonitorConfiguration -DataCollectionEnabled $False<\/p>\n<p>Write-host &#8220;Backup database&#8221;<\/p>\n<p>##<\/p>\n<p>## Replace &lt;dbserver&gt; with the New SQL server, and instance if present<\/p>\n<p>## Replace &lt;dbname&gt; with the name of your restored Database<\/p>\n<p>##<\/p>\n<p>##<\/p>\n<p>$ServerName=&#8221;<strong>sql-servername<\/strong>\\sqlexpress&#8221;<\/p>\n<p>$DBName =&#8221;<strong>database-name<\/strong>&#8221;<\/p>\n<p>#<\/p>\n<p>$cs=&#8221;Server=$ServerName; Initial Catalog=$DBName; Integrated Security=True&#8221;<\/p>\n<p>$cs<\/p>\n<p>Test-AdminDBConnection -DBConnection $cs<\/p>\n<p>Test-ConfigDBConnection -DBConnection $cs<\/p>\n<p>Test-AcctDBConnection -DBConnection $cs<\/p>\n<p>Test-AnalyticsDBConnection -DBConnection $cs<\/p>\n<p>Test-HypDBConnection -DBConnection $cs<\/p>\n<p>Test-ProvDBConnection -DBConnection $cs<\/p>\n<p>Test-BrokerDBConnection -DBConnection $cs<\/p>\n<p>Test-EnvTestDBConnection -DBConnection $cs<\/p>\n<p>Test-LogDBConnection -DBConnection $cs<\/p>\n<p>Test-MonitorDBConnection -DBConnection $cs<\/p>\n<p>Test-SfDBConnection -DBConnection $cs<\/p>\n<p>Test-AppLibDBConnection -DBConnection $cs<\/p><\/blockquote>\n<h2 style=\"text-align: center;\">SECOND:<\/h2>\n<blockquote><p>## This batch of code Sets the Database connection strings to $NULL<\/p>\n<p>## First unregister the Delivery Controllers from the current database:<\/p>\n<p>##<\/p>\n<p>Set-ConfigDBConnection -DBConnection $null<\/p>\n<p>Set-AcctDBConnection -DBConnection $null<\/p>\n<p>Set-AnalyticsDBConnection -DBConnection $null<\/p>\n<p>Set-HypDBConnection -DBConnection $null<\/p>\n<p>Set-ProvDBConnection -DBConnection $null<\/p>\n<p>Set-BrokerDBConnection -DBConnection $null<\/p>\n<p>Set-EnvTestDBConnection -DBConnection $null<\/p>\n<p>Set-SfDBConnection -DBConnection $null<\/p>\n<p>Set-MonitorDBConnection -DataStore Monitor -DBConnection $null<\/p>\n<p>Set-MonitorDBConnection -DBConnection $null<\/p>\n<p>Set-LogDBConnection -DataStore Logging -DBConnection $null<\/p>\n<p>Set-LogDBConnection -DBConnection $null<\/p>\n<p>Set-AdminDBConnection -DBConnection $null<\/p>\n<p>Set-AppLibDBConnection \u2013DBConnection $null<\/p>\n<p>Get-Service Citrix* | Stop-Service -Force<\/p>\n<p>Get-Service Citrix* | Start-Service<\/p>\n<p>Write-host &#8220;Restart Controller&#8221;<\/p><\/blockquote>\n<h2 style=\"text-align: center;\">THIRD:<\/h2>\n<blockquote><p>## This batch of code confirms all the Connection Strings are set to $NULL.<\/p>\n<p>## DO NOT PROCEED UNLESS THEY ARE ALL $NULL<\/p>\n<p>Get-AcctServiceStatus<\/p>\n<p>Get-AdminServiceStatus<\/p>\n<p>Get-BrokerServiceStatus<\/p>\n<p>Get-ConfigServiceStatus<\/p>\n<p>Get-EnvTestServiceStatus<\/p>\n<p>Get-HypServiceStatus<\/p>\n<p>Get-LogServiceStatus<\/p>\n<p>Get-MonitorServiceStatus<\/p>\n<p>Get-ProvServiceStatus<\/p>\n<p>Get-SfServiceStatus<\/p>\n<p>Get-AppLibServiceStatus<\/p><\/blockquote>\n<h2 style=\"text-align: center;\">FOURTH:<\/h2>\n<blockquote><p>## This batch of code sets the currently NULL&#8217;ed out Database Connection Strings to the new datbase server location and adds the &#8216;failoverpartner&#8217; server to complete the Mirrored setup.<\/p>\n<p>asnp Citrix*<\/p>\n<p>##<\/p>\n<p>## Replace &lt;dbserver&gt; with the New SQL server, and instance if present<\/p>\n<p>## Replace &lt;dbname&gt; with the name of your restored Database<\/p>\n<p>##<\/p>\n<p>$ServerName=&#8221;<strong>PrimarySQLServerDNSName.domain.com<\/strong>&#8221;<\/p>\n<p>$DBName =&#8221;<strong>DatabaseName<\/strong>&#8221;<\/p>\n<p>$LogDBName = &#8220;<strong>DatabaseName<\/strong>&#8221;<\/p>\n<p>$MonitorDBName = &#8220;<strong>DatabaseName<\/strong>&#8221;<\/p>\n<p>$FailoverPartner = &#8220;<strong>SQLFailoverPartnerDNSname.domain.com<\/strong>&#8221;<\/p>\n<p>#<\/p>\n<p>$cs=&#8221;Server=$ServerName;Initial Catalog=$DBName;Integrated Security=True;Failover Partner=$FailoverPartner&#8221;<\/p>\n<p>$csLogging= &#8220;Server=$ServerName;Initial Catalog=$LogDBName;Integrated Security=True;Failover Partner=$FailoverPartner&#8221;<\/p>\n<p>$csMonitoring = &#8220;Server=$ServerName;Initial Catalog=$MonitorDBName;Integrated Security=True;Failover Partner=$FailoverPartner&#8221;<\/p>\n<p>Set-AdminDBConnection -DBConnection $cs<\/p>\n<p>Set-ConfigDBConnection -DBConnection $cs<\/p>\n<p>Set-AcctDBConnection -DBConnection $cs<\/p>\n<p>Set-AnalyticsDBConnection -DBConnection $cs<\/p>\n<p>Set-HypDBConnection -DBConnection $cs<\/p>\n<p>Set-ProvDBConnection -DBConnection $cs<\/p>\n<p>#Set-PvsVmDBConnection -DBConnection $cs<\/p>\n<p>Set-BrokerDBConnection -DBConnection $cs<\/p>\n<p>Set-EnvTestDBConnection -DBConnection $cs<\/p>\n<p>Set-LogDBConnection -DBConnection $cs<\/p>\n<p>Set-LogDBConnection -DataStore Logging -DBConnection $null<\/p>\n<p>Set-LogDBConnection -DBConnection $null<\/p>\n<p>Set-LogDBConnection -DBConnection $cs<\/p>\n<p>Set-LogDBConnection -DataStore Logging -DBConnection $csLogging<\/p>\n<p>Set-MonitorDBConnection -DBConnection $cs<\/p>\n<p>Set-MonitorDBConnection -DataStore Monitor -DBConnection $null<\/p>\n<p>Set-MonitorDBConnection -DBConnection $null<\/p>\n<p>Set-MonitorDBConnection -DBConnection $cs<\/p>\n<p>Set-MonitorDBConnection -DataStore Monitor -DBConnection $csMonitoring<\/p>\n<p>Set-AppLibDBConnection \u2013DBConnection $cs\u00a0\u00a0\u00a0 # 7.8 and newer<\/p>\n<p>Set-SfDBConnection -DBConnection $cs<\/p>\n<p>##Enable Monitoring<\/p>\n<p>Set-MonitorConfiguration -DataCollectionEnabled $true<\/p>\n<p>##Enable Configuration Logging<\/p>\n<p>Set-LogSite -State &#8220;Enabled&#8221;<\/p>\n<p>write-host &#8220;Restart Citrix Studio.&#8221;<\/p>\n<p>Get-AcctServiceStatus<\/p>\n<p>Get-AdminServiceStatus<\/p>\n<p>Get-BrokerServiceStatus<\/p>\n<p>Get-ConfigServiceStatus<\/p>\n<p>Get-EnvTestServiceStatus<\/p>\n<p>Get-HypServiceStatus<\/p>\n<p>Get-LogServiceStatus<\/p>\n<p>Get-MonitorServiceStatus<\/p>\n<p>Get-ProvServiceStatus<\/p>\n<p>Get-SfServiceStatus<\/p>\n<p>Get-AppLibServiceStatus<\/p><\/blockquote>\n<p>Perform this same process on each Delivery Controller in your Site.<\/p>\n<p>I hope this helps everyone. \u00a0There really wasn&#8217;t anything out there recent as far as blogs on this type of move with XenDesktop\/XenApp 7.X. \u00a0So there you have it, fully functional database migration with XenApp\/XenDesktop 7.9 from SQL Express to Mirrored Configuration.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>For brand new Xenapp\/Xendesktop implementations you are given the option to build out the Site quickly using SQL Express. \u00a0While SQL Express may be supported, it&#8217;s certainly not recommended. \u00a0Any Citrix XA\/XD production site\/farm should be installed into a full version of SQL. \u00a0Many Citrix projects start out as &#8216;Proof of Concept&#8217; or Trial phase,&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[8,12],"tags":[],"class_list":["post-332","post","type-post","status-publish","format-standard","hentry","category-citrix","category-xendesktopxenapp"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\r\n<title>Citrix Xenapp\/Xendesktop 7.9 Database Migration - SQL Express to Mirror - Vertical Age Technologies, LLC<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/verticalagetechnologies.com\/index.php\/2016\/07\/11\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Citrix Xenapp\/Xendesktop 7.9 Database Migration - SQL Express to Mirror - Vertical Age Technologies, LLC\" \/>\r\n<meta property=\"og:description\" content=\"For brand new Xenapp\/Xendesktop implementations you are given the option to build out the Site quickly using SQL Express. \u00a0While SQL Express may be supported, it&#8217;s certainly not recommended. \u00a0Any Citrix XA\/XD production site\/farm should be installed into a full version of SQL. \u00a0Many Citrix projects start out as &#8216;Proof of Concept&#8217; or Trial phase,...\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/verticalagetechnologies.com\/index.php\/2016\/07\/11\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror\" \/>\r\n<meta property=\"og:site_name\" content=\"Vertical Age Technologies, LLC\" \/>\r\n<meta property=\"article:published_time\" content=\"2016-07-11T20:35:53+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2016-07-11T20:59:40+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/verticalagetechnologies.com\/wp-content\/uploads\/2016\/07\/SQL-Mirror.jpg\" \/>\r\n<meta name=\"author\" content=\"Steve Noel\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:creator\" content=\"@steve_noel\" \/>\r\n<meta name=\"twitter:site\" content=\"@steve_noel\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Steve Noel\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/verticalagetechnologies.com\\\/index.php\\\/2016\\\/07\\\/11\\\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/verticalagetechnologies.com\\\/index.php\\\/2016\\\/07\\\/11\\\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror\"},\"author\":{\"name\":\"Steve Noel\",\"@id\":\"https:\\\/\\\/verticalagetechnologies.com\\\/#\\\/schema\\\/person\\\/8770e41ed31650ba3b32a4e7482e5de6\"},\"headline\":\"Citrix Xenapp\\\/Xendesktop 7.9 Database Migration &#8211; SQL Express to Mirror\",\"datePublished\":\"2016-07-11T20:35:53+00:00\",\"dateModified\":\"2016-07-11T20:59:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/verticalagetechnologies.com\\\/index.php\\\/2016\\\/07\\\/11\\\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror\"},\"wordCount\":1045,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\\\/\\\/verticalagetechnologies.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/verticalagetechnologies.com\\\/index.php\\\/2016\\\/07\\\/11\\\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/verticalagetechnologies.com\\\/wp-content\\\/uploads\\\/2016\\\/07\\\/SQL-Mirror.jpg\",\"articleSection\":[\"Citrix\",\"Xendesktop\\\/Xenapp\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/verticalagetechnologies.com\\\/index.php\\\/2016\\\/07\\\/11\\\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/verticalagetechnologies.com\\\/index.php\\\/2016\\\/07\\\/11\\\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror\",\"url\":\"https:\\\/\\\/verticalagetechnologies.com\\\/index.php\\\/2016\\\/07\\\/11\\\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror\",\"name\":\"Citrix Xenapp\\\/Xendesktop 7.9 Database Migration - SQL Express to Mirror - Vertical Age Technologies, LLC\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/verticalagetechnologies.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/verticalagetechnologies.com\\\/index.php\\\/2016\\\/07\\\/11\\\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/verticalagetechnologies.com\\\/index.php\\\/2016\\\/07\\\/11\\\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/verticalagetechnologies.com\\\/wp-content\\\/uploads\\\/2016\\\/07\\\/SQL-Mirror.jpg\",\"datePublished\":\"2016-07-11T20:35:53+00:00\",\"dateModified\":\"2016-07-11T20:59:40+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/verticalagetechnologies.com\\\/index.php\\\/2016\\\/07\\\/11\\\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/verticalagetechnologies.com\\\/index.php\\\/2016\\\/07\\\/11\\\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/verticalagetechnologies.com\\\/index.php\\\/2016\\\/07\\\/11\\\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror#primaryimage\",\"url\":\"https:\\\/\\\/verticalagetechnologies.com\\\/wp-content\\\/uploads\\\/2016\\\/07\\\/SQL-Mirror.jpg\",\"contentUrl\":\"https:\\\/\\\/verticalagetechnologies.com\\\/wp-content\\\/uploads\\\/2016\\\/07\\\/SQL-Mirror.jpg\",\"width\":391,\"height\":266},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/verticalagetechnologies.com\\\/index.php\\\/2016\\\/07\\\/11\\\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/verticalagetechnologies.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Citrix Xenapp\\\/Xendesktop 7.9 Database Migration &#8211; SQL Express to Mirror\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/verticalagetechnologies.com\\\/#website\",\"url\":\"https:\\\/\\\/verticalagetechnologies.com\\\/\",\"name\":\"Vertical Age Technologies, LLC\",\"description\":\"A Blogging and Portfolio website on everything technology.\",\"publisher\":{\"@id\":\"https:\\\/\\\/verticalagetechnologies.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/verticalagetechnologies.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/verticalagetechnologies.com\\\/#organization\",\"name\":\"Vertical Age Technologies\",\"url\":\"https:\\\/\\\/verticalagetechnologies.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/verticalagetechnologies.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/verticalagetechnologies.com\\\/wp-content\\\/uploads\\\/2015\\\/11\\\/VA-Green-Alpha.png\",\"contentUrl\":\"https:\\\/\\\/verticalagetechnologies.com\\\/wp-content\\\/uploads\\\/2015\\\/11\\\/VA-Green-Alpha.png\",\"width\":1683,\"height\":462,\"caption\":\"Vertical Age Technologies\"},\"image\":{\"@id\":\"https:\\\/\\\/verticalagetechnologies.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/steve_noel\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/snoel\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/verticalagetechnologies.com\\\/#\\\/schema\\\/person\\\/8770e41ed31650ba3b32a4e7482e5de6\",\"name\":\"Steve Noel\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/8a54091a24f06514e9fa9b1702fdb589dced4bdf85d9ebced7ef6047b79a3ca3?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/8a54091a24f06514e9fa9b1702fdb589dced4bdf85d9ebced7ef6047b79a3ca3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/8a54091a24f06514e9fa9b1702fdb589dced4bdf85d9ebced7ef6047b79a3ca3?s=96&d=mm&r=g\",\"caption\":\"Steve Noel\"},\"sameAs\":[\"http:\\\/\\\/VerticalAge.com\"]}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Citrix Xenapp\/Xendesktop 7.9 Database Migration - SQL Express to Mirror - Vertical Age Technologies, LLC","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:\/\/verticalagetechnologies.com\/index.php\/2016\/07\/11\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror","og_locale":"en_US","og_type":"article","og_title":"Citrix Xenapp\/Xendesktop 7.9 Database Migration - SQL Express to Mirror - Vertical Age Technologies, LLC","og_description":"For brand new Xenapp\/Xendesktop implementations you are given the option to build out the Site quickly using SQL Express. \u00a0While SQL Express may be supported, it&#8217;s certainly not recommended. \u00a0Any Citrix XA\/XD production site\/farm should be installed into a full version of SQL. \u00a0Many Citrix projects start out as &#8216;Proof of Concept&#8217; or Trial phase,...","og_url":"https:\/\/verticalagetechnologies.com\/index.php\/2016\/07\/11\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror","og_site_name":"Vertical Age Technologies, LLC","article_published_time":"2016-07-11T20:35:53+00:00","article_modified_time":"2016-07-11T20:59:40+00:00","og_image":[{"url":"https:\/\/verticalagetechnologies.com\/wp-content\/uploads\/2016\/07\/SQL-Mirror.jpg","type":"","width":"","height":""}],"author":"Steve Noel","twitter_card":"summary_large_image","twitter_creator":"@steve_noel","twitter_site":"@steve_noel","twitter_misc":{"Written by":"Steve Noel","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/verticalagetechnologies.com\/index.php\/2016\/07\/11\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror#article","isPartOf":{"@id":"https:\/\/verticalagetechnologies.com\/index.php\/2016\/07\/11\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror"},"author":{"name":"Steve Noel","@id":"https:\/\/verticalagetechnologies.com\/#\/schema\/person\/8770e41ed31650ba3b32a4e7482e5de6"},"headline":"Citrix Xenapp\/Xendesktop 7.9 Database Migration &#8211; SQL Express to Mirror","datePublished":"2016-07-11T20:35:53+00:00","dateModified":"2016-07-11T20:59:40+00:00","mainEntityOfPage":{"@id":"https:\/\/verticalagetechnologies.com\/index.php\/2016\/07\/11\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror"},"wordCount":1045,"commentCount":2,"publisher":{"@id":"https:\/\/verticalagetechnologies.com\/#organization"},"image":{"@id":"https:\/\/verticalagetechnologies.com\/index.php\/2016\/07\/11\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror#primaryimage"},"thumbnailUrl":"https:\/\/verticalagetechnologies.com\/wp-content\/uploads\/2016\/07\/SQL-Mirror.jpg","articleSection":["Citrix","Xendesktop\/Xenapp"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/verticalagetechnologies.com\/index.php\/2016\/07\/11\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror#respond"]}]},{"@type":"WebPage","@id":"https:\/\/verticalagetechnologies.com\/index.php\/2016\/07\/11\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror","url":"https:\/\/verticalagetechnologies.com\/index.php\/2016\/07\/11\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror","name":"Citrix Xenapp\/Xendesktop 7.9 Database Migration - SQL Express to Mirror - Vertical Age Technologies, LLC","isPartOf":{"@id":"https:\/\/verticalagetechnologies.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/verticalagetechnologies.com\/index.php\/2016\/07\/11\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror#primaryimage"},"image":{"@id":"https:\/\/verticalagetechnologies.com\/index.php\/2016\/07\/11\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror#primaryimage"},"thumbnailUrl":"https:\/\/verticalagetechnologies.com\/wp-content\/uploads\/2016\/07\/SQL-Mirror.jpg","datePublished":"2016-07-11T20:35:53+00:00","dateModified":"2016-07-11T20:59:40+00:00","breadcrumb":{"@id":"https:\/\/verticalagetechnologies.com\/index.php\/2016\/07\/11\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/verticalagetechnologies.com\/index.php\/2016\/07\/11\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/verticalagetechnologies.com\/index.php\/2016\/07\/11\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror#primaryimage","url":"https:\/\/verticalagetechnologies.com\/wp-content\/uploads\/2016\/07\/SQL-Mirror.jpg","contentUrl":"https:\/\/verticalagetechnologies.com\/wp-content\/uploads\/2016\/07\/SQL-Mirror.jpg","width":391,"height":266},{"@type":"BreadcrumbList","@id":"https:\/\/verticalagetechnologies.com\/index.php\/2016\/07\/11\/citrix-xaxd-7-9-sql-migration-express-to-standard-mirror#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/verticalagetechnologies.com\/"},{"@type":"ListItem","position":2,"name":"Citrix Xenapp\/Xendesktop 7.9 Database Migration &#8211; SQL Express to Mirror"}]},{"@type":"WebSite","@id":"https:\/\/verticalagetechnologies.com\/#website","url":"https:\/\/verticalagetechnologies.com\/","name":"Vertical Age Technologies, LLC","description":"A Blogging and Portfolio website on everything technology.","publisher":{"@id":"https:\/\/verticalagetechnologies.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/verticalagetechnologies.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/verticalagetechnologies.com\/#organization","name":"Vertical Age Technologies","url":"https:\/\/verticalagetechnologies.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/verticalagetechnologies.com\/#\/schema\/logo\/image\/","url":"https:\/\/verticalagetechnologies.com\/wp-content\/uploads\/2015\/11\/VA-Green-Alpha.png","contentUrl":"https:\/\/verticalagetechnologies.com\/wp-content\/uploads\/2015\/11\/VA-Green-Alpha.png","width":1683,"height":462,"caption":"Vertical Age Technologies"},"image":{"@id":"https:\/\/verticalagetechnologies.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/steve_noel","https:\/\/www.linkedin.com\/in\/snoel\/"]},{"@type":"Person","@id":"https:\/\/verticalagetechnologies.com\/#\/schema\/person\/8770e41ed31650ba3b32a4e7482e5de6","name":"Steve Noel","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/8a54091a24f06514e9fa9b1702fdb589dced4bdf85d9ebced7ef6047b79a3ca3?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/8a54091a24f06514e9fa9b1702fdb589dced4bdf85d9ebced7ef6047b79a3ca3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8a54091a24f06514e9fa9b1702fdb589dced4bdf85d9ebced7ef6047b79a3ca3?s=96&d=mm&r=g","caption":"Steve Noel"},"sameAs":["http:\/\/VerticalAge.com"]}]}},"_links":{"self":[{"href":"https:\/\/verticalagetechnologies.com\/index.php\/wp-json\/wp\/v2\/posts\/332","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/verticalagetechnologies.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/verticalagetechnologies.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/verticalagetechnologies.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/verticalagetechnologies.com\/index.php\/wp-json\/wp\/v2\/comments?post=332"}],"version-history":[{"count":10,"href":"https:\/\/verticalagetechnologies.com\/index.php\/wp-json\/wp\/v2\/posts\/332\/revisions"}],"predecessor-version":[{"id":334,"href":"https:\/\/verticalagetechnologies.com\/index.php\/wp-json\/wp\/v2\/posts\/332\/revisions\/334"}],"wp:attachment":[{"href":"https:\/\/verticalagetechnologies.com\/index.php\/wp-json\/wp\/v2\/media?parent=332"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/verticalagetechnologies.com\/index.php\/wp-json\/wp\/v2\/categories?post=332"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/verticalagetechnologies.com\/index.php\/wp-json\/wp\/v2\/tags?post=332"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}