{"id":854,"date":"2014-10-13T17:28:27","date_gmt":"2014-10-13T17:28:27","guid":{"rendered":"http:\/\/geeks.ms\/johnbulla\/2014\/10\/13\/sql-server-data-tools-ssdt-deteccin-de-diferencias\/"},"modified":"2020-06-12T18:49:54","modified_gmt":"2020-06-12T23:49:54","slug":"sql-server-data-tools-ssdt-deteccin-de-diferencias","status":"publish","type":"post","link":"https:\/\/wiki-cloud.co\/en\/2014\/10\/sql-server-data-tools-ssdt-deteccin-de-diferencias\/","title":{"rendered":"SQL Server Data Tools (SSDT) \u2013 Detecci\u00f3n de diferencias"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; margin-right: auto; border-width: 0px;\" src=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_01.png\" width=\"150\" height=\"150\" border=\"0\"><\/p>\n<p>*<em>Actualizado a SQL Server 2014 y Visual Studio 2013<\/em><\/p>\n<p align=\"justify\">Continuando con esta serie de art\u00edculos sobre SQL Server Data Tools (SSDT), hablaremos sobre las detecciones de diferencias que se encuentra en el grupo de desarrollo conectado.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; margin-right: auto; border-width: 0px;\" src=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_02.png\" width=\"534\" height=\"81\" border=\"0\"><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; margin-right: auto; border: 0px; border-width: 0px;\" src=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_03.png\" width=\"441\" height=\"143\" border=\"0\"><\/p>\n<p><strong>Detecci\u00f3n de Diferencias<\/strong><\/p>\n<ul>\n<li><strong>Drift detection<\/strong><\/li>\n<\/ul>\n<blockquote>\n<p align=\"justify\">La base de datos es un objetivo en constante movimiento. Despu\u00e9s de la implementaci\u00f3n, es bastante com\u00fan que un DBA ajuste la estructura o aplique parches en la base de datos de producci\u00f3n, por ejemplo la adici\u00f3n de \u00edndices en tablas particulares para mejorar el rendimiento de las consultas.<\/p>\n<p align=\"justify\">Cuando los ambientes se encuentran fuera de sincron\u00eda, la base de datos est\u00e1 en un estado diferente del que usted y su aplicaci\u00f3n espera que sea y esas diferencias deben ser identificadas y reconciliadas.<\/p>\n<p align=\"justify\">Muchas veces no preguntamos:<\/p>\n<p align=\"justify\">\u2022 &#8220;\u00bfQui\u00e9n puso las tablas en mi base de datos?&#8221;<br>\u2022 &#8220;\u00bfQui\u00e9n cambi\u00f3 esta definici\u00f3n de la vista?&#8221;<br>\u2022 &#8220;\u00bfPor qu\u00e9 este chico esta en db_owner?&#8221;<br>\u2022 &#8220;\u00bfD\u00f3nde ha ido mi procedimiento almacenado?&#8221;<\/p>\n<p align=\"justify\">En otras palabras el drift de base de datos puede ser descrito como objetos que aparecen, objetos que se retiran u objetos que se modifican en las bases de datos de producci\u00f3n o cuando se realizan cambios en la base de datos que no est\u00e1n incluidos en el proyecto.<\/p>\n<p align=\"justify\"><strong>Drift de base de datos en SSDT<\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p align=\"justify\">Si utiliza SSDT para gestionar la base de datos, entonces probablemente cuenta el c\u00f3digo fuente en sus proyectos SSDT y por lo tanto cualquier cosa que aparece en sus bases de datos que no es en el c\u00f3digo fuente se considerar\u00edan drift de base de datos.<\/p>\n<p align=\"justify\">Con el fin de detectar drift de base de datos utilizando SSDT debemos asegurarnos que la base de datos est\u00e9 registrada como Data-Tier Application (Aplicaci\u00f3n de capa de datos). Esto se puede hacer cuando se publica el proyecto de base de datos (es decir dacpac) seleccionando &#8220;Registro como una aplicaci\u00f3n de capa de datos&#8221;.<\/p>\n<p align=\"justify\">En el siguiente ejemplo se realizaron las siguientes operaciones:<\/p>\n<\/blockquote>\n<blockquote>\n<ul>\n<li>\n<div align=\"justify\">Se public\u00f3 la base de datos <a href=\"https:\/\/msftdbprodsamples.codeplex.com\/releases\/view\/125550\" target=\"_blank\" rel=\"noopener noreferrer\">AdventureWorks 2014<\/a> en una instancia de pruebas o de producci\u00f3n. Ver Figura 1.<\/div>\n<\/li>\n<li>\n<div align=\"justify\">Se agreg\u00f3 la tabla <strong><em>Test<\/em><\/strong> en el esquema dbo en la instancia de pruebas o de producci\u00f3n.<\/div>\n<\/li>\n<li>\n<div align=\"justify\">Se elimin\u00f3 el procedimiento almacenado <strong><em>uspUpdateEmployeeLogin<\/em><\/strong> desde la instancia de pruebas o de producci\u00f3n<\/div>\n<\/li>\n<li>\n<div align=\"justify\">Se modific\u00f3 los campos&nbsp; <em><strong>AddressLine1<\/strong><\/em> y <em><strong>AddressLine2<\/strong><\/em> de la tabla Person.Address de nvarchar(60) a nvarchar(100) en la instancia de pruebas o de producci\u00f3n<\/div>\n<\/li>\n<li>\n<div align=\"justify\">Se public\u00f3 nuevamente la base de datos en una instancia de pruebas o de producci\u00f3n. Ver Figura 1.<\/div>\n<\/li>\n<li>\n<div align=\"justify\">En el wizard de publicaci\u00f3n se seleccionaron las opciones de \u201cRegister as a Data-tier Application\u201d y \u201cBlock publish when database has drifted from registered version\u201d, y finalmente click en el bot\u00f3n \u201cPublish\u201d. Ver Figura 2.<\/div>\n<\/li>\n<li>\n<div align=\"justify\">Se verifica el resultado de la publicaci\u00f3n en la ventana de Data Tools Operations y seleccionar la opci\u00f3n de ver reporte. Ver Figura 3.<\/div>\n<\/li>\n<\/ul>\n<\/blockquote>\n<p align=\"left\"><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_04.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: block; padding-right: 0px; border-width: 0px; margin-left: auto; margin-right: auto;\" src=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_04.png\" width=\"534\" height=\"576\" border=\"0\"><\/a><\/p>\n<p align=\"center\">Figura 1. \u2013 Opci\u00f3n de Publicar en el proyecto de Base de Datos en Visual Studio 2013.<\/p>\n<p align=\"justify\"><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_05.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; margin-right: auto; border-width: 0px;\" src=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_05.png\" width=\"534\" height=\"274\" border=\"0\"><\/a><\/p>\n<p align=\"center\">Figura 2. \u2013 Wizard de publicaci\u00f3n de base de datos.<\/p>\n<p><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_06.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; margin-right: auto; border-width: 0px;\" src=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_06.png\" width=\"534\" height=\"180\" border=\"0\"><\/a><\/p>\n<blockquote>\n<p align=\"center\">Figura 3. \u2013 Data tools operations.<\/p>\n<p align=\"justify\">Una vez damos click en la opci\u00f3n de ver el reporte vemos el siguiente XML donde podemos observar los objetos que se adicionaron, eliminaron y los que se modificaron fuera del proyecto de base de datos.<\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;\"><span style=\"font-family: Consolas;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\"><span style=\"font-size: 9.5pt;\">&lt;?<\/span><\/span><\/span><span style=\"font-size: 9.5pt;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #a31515;\">xml<\/span><\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">version<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">1.0<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">encoding<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">utf-8<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"font-size: 9.5pt; color: #0000ff;\">?&gt;<\/span><\/span><\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;\"><span style=\"font-family: Consolas;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\"><span style=\"font-size: 9.5pt;\">&lt;<\/span><\/span><\/span><span style=\"font-size: 9.5pt;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #a31515;\">DriftReport<\/span><\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">xmlns<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">http:\/\/schemas.microsoft.com\/sqlserver\/dac\/DriftReport\/2012\/02<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"font-size: 9.5pt; color: #0000ff;\">&gt;<\/span><\/span><\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;\"><span style=\"font-family: Consolas;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\"><span style=\"mso-spacerun: yes;\"><span style=\"font-size: 9.5pt;\">&nbsp; <\/span><\/span><span style=\"font-size: 9.5pt; background-color: #ffff00;\">&lt;<\/span><\/span><\/span><span style=\"background-color: #ffff00;\"><span style=\"font-size: 9.5pt;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #a31515;\">Additions<\/span><\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"font-size: 9.5pt; color: #0000ff;\">&gt;<\/span><\/span><\/span><\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;\"><span style=\"font-family: Consolas;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\"><span style=\"mso-spacerun: yes;\"><span style=\"font-size: 9.5pt;\">&nbsp;&nbsp;&nbsp; <\/span><\/span><span style=\"font-size: 9.5pt;\">&lt;<\/span><\/span><\/span><span style=\"font-size: 9.5pt;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #a31515;\">Object<\/span><\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">Name<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">[Test]<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">Parent<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">[dbo]<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">Type<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">SqlTable<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"font-size: 9.5pt; color: #0000ff;\"> \/&gt;<\/span><\/span><\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;\"><span style=\"font-family: Consolas;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\"><span style=\"mso-spacerun: yes;\"><span style=\"font-size: 9.5pt;\">&nbsp; <\/span><\/span><span style=\"font-size: 9.5pt; background-color: #ffff00;\">&lt;\/<\/span><\/span><\/span><span style=\"background-color: #ffff00;\"><span style=\"font-size: 9.5pt;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #a31515;\">Additions<\/span><\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"font-size: 9.5pt; color: #0000ff;\">&gt;<\/span><\/span><\/span><\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;\"><span style=\"font-family: Consolas;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\"><span style=\"mso-spacerun: yes;\"><span style=\"font-size: 9.5pt;\">&nbsp; <\/span><\/span><span style=\"font-size: 9.5pt; background-color: #ffff00;\">&lt;<\/span><\/span><\/span><span style=\"background-color: #ffff00;\"><span style=\"font-size: 9.5pt;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #a31515;\">Removals<\/span><\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"font-size: 9.5pt; color: #0000ff;\">&gt;<\/span><\/span><\/span><\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;\"><span style=\"font-family: Consolas;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\"><span style=\"mso-spacerun: yes;\"><span style=\"font-size: 9.5pt;\">&nbsp;&nbsp;&nbsp; <\/span><\/span><span style=\"font-size: 9.5pt;\">&lt;<\/span><\/span><\/span><span style=\"font-size: 9.5pt;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #a31515;\">Object<\/span><\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">Name<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">[uspUpdateEmployeeLogin]<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">Parent<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">[HumanResources]<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">Type<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">SqlProcedure<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"font-size: 9.5pt; color: #0000ff;\"> \/&gt;<\/span><\/span><\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;\"><span style=\"font-family: Consolas;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\"><span style=\"mso-spacerun: yes;\"><span style=\"font-size: 9.5pt;\">&nbsp;&nbsp;&nbsp; <\/span><\/span><span style=\"font-size: 9.5pt;\">&lt;<\/span><\/span><\/span><span style=\"font-size: 9.5pt;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #a31515;\">ExtendedProperty<\/span><\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">HostName<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">[uspUpdateEmployeeLogin]<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">HostParent<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">[HumanResources]<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">HostType<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">SqlProcedure<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">Count<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">1<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"font-size: 9.5pt; color: #0000ff;\"> \/&gt;<\/span><\/span><\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;\"><span style=\"font-family: Consolas;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\"><span style=\"mso-spacerun: yes;\"><span style=\"font-size: 9.5pt;\">&nbsp;&nbsp;&nbsp; <\/span><\/span><span style=\"font-size: 9.5pt;\">&lt;<\/span><\/span><\/span><span style=\"font-size: 9.5pt;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #a31515;\">ExtendedProperty<\/span><\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">HostName<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">[@BusinessEntityID]<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">HostParent<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">[HumanResources].[uspUpdateEmployeeLogin]<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">HostType<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">SqlSubroutineParameter<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">Count<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">1<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"font-size: 9.5pt; color: #0000ff;\"> \/&gt;<\/span><\/span><\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;\"><span style=\"font-family: Consolas;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\"><span style=\"mso-spacerun: yes;\"><span style=\"font-size: 9.5pt;\">&nbsp;&nbsp;&nbsp; <\/span><\/span><span style=\"font-size: 9.5pt;\">&lt;<\/span><\/span><\/span><span style=\"font-size: 9.5pt;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #a31515;\">ExtendedProperty<\/span><\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">HostName<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">[@OrganizationNode]<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">HostParent<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">[HumanResources].[uspUpdateEmployeeLogin]<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">HostType<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">SqlSubroutineParameter<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">Count<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">1<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"font-size: 9.5pt; color: #0000ff;\"> \/&gt;<\/span><\/span><\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;\"><span style=\"font-family: Consolas;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\"><span style=\"mso-spacerun: yes;\"><span style=\"font-size: 9.5pt;\">&nbsp;&nbsp;&nbsp; <\/span><\/span><span style=\"font-size: 9.5pt;\">&lt;<\/span><\/span><\/span><span style=\"font-size: 9.5pt;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #a31515;\">ExtendedProperty<\/span><\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">HostName<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">[@LoginID]<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">HostParent<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">[HumanResources].[uspUpdateEmployeeLogin]<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">HostType<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">SqlSubroutineParameter<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">Count<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">1<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"font-size: 9.5pt; color: #0000ff;\"> \/&gt;<\/span><\/span><\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;\"><span style=\"font-family: Consolas;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\"><span style=\"mso-spacerun: yes;\"><span style=\"font-size: 9.5pt;\">&nbsp;&nbsp;&nbsp; <\/span><\/span><span style=\"font-size: 9.5pt;\">&lt;<\/span><\/span><\/span><span style=\"font-size: 9.5pt;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #a31515;\">ExtendedProperty<\/span><\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">HostName<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">[@JobTitle]<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">HostParent<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">[HumanResources].[uspUpdateEmployeeLogin]<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">HostType<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">SqlSubroutineParameter<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">Count<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">1<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"font-size: 9.5pt; color: #0000ff;\"> \/&gt;<\/span><\/span><\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;\"><span style=\"font-family: Consolas;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\"><span style=\"mso-spacerun: yes;\"><span style=\"font-size: 9.5pt;\">&nbsp;&nbsp;&nbsp; <\/span><\/span><span style=\"font-size: 9.5pt;\">&lt;<\/span><\/span><\/span><span style=\"font-size: 9.5pt;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #a31515;\">ExtendedProperty<\/span><\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">HostName<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">[@HireDate]<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">HostParent<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">[HumanResources].[uspUpdateEmployeeLogin]<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">HostType<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">SqlSubroutineParameter<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">Count<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">1<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"font-size: 9.5pt; color: #0000ff;\"> \/&gt;<\/span><\/span><\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;\"><span style=\"font-family: Consolas;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\"><span style=\"mso-spacerun: yes;\"><span style=\"font-size: 9.5pt;\">&nbsp;&nbsp;&nbsp; <\/span><\/span><span style=\"font-size: 9.5pt;\">&lt;<\/span><\/span><\/span><span style=\"font-size: 9.5pt;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #a31515;\">ExtendedProperty<\/span><\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">HostName<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">[@CurrentFlag]<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">HostParent<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">[HumanResources].[uspUpdateEmployeeLogin]<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">HostType<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">SqlSubroutineParameter<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">Count<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">1<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"font-size: 9.5pt; color: #0000ff;\"> \/&gt;<\/span><\/span><\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;\"><span style=\"font-family: Consolas;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\"><span style=\"mso-spacerun: yes;\"><span style=\"font-size: 9.5pt;\">&nbsp;&nbsp;&nbsp; <\/span><\/span><span style=\"font-size: 9.5pt;\">&lt;<\/span><\/span><\/span><span style=\"font-size: 9.5pt;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #a31515;\">ExtendedProperty<\/span><\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">HostName<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">[DF_Address_ModifiedDate]<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">HostParent<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">[Person].[Address]<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">HostType<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">SqlDefaultConstraint<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">Count<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">1<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"font-size: 9.5pt; color: #0000ff;\"> \/&gt;<\/span><\/span><\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;\"><span style=\"font-family: Consolas;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\"><span style=\"mso-spacerun: yes;\"><span style=\"font-size: 9.5pt;\">&nbsp;&nbsp;&nbsp; <\/span><\/span><span style=\"font-size: 9.5pt;\">&lt;<\/span><\/span><\/span><span style=\"font-size: 9.5pt;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #a31515;\">ExtendedProperty<\/span><\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">HostName<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">[DF_Address_rowguid]<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">HostParent<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">[Person].[Address]<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">HostType<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">SqlDefaultConstraint<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">Count<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">1<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"font-size: 9.5pt; color: #0000ff;\"> \/&gt;<\/span><\/span><\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;\"><span style=\"font-family: Consolas;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\"><span style=\"mso-spacerun: yes;\"><span style=\"font-size: 9.5pt;\">&nbsp; <\/span><\/span><span style=\"font-size: 9.5pt; background-color: #ffff00;\">&lt;\/<\/span><\/span><\/span><span style=\"background-color: #ffff00;\"><span style=\"font-size: 9.5pt;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #a31515;\">Removals<\/span><\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"font-size: 9.5pt; color: #0000ff;\">&gt;<\/span><\/span><\/span><\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;\"><span style=\"font-family: Consolas;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\"><span style=\"mso-spacerun: yes;\"><span style=\"font-size: 9.5pt;\">&nbsp; <\/span><\/span><span style=\"font-size: 9.5pt; background-color: #ffff00;\">&lt;<\/span><\/span><\/span><span style=\"background-color: #ffff00;\"><span style=\"font-size: 9.5pt;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #a31515;\">Modifications<\/span><\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"font-size: 9.5pt; color: #0000ff;\">&gt;<\/span><\/span><\/span><\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;\"><span style=\"font-family: Consolas;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\"><span style=\"mso-spacerun: yes;\"><span style=\"font-size: 9.5pt;\">&nbsp;&nbsp;&nbsp; <\/span><\/span><span style=\"font-size: 9.5pt;\">&lt;<\/span><\/span><\/span><span style=\"font-size: 9.5pt;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #a31515;\">Object<\/span><\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">Name<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">[AddressLine1]<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">Parent<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">[Person].[Address]<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">Type<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">SqlSimpleColumn<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"font-size: 9.5pt; color: #0000ff;\"> \/&gt;<\/span><\/span><\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;\"><span style=\"font-family: Consolas;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\"><span style=\"mso-spacerun: yes;\"><span style=\"font-size: 9.5pt;\">&nbsp;&nbsp;&nbsp; <\/span><\/span><span style=\"font-size: 9.5pt;\">&lt;<\/span><\/span><\/span><span style=\"font-size: 9.5pt;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #a31515;\">Object<\/span><\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">Name<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">[AddressLine2]<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">Parent<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">[Person].[Address]<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">Type<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">SqlSimpleColumn<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"font-size: 9.5pt; color: #0000ff;\"> \/&gt;<\/span><\/span><\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;\"><span style=\"font-family: Consolas;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\"><span style=\"mso-spacerun: yes;\"><span style=\"font-size: 9.5pt;\">&nbsp;&nbsp;&nbsp; <\/span><\/span><span style=\"font-size: 9.5pt;\">&lt;<\/span><\/span><\/span><span style=\"font-size: 9.5pt;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #a31515;\">Object<\/span><\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">Name<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">[Address]<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">Parent<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">[Person]<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span> <span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #ff0000;\">Type<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">=<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"color: #0000ff;\">SqlTable<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\">&#8220;<\/span><\/span><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"font-size: 9.5pt; color: #0000ff;\"> \/&gt;<\/span><\/span><\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0pt; line-height: normal; mso-layout-grid-align: none;\"><span style=\"font-family: Consolas;\"><span style=\"color: #0000ff;\"><span lang=\"EN-US\" style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white; mso-ansi-language: en-us;\"><span style=\"mso-spacerun: yes;\"><span style=\"font-size: 9.5pt;\">&nbsp; <\/span><\/span><\/span><span style=\"font-size: 9.5pt; background-color: #ffff00;\"><span style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white;\">&lt;\/<\/span><\/span><\/span><span style=\"background-color: #ffff00;\"><span style=\"font-size: 9.5pt;\"><span style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white;\"><span style=\"color: #a31515;\">Modifications<\/span><\/span><\/span><span style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; mso-highlight: white;\"><span style=\"font-size: 9.5pt; color: #0000ff;\">&gt;<\/span><\/span><\/span><\/span><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 8pt; line-height: 12pt;\"><span style=\"font-family: Consolas;\"><span style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; line-height: 10pt; mso-highlight: white;\"><span style=\"color: #0000ff;\"><span style=\"font-size: 9.5pt;\">&lt;\/<\/span><\/span><\/span><span style=\"font-size: 9.5pt;\"><span style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; line-height: 10pt; mso-highlight: white;\"><span style=\"color: #a31515;\">DriftReport<\/span><\/span><\/span><span style=\"background-image: none; background-repeat: repeat; background-attachment: scroll; background-position: 0% 0%; line-height: 10pt; mso-highlight: white;\"><span style=\"font-size: 9.5pt; color: #0000ff;\">&gt;<\/span><\/span><\/span><\/p>\n<p align=\"left\"><strong>Drift de base de datos en SSMS<\/strong><\/p>\n<blockquote>\n<p align=\"justify\">Para detectar drift de base de datos utilizando SQL Server Management Studio debemos seguir los siguientes pasos:<\/p>\n<ul>\n<li>\n<div align=\"justify\">Seleccionamos la base de datos donde realizamos los cambios hechos en el ejemplo de SSDT (Adici\u00f3n, Modificaci\u00f3n, Eliminaci\u00f3n) y damos derecho, seleccionamos la opci\u00f3n de \u201cTask\u201d y posteriormente seleccionamos la opci\u00f3n de \u201cUpgrade Data-tier Application\u201d. Ver Figura 4.<\/div>\n<\/li>\n<li>\n<div align=\"justify\">Inicia el wizard de \u201cUpgrade Data-tier Application\u201d y damos click en el bot\u00f3n Siguiente. Ver Figura 5.<\/div>\n<\/li>\n<li>\n<div align=\"justify\">Seleccionamos el archivo con extenci\u00f3n .dacpac y damos click en el bot\u00f3n Siguiente. Ver Figura 6.<\/div>\n<\/li>\n<li>\n<div align=\"justify\">El Wizard de \u201cUpgrade Data-tier Application\u201d inicia el proceso de detecci\u00f3n de cambios. Ver Figura 7.<\/div>\n<\/li>\n<li>\n<div align=\"justify\">Finaliza el proceso de detecci\u00f3n de cambios el DAC desplegado y la base de datos y damos click en el bot\u00f3n guardar reporte. Ver Figura 8.<\/div>\n<\/li>\n<li>\n<div align=\"justify\">Finalmente vemos el XML con el resultado de la detecci\u00f3n de cambios. Ver Figura 8.<\/div>\n<\/li>\n<\/ul>\n<\/blockquote>\n<\/blockquote>\n<p align=\"justify\"><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_07.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: block; padding-right: 0px; border-width: 0px; margin-left: auto; margin-right: auto;\" src=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_07.png\" width=\"534\" height=\"446\" border=\"0\"><\/a><\/p>\n<blockquote>\n<p align=\"center\">Figura 4. \u2013 Opci\u00f3n de Upgrade Data-tier Application en SSMS.<\/p>\n<\/blockquote>\n<p align=\"center\"><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_08.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" src=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_08.png\" width=\"534\" height=\"495\" border=\"0\"><\/a><\/p>\n<blockquote>\n<p align=\"center\">Figura 5. \u2013 Wizard Udgrade a data-tier application en SSMS.<\/p>\n<\/blockquote>\n<p align=\"center\"><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_09.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" src=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_09.png\" width=\"534\" height=\"495\" border=\"0\"><\/a><\/p>\n<blockquote>\n<p align=\"center\">Figura 6. \u2013 Selecci\u00f3n del archivo con extensi\u00f3n .dacpac.<\/p>\n<\/blockquote>\n<p align=\"center\"><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_10.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" src=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_10.png\" width=\"534\" height=\"497\" border=\"0\"><\/a><\/p>\n<blockquote>\n<p align=\"center\">Figura 7. \u2013 Inicio proceso de detecci\u00f3n de cambios.<\/p>\n<\/blockquote>\n<p align=\"center\"><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_11.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" src=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_11.png\" width=\"534\" height=\"496\" border=\"0\"><\/a><\/p>\n<blockquote>\n<p align=\"center\">Figura 8. \u2013 Finalizaci\u00f3n proceso de la detecci\u00f3n de cambios entre el DAC desplegado y la base de datos.<\/p>\n<\/blockquote>\n<p align=\"center\"><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_12.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" src=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_12.png\" width=\"534\" height=\"190\" border=\"0\"><\/a><\/p>\n<blockquote>\n<p align=\"center\">Figura 9. \u2013 Reporte en XML generado del proceso de detecci\u00f3n de cambios entre el DAC desplegado y la base de datos.<\/p>\n<p align=\"left\"><strong>Generar un reporte de drift de base de datos desde linea de comandos<\/strong><\/p>\n<p align=\"justify\">El informe de drift se puede generar con la herramienta de <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/hh550080(v=vs.103).aspx\" target=\"_blank\" rel=\"noopener noreferrer\">sqlpackage.exe<\/a> de l\u00ednea de comandos. Para ello es necesario definir:<\/p>\n<p align=\"justify\">\u2022 La acci\u00f3n del reporte de drift<br>\u2022 Un servidor y base de datos de destino<br>\u2022 Un archivo de salida<\/p>\n<p>&gt; SqlPackage.exe \/ A: <strong>DriftReport<\/strong> \/ TSN:<strong>&#8220;(LocalDB) ProjectsV12&#8221;<\/strong> \/ TDN:<strong>\u201dAdventureWorks2014\u201d<\/strong> \/op:<strong>DriftReportAW2012.xml<\/strong><\/p>\n<\/blockquote>\n<p><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_13.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: block; padding-right: 0px; border-width: 0px; margin-left: auto; margin-right: auto;\" src=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_13.png\" width=\"534\" height=\"138\" border=\"0\"><\/a><\/p>\n<p align=\"center\">Figura 10. \u2013 Generaci\u00f3n del reporte del Drift desde linea de comandos.<\/p>\n<ul>\n<li><strong>Schema comparison \u2013 Comparaci\u00f3n de esquemas<\/strong><\/li>\n<\/ul>\n<blockquote>\n<p align=\"justify\">La funci\u00f3n de comparaci\u00f3n de esquemas compara objetos entre el proyecto de base de datos de Visual Studio, un archivo Data-tier Application (DAC) o una base de datos (Servidor o LocalDB). Ver Figura 14.<\/p>\n<p align=\"justify\">Se presenta una lista de las diferencias, y se puede aplicar los cambios si lo desea. Para iniciar el proceso de comparaci\u00f3n de esquemas podemos hacerlo de las siguientes formas:<\/p>\n<ul>\n<li>\n<div align=\"justify\">En el Solution Explorer o Exporador de Soluciones damos click derecho sobre el proyecto de base de datos y seleccionamos la opci\u00f3n de comparar esquema. Ver Figura 11.<\/div>\n<\/li>\n<li>\n<div align=\"justify\">En el SQL Server Object Explorer o Explorador de Objetos de SQL Server podemos dar click derecho en un proyecto de base de datos o en una base de datos (Servidor \/ LocalDB) para que nos aparezca la opci\u00f3n de comparar esquema. Ver Figura 12.<\/div>\n<\/li>\n<\/ul>\n<\/blockquote>\n<p align=\"center\"><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_14.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" src=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_14.png\" width=\"534\" height=\"573\" border=\"0\"><\/a><\/p>\n<p align=\"center\">Figura 11. \u2013 Opci\u00f3n de comparar esquema en el Explorador de Soluciones.<\/p>\n<p align=\"center\"><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_15.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" src=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_15.png\" width=\"534\" height=\"409\" border=\"0\"><\/a><\/p>\n<p align=\"center\">Figura 12. \u2013 Opci\u00f3n de comparar esquema en el Explorador de Objetos SQL Server.<\/p>\n<blockquote>\n<p align=\"justify\">Una vez seleccionamos la opci\u00f3n de comparar esquema Visual Studio nos muestra la ventana para comparar esquemas. Ver Figura 13.<\/p>\n<\/blockquote>\n<p align=\"center\"><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_16.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" src=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_16.png\" width=\"534\" height=\"466\" border=\"0\"><\/a><\/p>\n<p align=\"center\">Figura 13. \u2013 Ventana de comparaci\u00f3n de esquemas.<\/p>\n<blockquote>\n<p align=\"justify\">Lo primero que debemos hacer es seleccionar los dos esquemas que queremos comparar. En este ejemplo primero seleccione el proyecto de base de datos AdventureWorks2014 y posteriormente seleccione la base de datos servidor de AdventureWorks2014-2 que desplegamos en el ejemplo del drift de base de datos. Ver Figura 14.<\/p>\n<\/blockquote>\n<p align=\"center\"><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_17.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" src=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_17.png\" width=\"390\" height=\"360\" border=\"0\"><\/a><\/p>\n<p align=\"center\">Figura 14 \u2013 venta de selecci\u00f3n de esquemas a comparar.<\/p>\n<blockquote>\n<p align=\"justify\">Una vez hemos seleccionado los esquemas que queremos comparar damos click en el bot\u00f3n de comparar y posteriormente se muestra una lista con las diferencias entre los dos esquemas. En este ejemplo veremos diferencias de adici\u00f3n, modificaci\u00f3n y eliminaci\u00f3n de objetos. Ver Figuras 15, 16 y 17.<\/p>\n<\/blockquote>\n<p align=\"center\"><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_18.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" src=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_18.png\" width=\"534\" height=\"365\" border=\"0\"><\/a><\/p>\n<p align=\"center\">Figura 15 \u2013 Diferencias de eliminaci\u00f3n de objetos.<\/p>\n<p align=\"center\"><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_19.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" src=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_19.png\" width=\"534\" height=\"365\" border=\"0\"><\/a><\/p>\n<p align=\"center\">Figura 16 \u2013 Diferencias de modificaci\u00f3n de objetos.<\/p>\n<p align=\"center\"><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_20.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" src=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_20.png\" width=\"534\" height=\"365\" border=\"0\"><\/a><\/p>\n<p align=\"center\">Figura 17 \u2013 Diferencias de adici\u00f3n de objetos.<\/p>\n<blockquote>\n<p align=\"justify\">Adicionalmente la ventana de comparar esquema nos permite visualizar las diferencias por acci\u00f3n, por esquemas definidos en la base de datos o por tipo de objeto. Ver Figura 18, 19 y 20.<\/p>\n<\/blockquote>\n<p align=\"center\"><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_21.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" src=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_21.png\" width=\"534\" height=\"147\" border=\"0\"><\/a><\/p>\n<p align=\"center\">Figura 18 \u2013 Diferencias organizadas por acci\u00f3n.<\/p>\n<p align=\"center\"><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_22.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" src=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_22.png\" width=\"534\" height=\"147\" border=\"0\"><\/a><\/p>\n<p align=\"center\">Figura 19 \u2013 Diferencias organizadas por esquemas definidos en la base de datos.<\/p>\n<p align=\"center\"><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_23.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-width: 0px;\" src=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_image_SSDT_DeteccionDiferencias_2014_23.png\" width=\"534\" height=\"147\" border=\"0\"><\/a><\/p>\n<p align=\"center\">Figura 20 \u2013 Diferencias organizadas por tipo de objeto.<\/p>\n<blockquote>\n<p align=\"justify\">Una vez analizadas las diferencias entre los esquemas podemos actualizar alguno de los dos esquemas para que estos queden iguales simplemente dando click en el bot\u00f3n <strong>Update<\/strong>.<\/p>\n<\/blockquote>\n<p align=\"justify\">M\u00e1s art\u00edculos:<\/p>\n<p align=\"justify\"><strong>Introducci\u00f3n<\/strong><\/p>\n<ul>\n<li>\n<div align=\"justify\"><a href=\"https:\/\/wiki-cloud.co\/2013\/03\/sql-server-data-tools-ssdt-introduccin\/\" target=\"_blank\" rel=\"noopener noreferrer\">SQL Server Data Tools (SSDT) \u2013 Introducci\u00f3n<\/a><\/div>\n<\/li>\n<\/ul>\n<p align=\"justify\"><strong>Desarrollo Conectado<\/strong><\/p>\n<ul>\n<li>\n<div align=\"justify\"><a href=\"https:\/\/wiki-cloud.co\/2013\/08\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\/\" target=\"_blank\" rel=\"noopener noreferrer\">SQL Server Data Tools (SSDT) \u2013 Experiencia familiar de Usuario<\/a><\/div>\n<\/li>\n<\/ul>\n<p>Saludos,<\/p>\n\n\n<p><strong>Compartir<\/strong>:<\/p>\n\n\n<div class=\"wp-block-coblocks-social is-style-mask has-colors\" style=\" \"><ul><li>\n\t\t\t\t\t<a href=\"https:\/\/www.facebook.com\/sharer\/sharer.php?u=https:\/\/wiki-cloud.co\/en\/2014\/10\/sql-server-data-tools-ssdt-deteccin-de-diferencias\/&#038;title=SQL%20Server%20Data%20Tools%20(SSDT)%20\u2013%20Detecci\u00f3n%20de%20diferencias\" class=\"wp-block-button__link wp-block-coblocks-social__button wp-block-coblocks-social__button--facebook     has-padding\" title=\"Share on Facebook\" style=\"border-radius: 40px;\">\n\t\t\t\t\t\t<span class=\"wp-block-coblocks-social__icon\" style=\"height:22px;width: 22px;\"><\/span>\n\t\t\t\t\t\t<span class=\"wp-block-coblocks-social__text\" style=\"\">Share on Facebook<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/li><li>\n\t\t\t\t\t<a href=\"http:\/\/twitter.com\/share?text=SQL%20Server%20Data%20Tools%20(SSDT)%20\u2013%20Detecci\u00f3n%20de%20diferencias&#038;url=https:\/\/wiki-cloud.co\/en\/2014\/10\/sql-server-data-tools-ssdt-deteccin-de-diferencias\/\" class=\"wp-block-button__link wp-block-coblocks-social__button wp-block-coblocks-social__button--twitter     has-padding\" title=\"Share on Twitter\" style=\"border-radius: 40px;\">\n\t\t\t\t\t\t<span class=\"wp-block-coblocks-social__icon\" style=\"height:22px;width: 22px;\"><\/span>\n\t\t\t\t\t\t<span class=\"wp-block-coblocks-social__text\" style=\"\">Share on Twitter<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/li><li>\n\t\t\t\t\t<a href=\"https:\/\/pinterest.com\/pin\/create\/button\/?&#038;url=https:\/\/wiki-cloud.co\/en\/2014\/10\/sql-server-data-tools-ssdt-deteccin-de-diferencias\/&#038;description=SQL%20Server%20Data%20Tools%20(SSDT)%20\u2013%20Detecci\u00f3n%20de%20diferencias&#038;media=https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_coverpage_microsoft_ssdt_deteccion_diferencias_780x420.png\" class=\"wp-block-button__link wp-block-coblocks-social__button wp-block-coblocks-social__button--pinterest     has-padding\" title=\"Share on Pinterest\" style=\"border-radius: 40px;\">\n\t\t\t\t\t\t<span class=\"wp-block-coblocks-social__icon\" style=\"height:22px;width: 22px;\"><\/span>\n\t\t\t\t\t\t<span class=\"wp-block-coblocks-social__text\" style=\"\">Share on Pinterest<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/li><li>\n\t\t\t\t\t<a href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https:\/\/wiki-cloud.co\/en\/2014\/10\/sql-server-data-tools-ssdt-deteccin-de-diferencias\/&#038;title=SQL%20Server%20Data%20Tools%20(SSDT)%20\u2013%20Detecci\u00f3n%20de%20diferencias\" class=\"wp-block-button__link wp-block-coblocks-social__button wp-block-coblocks-social__button--linkedin     has-padding\" title=\"Share on Linkedin\" style=\"border-radius: 40px;\">\n\t\t\t\t\t\t<span class=\"wp-block-coblocks-social__icon\" style=\"height:22px;width: 22px;\"><\/span>\n\t\t\t\t\t\t<span class=\"wp-block-coblocks-social__text\" style=\"\">Share on Linkedin<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/li><li>\n\t\t\t\t\t<a href=\"mailto:?subject=SQL%20Server%20Data%20Tools%20(SSDT)%20\u2013%20Detecci\u00f3n%20de%20diferencias&#038;body=SQL%20Server%20Data%20Tools%20(SSDT)%20\u2013%20Detecci\u00f3n%20de%20diferencias&mdash;https:\/\/wiki-cloud.co\/en\/2014\/10\/sql-server-data-tools-ssdt-deteccin-de-diferencias\/\" class=\"wp-block-button__link wp-block-coblocks-social__button wp-block-coblocks-social__button--email     has-padding\" title=\"Share via Email\" style=\"border-radius: 40px;\">\n\t\t\t\t\t\t<span class=\"wp-block-coblocks-social__icon\" style=\"height:22px;width: 22px;\"><\/span>\n\t\t\t\t\t\t<span class=\"wp-block-coblocks-social__text\" style=\"\">Share via Email<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/li><li>\n\t\t\t\t\t<a href=\"https:\/\/tumblr.com\/share\/link?url=https:\/\/wiki-cloud.co\/en\/2014\/10\/sql-server-data-tools-ssdt-deteccin-de-diferencias\/&#038;name=SQL%20Server%20Data%20Tools%20(SSDT)%20\u2013%20Detecci\u00f3n%20de%20diferencias\" class=\"wp-block-button__link wp-block-coblocks-social__button wp-block-coblocks-social__button--tumblr     has-padding\" title=\"Share on Tumblr\" style=\"border-radius: 40px;\">\n\t\t\t\t\t\t<span class=\"wp-block-coblocks-social__icon\" style=\"height:22px;width: 22px;\"><\/span>\n\t\t\t\t\t\t<span class=\"wp-block-coblocks-social__text\" style=\"\">Share on Tumblr<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/li><li>\n\t\t\t\t\t<a href=\"https:\/\/plus.google.com\/share?url=https:\/\/wiki-cloud.co\/en\/2014\/10\/sql-server-data-tools-ssdt-deteccin-de-diferencias\/\" class=\"wp-block-button__link wp-block-coblocks-social__button wp-block-coblocks-social__button--google     has-padding\" title=\"Share on Google\" style=\"border-radius: 40px;\">\n\t\t\t\t\t\t<span class=\"wp-block-coblocks-social__icon\" style=\"height:22px;width: 22px;\"><\/span>\n\t\t\t\t\t\t<span class=\"wp-block-coblocks-social__text\" style=\"\">Share on Google<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/li><li>\n\t\t\t\t\t<a href=\"https:\/\/www.reddit.com\/submit?url=https:\/\/wiki-cloud.co\/en\/2014\/10\/sql-server-data-tools-ssdt-deteccin-de-diferencias\/\" class=\"wp-block-button__link wp-block-coblocks-social__button wp-block-coblocks-social__button--reddit     has-padding\" title=\"Share on Reddit\" style=\"border-radius: 40px;\">\n\t\t\t\t\t\t<span class=\"wp-block-coblocks-social__icon\" style=\"height:22px;width: 22px;\"><\/span>\n\t\t\t\t\t\t<span class=\"wp-block-coblocks-social__text\" style=\"\">Share on Reddit<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/li><\/ul><\/div>\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>*Actualizado a SQL Server 2014 y Visual Studio 2013 Continuando con esta serie de art\u00edculos sobre SQL Server Data Tools (SSDT), hablaremos sobre las<\/p>","protected":false},"author":1,"featured_media":1481,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","footnotes":""},"categories":[50,28,76],"tags":[],"class_list":["post-854","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft","category-sql-server","category-visual-studio"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Server Data Tools (SSDT) \u2013 Detecci\u00f3n de diferencias - Wiki Cloud<\/title>\n<meta name=\"description\" content=\"Continuando con esta serie de art\u00edculos sobre SQL Server Data Tools (SSDT), hablaremos sobre las detecciones de diferencias que se encuentra en el grupo de desarrollo conectado.\" \/>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Data Tools (SSDT) \u2013 Detecci\u00f3n de diferencias - Wiki Cloud\" \/>\n<meta property=\"og:description\" content=\"Continuando con esta serie de art\u00edculos sobre SQL Server Data Tools (SSDT), hablaremos sobre las detecciones de diferencias que se encuentra en el grupo de desarrollo conectado.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/wiki-cloud.co\/en\/2014\/10\/sql-server-data-tools-ssdt-deteccin-de-diferencias\/\" \/>\n<meta property=\"og:site_name\" content=\"Wiki Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2014-10-13T17:28:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-06-12T23:49:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_coverpage_microsoft_ssdt_deteccion_diferencias_780x420.png\" \/>\n\t<meta property=\"og:image:width\" content=\"780\" \/>\n\t<meta property=\"og:image:height\" content=\"420\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"John Bulla\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"John Bulla\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/en\\\/2014\\\/10\\\/sql-server-data-tools-ssdt-deteccin-de-diferencias\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/en\\\/2014\\\/10\\\/sql-server-data-tools-ssdt-deteccin-de-diferencias\\\/\"},\"author\":{\"name\":\"John Bulla\",\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/es\\\/#\\\/schema\\\/person\\\/b73ea518d1f5e5fc1dba6f6fadb1e0ed\"},\"headline\":\"SQL Server Data Tools (SSDT) \u2013 Detecci\u00f3n de diferencias\",\"datePublished\":\"2014-10-13T17:28:27+00:00\",\"dateModified\":\"2020-06-12T23:49:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/en\\\/2014\\\/10\\\/sql-server-data-tools-ssdt-deteccin-de-diferencias\\\/\"},\"wordCount\":1547,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/es\\\/#\\\/schema\\\/person\\\/b73ea518d1f5e5fc1dba6f6fadb1e0ed\"},\"image\":{\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/en\\\/2014\\\/10\\\/sql-server-data-tools-ssdt-deteccin-de-diferencias\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/wiki-cloud.co\\\/wp-content\\\/uploads\\\/2014\\\/10\\\/article_coverpage_microsoft_ssdt_deteccion_diferencias_780x420.png\",\"articleSection\":[\"Microsoft\",\"SQL Server\",\"Visual Studio\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/wiki-cloud.co\\\/en\\\/2014\\\/10\\\/sql-server-data-tools-ssdt-deteccin-de-diferencias\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/en\\\/2014\\\/10\\\/sql-server-data-tools-ssdt-deteccin-de-diferencias\\\/\",\"url\":\"https:\\\/\\\/wiki-cloud.co\\\/en\\\/2014\\\/10\\\/sql-server-data-tools-ssdt-deteccin-de-diferencias\\\/\",\"name\":\"SQL Server Data Tools (SSDT) \u2013 Detecci\u00f3n de diferencias - Wiki Cloud\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/es\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/en\\\/2014\\\/10\\\/sql-server-data-tools-ssdt-deteccin-de-diferencias\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/en\\\/2014\\\/10\\\/sql-server-data-tools-ssdt-deteccin-de-diferencias\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/wiki-cloud.co\\\/wp-content\\\/uploads\\\/2014\\\/10\\\/article_coverpage_microsoft_ssdt_deteccion_diferencias_780x420.png\",\"datePublished\":\"2014-10-13T17:28:27+00:00\",\"dateModified\":\"2020-06-12T23:49:54+00:00\",\"description\":\"Continuando con esta serie de art\u00edculos sobre SQL Server Data Tools (SSDT), hablaremos sobre las detecciones de diferencias que se encuentra en el grupo de desarrollo conectado.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/en\\\/2014\\\/10\\\/sql-server-data-tools-ssdt-deteccin-de-diferencias\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/wiki-cloud.co\\\/en\\\/2014\\\/10\\\/sql-server-data-tools-ssdt-deteccin-de-diferencias\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/en\\\/2014\\\/10\\\/sql-server-data-tools-ssdt-deteccin-de-diferencias\\\/#primaryimage\",\"url\":\"https:\\\/\\\/wiki-cloud.co\\\/wp-content\\\/uploads\\\/2014\\\/10\\\/article_coverpage_microsoft_ssdt_deteccion_diferencias_780x420.png\",\"contentUrl\":\"https:\\\/\\\/wiki-cloud.co\\\/wp-content\\\/uploads\\\/2014\\\/10\\\/article_coverpage_microsoft_ssdt_deteccion_diferencias_780x420.png\",\"width\":780,\"height\":420},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/en\\\/2014\\\/10\\\/sql-server-data-tools-ssdt-deteccin-de-diferencias\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/wiki-cloud.co\\\/es\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Data Tools (SSDT) \u2013 Detecci\u00f3n de diferencias\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/es\\\/#website\",\"url\":\"https:\\\/\\\/wiki-cloud.co\\\/es\\\/\",\"name\":\"Wiki Cloud\",\"description\":\"All about the cloud world\",\"publisher\":{\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/es\\\/#\\\/schema\\\/person\\\/b73ea518d1f5e5fc1dba6f6fadb1e0ed\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/wiki-cloud.co\\\/es\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/es\\\/#\\\/schema\\\/person\\\/b73ea518d1f5e5fc1dba6f6fadb1e0ed\",\"name\":\"John Bulla\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/logo_wiki_cloud_400x130.png\",\"url\":\"https:\\\/\\\/wiki-cloud.co\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/logo_wiki_cloud_400x130.png\",\"contentUrl\":\"https:\\\/\\\/wiki-cloud.co\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/logo_wiki_cloud_400x130.png\",\"width\":400,\"height\":131,\"caption\":\"John Bulla\"},\"logo\":{\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/logo_wiki_cloud_400x130.png\"},\"sameAs\":[\"https:\\\/\\\/wiki-cloud.co\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server Data Tools (SSDT) \u2013 Detecci\u00f3n de diferencias - Wiki Cloud","description":"Continuando con esta serie de art\u00edculos sobre SQL Server Data Tools (SSDT), hablaremos sobre las detecciones de diferencias que se encuentra en el grupo de desarrollo conectado.","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"SQL Server Data Tools (SSDT) \u2013 Detecci\u00f3n de diferencias - Wiki Cloud","og_description":"Continuando con esta serie de art\u00edculos sobre SQL Server Data Tools (SSDT), hablaremos sobre las detecciones de diferencias que se encuentra en el grupo de desarrollo conectado.","og_url":"https:\/\/wiki-cloud.co\/en\/2014\/10\/sql-server-data-tools-ssdt-deteccin-de-diferencias\/","og_site_name":"Wiki Cloud","article_published_time":"2014-10-13T17:28:27+00:00","article_modified_time":"2020-06-12T23:49:54+00:00","og_image":[{"width":780,"height":420,"url":"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_coverpage_microsoft_ssdt_deteccion_diferencias_780x420.png","type":"image\/png"}],"author":"John Bulla","twitter_card":"summary_large_image","twitter_misc":{"Written by":"John Bulla","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/wiki-cloud.co\/en\/2014\/10\/sql-server-data-tools-ssdt-deteccin-de-diferencias\/#article","isPartOf":{"@id":"https:\/\/wiki-cloud.co\/en\/2014\/10\/sql-server-data-tools-ssdt-deteccin-de-diferencias\/"},"author":{"name":"John Bulla","@id":"https:\/\/wiki-cloud.co\/es\/#\/schema\/person\/b73ea518d1f5e5fc1dba6f6fadb1e0ed"},"headline":"SQL Server Data Tools (SSDT) \u2013 Detecci\u00f3n de diferencias","datePublished":"2014-10-13T17:28:27+00:00","dateModified":"2020-06-12T23:49:54+00:00","mainEntityOfPage":{"@id":"https:\/\/wiki-cloud.co\/en\/2014\/10\/sql-server-data-tools-ssdt-deteccin-de-diferencias\/"},"wordCount":1547,"commentCount":0,"publisher":{"@id":"https:\/\/wiki-cloud.co\/es\/#\/schema\/person\/b73ea518d1f5e5fc1dba6f6fadb1e0ed"},"image":{"@id":"https:\/\/wiki-cloud.co\/en\/2014\/10\/sql-server-data-tools-ssdt-deteccin-de-diferencias\/#primaryimage"},"thumbnailUrl":"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_coverpage_microsoft_ssdt_deteccion_diferencias_780x420.png","articleSection":["Microsoft","SQL Server","Visual Studio"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/wiki-cloud.co\/en\/2014\/10\/sql-server-data-tools-ssdt-deteccin-de-diferencias\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/wiki-cloud.co\/en\/2014\/10\/sql-server-data-tools-ssdt-deteccin-de-diferencias\/","url":"https:\/\/wiki-cloud.co\/en\/2014\/10\/sql-server-data-tools-ssdt-deteccin-de-diferencias\/","name":"SQL Server Data Tools (SSDT) \u2013 Detecci\u00f3n de diferencias - Wiki Cloud","isPartOf":{"@id":"https:\/\/wiki-cloud.co\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/wiki-cloud.co\/en\/2014\/10\/sql-server-data-tools-ssdt-deteccin-de-diferencias\/#primaryimage"},"image":{"@id":"https:\/\/wiki-cloud.co\/en\/2014\/10\/sql-server-data-tools-ssdt-deteccin-de-diferencias\/#primaryimage"},"thumbnailUrl":"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_coverpage_microsoft_ssdt_deteccion_diferencias_780x420.png","datePublished":"2014-10-13T17:28:27+00:00","dateModified":"2020-06-12T23:49:54+00:00","description":"Continuando con esta serie de art\u00edculos sobre SQL Server Data Tools (SSDT), hablaremos sobre las detecciones de diferencias que se encuentra en el grupo de desarrollo conectado.","breadcrumb":{"@id":"https:\/\/wiki-cloud.co\/en\/2014\/10\/sql-server-data-tools-ssdt-deteccin-de-diferencias\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/wiki-cloud.co\/en\/2014\/10\/sql-server-data-tools-ssdt-deteccin-de-diferencias\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/wiki-cloud.co\/en\/2014\/10\/sql-server-data-tools-ssdt-deteccin-de-diferencias\/#primaryimage","url":"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_coverpage_microsoft_ssdt_deteccion_diferencias_780x420.png","contentUrl":"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2014\/10\/article_coverpage_microsoft_ssdt_deteccion_diferencias_780x420.png","width":780,"height":420},{"@type":"BreadcrumbList","@id":"https:\/\/wiki-cloud.co\/en\/2014\/10\/sql-server-data-tools-ssdt-deteccin-de-diferencias\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/wiki-cloud.co\/es\/"},{"@type":"ListItem","position":2,"name":"SQL Server Data Tools (SSDT) \u2013 Detecci\u00f3n de diferencias"}]},{"@type":"WebSite","@id":"https:\/\/wiki-cloud.co\/es\/#website","url":"https:\/\/wiki-cloud.co\/es\/","name":"Wiki Cloud","description":"All about the cloud world","publisher":{"@id":"https:\/\/wiki-cloud.co\/es\/#\/schema\/person\/b73ea518d1f5e5fc1dba6f6fadb1e0ed"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/wiki-cloud.co\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/wiki-cloud.co\/es\/#\/schema\/person\/b73ea518d1f5e5fc1dba6f6fadb1e0ed","name":"John Bulla","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2020\/06\/logo_wiki_cloud_400x130.png","url":"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2020\/06\/logo_wiki_cloud_400x130.png","contentUrl":"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2020\/06\/logo_wiki_cloud_400x130.png","width":400,"height":131,"caption":"John Bulla"},"logo":{"@id":"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2020\/06\/logo_wiki_cloud_400x130.png"},"sameAs":["https:\/\/wiki-cloud.co"]}]}},"_links":{"self":[{"href":"https:\/\/wiki-cloud.co\/en\/wp-json\/wp\/v2\/posts\/854","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wiki-cloud.co\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wiki-cloud.co\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wiki-cloud.co\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wiki-cloud.co\/en\/wp-json\/wp\/v2\/comments?post=854"}],"version-history":[{"count":4,"href":"https:\/\/wiki-cloud.co\/en\/wp-json\/wp\/v2\/posts\/854\/revisions"}],"predecessor-version":[{"id":1490,"href":"https:\/\/wiki-cloud.co\/en\/wp-json\/wp\/v2\/posts\/854\/revisions\/1490"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wiki-cloud.co\/en\/wp-json\/wp\/v2\/media\/1481"}],"wp:attachment":[{"href":"https:\/\/wiki-cloud.co\/en\/wp-json\/wp\/v2\/media?parent=854"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wiki-cloud.co\/en\/wp-json\/wp\/v2\/categories?post=854"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wiki-cloud.co\/en\/wp-json\/wp\/v2\/tags?post=854"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}