{"id":835,"date":"2013-08-26T07:11:34","date_gmt":"2013-08-26T07:11:34","guid":{"rendered":"http:\/\/geeks.ms\/johnbulla\/2013\/08\/26\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\/"},"modified":"2020-06-12T18:51:08","modified_gmt":"2020-06-12T23:51:08","slug":"sql-server-data-tools-ssdt-experiencia-familiar-de-usuario","status":"publish","type":"post","link":"https:\/\/wiki-cloud.co\/en\/2013\/08\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\/","title":{"rendered":"SQL Server Data Tools (SSDT) \u2013 Experiencia familiar de Usuario"},"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\/2013\/08\/article_image_SSDT_ExperienciaFamiliarUsuario_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>Continuando con esta serie de art\u00edculos sobre SQL Server Data Tools (SSDT), hablaremos sobre las herramientas de experiencia familiar de usuario 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\/2013\/08\/article_image_SSDT_ExperienciaFamiliarUsuario_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-width: 0px;\" src=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2013\/08\/article_image_SSDT_ExperienciaFamiliarUsuario_03.png\" width=\"438\" height=\"145\" border=\"0\" \/><\/p>\n<p><strong>Experiencia Familiar de Usuario<\/strong><\/p>\n<ul>\n<li><strong>SQL Server Object Explorer<\/strong><\/li>\n<\/ul>\n<blockquote>\n<p align=\"justify\">Visual Studio introdujo una nueva caracter\u00edstica llamada SQL Server Object Explorer \u00f3 Explorador de objetos de SQL Server. En versiones anteriores de Visual Studio, tenemos el Explorador de servidores, lo que abre una conexi\u00f3n particular pero solo trabaja con una sola base de datos. Ahora con el nuevo SQL Server Object Explorer, es posible manipular m\u00faltiples bases de datos de un servidor de base de datos.<\/p>\n<p align=\"justify\">Ahora desde el propio visual studio, podemos crear tablas, definir varias claves, crear procedimientos almacenados y funciones.<\/p>\n<p align=\"justify\">El SQL Server Object Explorer es el mismo que utilizamos en SQL Server Management Studio solo que en esta oportunidad lo tenemos incorporado en Visual Studio. Esta caracter\u00edstica aplica para Visual Studio 2010, Visual Studio 2012 y Visual Studio 2013<\/p>\n<p align=\"justify\">Para tener acceso al <strong>SQL Server Object Explorer<\/strong> \u00f3 <strong>Explorador de Objetos de SQL Server<\/strong> damos clic en el men\u00fa <strong>Ver<\/strong>, seleccionamos la opci\u00f3n <strong>SQL Server Object Explorer<\/strong> \u00f3 <strong>Explorador de objetos de SQL Server<\/strong>.<\/p>\n<p align=\"justify\"><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2013\/08\/article_image_SSDT_ExperienciaFamiliarUsuario_04.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\/2013\/08\/article_image_SSDT_ExperienciaFamiliarUsuario_04.png\" width=\"389\" height=\"272\" border=\"0\" \/><\/a><\/p>\n<p align=\"center\">Figura 1. \u2013 Opci\u00f3n de SQL Server Object Explorer en el men\u00fa Ver en Visual Studio 2010.<\/p>\n<p align=\"justify\"><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2013\/08\/article_image_SSDT_ExperienciaFamiliarUsuario_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\/2013\/08\/article_image_SSDT_ExperienciaFamiliarUsuario_05.png\" width=\"406\" height=\"282\" border=\"0\" \/><\/a><\/p>\n<p align=\"center\">Figura 2. \u2013 Opci\u00f3n de SQL Server Object Explorer en el men\u00fa Ver en Visual Studio 2012.<\/p>\n<p align=\"left\"><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2013\/08\/article_image_SSDT_ExperienciaFamiliarUsuario_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: 0px; border-width: 0px;\" src=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2013\/08\/article_image_SSDT_ExperienciaFamiliarUsuario_06.png\" width=\"409\" height=\"279\" border=\"0\" \/><\/a><\/p>\n<p align=\"center\">Figura 3. \u2013 Opci\u00f3n de SQL Server Object Explorer en el men\u00fa Ver en Visual Studio 2013.<\/p>\n<p align=\"left\"><strong>Adicionar un servidor<\/strong><\/p>\n<p align=\"justify\">Para adicionar un servidor de base de datos desde el SQL Sever Object Explorer o Explorador de Objetos de SQL Server simplemente damos clic derecho sobre la opci\u00f3n de SQL Server y seleccionamos adicionar un nuevo servidor o damos clic en el icono de adicionar un nuevo servidor.<\/p>\n<p align=\"justify\">Una vez seleccionamos la opci\u00f3n de adicionar un servidor de SQL Server, se abrir\u00e1 la ventana de Conectar a servidor, la misma ventana del SQL Server Management Studio donde se especifica el nombre del servidor y el tipo de autenticaci\u00f3n.<\/p>\n<p align=\"justify\"><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2013\/08\/article_image_SSDT_ExperienciaFamiliarUsuario_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\/2013\/08\/article_image_SSDT_ExperienciaFamiliarUsuario_07.png\" width=\"459\" height=\"450\" border=\"0\" \/><\/a><\/p>\n<p align=\"center\">Figura 4. \u2013 Adicionar un Servidor en el SQL Server Object Explorer de Visual Studio 2010.<\/p>\n<p align=\"center\"><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2013\/08\/article_image_SSDT_ExperienciaFamiliarUsuario_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\/2013\/08\/article_image_SSDT_ExperienciaFamiliarUsuario_08.png\" width=\"459\" height=\"446\" border=\"0\" \/><\/a><\/p>\n<p align=\"center\">Figura 5. \u2013 Adicionar un Servidor en el SQL Server Object Explorer de Visual Studio 2012.<\/p>\n<p align=\"center\"><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2013\/08\/article_image_SSDT_ExperienciaFamiliarUsuario_09.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px; border-width: 0px;\" src=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2013\/08\/article_image_SSDT_ExperienciaFamiliarUsuario_09.png\" width=\"464\" height=\"504\" border=\"0\" \/><\/a><\/p>\n<p align=\"center\">Figura 6. \u2013 Adicionar un Servidor en el SQL Server Object Explorer de Visual Studio 2013.<\/p>\n<\/blockquote>\n<blockquote>\n<p align=\"justify\">Una vez adicionamos el servidor de base de datos ya podremos crear tablas, definir varias claves, crear procedimientos almacenados y funciones.<\/p>\n<p align=\"justify\"><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2013\/08\/article_image_SSDT_ExperienciaFamiliarUsuario_10.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\/2013\/08\/article_image_SSDT_ExperienciaFamiliarUsuario_10.png\" width=\"487\" height=\"404\" border=\"0\" \/><\/a><\/p>\n<\/blockquote>\n<blockquote>\n<p align=\"center\">Figura 7. \u2013 SQL Server Object Explorer de Visual Studio 2010.<\/p>\n<\/blockquote>\n<blockquote>\n<p align=\"center\"><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2013\/08\/article_image_SSDT_ExperienciaFamiliarUsuario_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\/2013\/08\/article_image_SSDT_ExperienciaFamiliarUsuario_11.png\" width=\"487\" height=\"394\" border=\"0\" \/><\/a><\/p>\n<\/blockquote>\n<blockquote>\n<p align=\"center\">Figura 8. \u2013 SQL Server Object Explorer en Visual Studio 2012.<\/p>\n<p align=\"center\"><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2013\/08\/article_image_SSDT_ExperienciaFamiliarUsuario_12.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px; border-width: 0px;\" src=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2013\/08\/article_image_SSDT_ExperienciaFamiliarUsuario_12.png\" width=\"464\" height=\"443\" border=\"0\" \/><\/a><\/p>\n<p align=\"center\">Figura 9. \u2013 SQL Server Object Explorer en Visual Studio 2013.<\/p>\n<\/blockquote>\n<ul>\n<li><strong>T-SQL Editor<\/strong><\/li>\n<\/ul>\n<blockquote>\n<p align=\"justify\">El Editor de Transact-SQL ofrece una experiencia completa de edici\u00f3n, depuraci\u00f3n y ejecuci\u00f3n de comandos Transact-SQL en Visual Studio. Puede iniciar el editor haciendo clic en el men\u00fa SQL \u2013&gt; Transact-SQL Editor \u2013&gt; New Query o Nueva Consulta. Tambi\u00e9n puede iniciar el editor haciendo clic derecho sobre una base de datos en el Explorador de objetos de SQL Server y seleccionamos New Query o Nueva consulta en el men\u00fa contextual. La siguiente es una captura de pantalla del editor de Transact-SQL en Visual Studio:<\/p>\n<p align=\"justify\"><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2013\/08\/article_image_SSDT_ExperienciaFamiliarUsuario_13.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\/2013\/08\/article_image_SSDT_ExperienciaFamiliarUsuario_13.png\" width=\"487\" height=\"391\" border=\"0\" \/><\/a><\/p>\n<\/blockquote>\n<blockquote>\n<p align=\"center\">Figura 10. \u2013 Editor de Transact-SQL en Visual Studio 2010.<\/p>\n<p><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2013\/08\/article_image_SSDT_ExperienciaFamiliarUsuario_14.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;\" title=\"image\" src=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2013\/08\/article_image_SSDT_ExperienciaFamiliarUsuario_14.png\" alt=\"image\" width=\"487\" height=\"360\" border=\"0\" \/><\/a><\/p>\n<\/blockquote>\n<blockquote>\n<p align=\"center\">Figura 11. \u2013 Editor de Transact-SQL en Visual Studio 2012.<\/p>\n<p align=\"center\"><a href=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2013\/08\/article_image_SSDT_ExperienciaFamiliarUsuario_15.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px; border-width: 0px;\" src=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2013\/08\/article_image_SSDT_ExperienciaFamiliarUsuario_15.png\" width=\"491\" height=\"454\" border=\"0\" \/><\/a><\/p>\n<p align=\"center\">Figura 12. \u2013 Editor de Transact-SQL en Visual Studio 2013.<\/p>\n<p align=\"justify\">Los siguientes son los detalles acerca de las opciones de la barra de herramientas del editor de Transact-SQL (de izquierda a derecha):<\/p>\n<ul>\n<li>\n<div align=\"justify\">Ejecuta o depura secuencias de comandos<\/div>\n<\/li>\n<li>\n<div align=\"justify\">Detiene la ejecuci\u00f3n<\/div>\n<\/li>\n<li>\n<div align=\"justify\">Comprueba la sintaxis<\/div>\n<\/li>\n<li>\n<div align=\"justify\">Muestra el plan de ejecuci\u00f3n estimado<\/div>\n<\/li>\n<li>\n<div align=\"justify\">Conecta al servidor de base de datos<\/div>\n<\/li>\n<li>\n<div align=\"justify\">Desconecta del servidor de base de datos<\/div>\n<\/li>\n<li>\n<div align=\"justify\">Selecciona la base de datos<\/div>\n<\/li>\n<li>\n<div align=\"justify\">Nueva consulta (abre una nueva ventana del editor de Transact-SQL)<\/div>\n<\/li>\n<li>\n<div align=\"justify\">Resultados como GRID, resultados en forma de texto, para presentar los resultados (seleccionar de lista desplegable)<\/div>\n<\/li>\n<li>\n<div align=\"justify\">Muestra plan de ejecuci\u00f3n real<\/div>\n<\/li>\n<li>\n<div align=\"justify\">Modo SQLCMD Set \/ unset<\/div>\n<\/li>\n<\/ul>\n<\/blockquote>\n<p align=\"justify\">M\u00e1s art\u00edculos:<\/p>\n<ul>\n<li>\n<div align=\"justify\"><a href=\"https:\/\/wiki-cloud.co\/en\/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>Best Regards,<\/p>\n\n\n<p><strong>Share:<\/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\/2013\/08\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\/&#038;title=SQL%20Server%20Data%20Tools%20(SSDT)%20\u2013%20Experiencia%20familiar%20de%20Usuario\" 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%20Experiencia%20familiar%20de%20Usuario&#038;url=https:\/\/wiki-cloud.co\/en\/2013\/08\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\/\" 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\/2013\/08\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\/&#038;description=SQL%20Server%20Data%20Tools%20(SSDT)%20\u2013%20Experiencia%20familiar%20de%20Usuario&#038;media=https:\/\/wiki-cloud.co\/wp-content\/uploads\/2013\/08\/article_coverpage_microsoft_ssdt_experiencia_familiar_usuario_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\/2013\/08\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\/&#038;title=SQL%20Server%20Data%20Tools%20(SSDT)%20\u2013%20Experiencia%20familiar%20de%20Usuario\" 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%20Experiencia%20familiar%20de%20Usuario&#038;body=SQL%20Server%20Data%20Tools%20(SSDT)%20\u2013%20Experiencia%20familiar%20de%20Usuario&mdash;https:\/\/wiki-cloud.co\/en\/2013\/08\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\/\" 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\/2013\/08\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\/&#038;name=SQL%20Server%20Data%20Tools%20(SSDT)%20\u2013%20Experiencia%20familiar%20de%20Usuario\" 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\/2013\/08\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\/\" 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\/2013\/08\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\/\" 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>","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":1485,"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-835","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 Experiencia familiar de Usuario - Wiki Cloud<\/title>\n<meta name=\"description\" content=\"Visual Studio introdujo una nueva caracter\u00edstica llamada SQL Server Object Explorer \u00f3 Explorador de objetos de SQL Server. En versiones anteriores de Visual Studio, tenemos el Explorador de servidores, lo que abre una conexi\u00f3n particular pero solo trabaja con una sola base de datos. Ahora con el nuevo SQL Server Object Explorer, es posible manipular m\u00faltiples bases de datos de un servidor de base de datos.\" \/>\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 Experiencia familiar de Usuario - Wiki Cloud\" \/>\n<meta property=\"og:description\" content=\"Visual Studio introdujo una nueva caracter\u00edstica llamada SQL Server Object Explorer \u00f3 Explorador de objetos de SQL Server. En versiones anteriores de Visual Studio, tenemos el Explorador de servidores, lo que abre una conexi\u00f3n particular pero solo trabaja con una sola base de datos. Ahora con el nuevo SQL Server Object Explorer, es posible manipular m\u00faltiples bases de datos de un servidor de base de datos.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/wiki-cloud.co\/en\/2013\/08\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\/\" \/>\n<meta property=\"og:site_name\" content=\"Wiki Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2013-08-26T07:11:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-06-12T23:51:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2013\/08\/article_coverpage_microsoft_ssdt_experiencia_familiar_usuario_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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/es\\\/2013\\\/08\\\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/es\\\/2013\\\/08\\\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\\\/\"},\"author\":{\"name\":\"John Bulla\",\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/es\\\/#\\\/schema\\\/person\\\/b73ea518d1f5e5fc1dba6f6fadb1e0ed\"},\"headline\":\"SQL Server Data Tools (SSDT) \u2013 Experiencia familiar de Usuario\",\"datePublished\":\"2013-08-26T07:11:34+00:00\",\"dateModified\":\"2020-06-12T23:51:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/es\\\/2013\\\/08\\\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\\\/\"},\"wordCount\":656,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/es\\\/#\\\/schema\\\/person\\\/b73ea518d1f5e5fc1dba6f6fadb1e0ed\"},\"image\":{\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/es\\\/2013\\\/08\\\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/wiki-cloud.co\\\/wp-content\\\/uploads\\\/2013\\\/08\\\/article_coverpage_microsoft_ssdt_experiencia_familiar_usuario_780x420.png\",\"articleSection\":[\"Microsoft\",\"SQL Server\",\"Visual Studio\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/wiki-cloud.co\\\/es\\\/2013\\\/08\\\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/es\\\/2013\\\/08\\\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\\\/\",\"url\":\"https:\\\/\\\/wiki-cloud.co\\\/es\\\/2013\\\/08\\\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\\\/\",\"name\":\"SQL Server Data Tools (SSDT) \u2013 Experiencia familiar de Usuario - Wiki Cloud\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/es\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/es\\\/2013\\\/08\\\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/es\\\/2013\\\/08\\\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/wiki-cloud.co\\\/wp-content\\\/uploads\\\/2013\\\/08\\\/article_coverpage_microsoft_ssdt_experiencia_familiar_usuario_780x420.png\",\"datePublished\":\"2013-08-26T07:11:34+00:00\",\"dateModified\":\"2020-06-12T23:51:08+00:00\",\"description\":\"Visual Studio introdujo una nueva caracter\u00edstica llamada SQL Server Object Explorer \u00f3 Explorador de objetos de SQL Server. En versiones anteriores de Visual Studio, tenemos el Explorador de servidores, lo que abre una conexi\u00f3n particular pero solo trabaja con una sola base de datos. Ahora con el nuevo SQL Server Object Explorer, es posible manipular m\u00faltiples bases de datos de un servidor de base de datos.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/es\\\/2013\\\/08\\\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/wiki-cloud.co\\\/es\\\/2013\\\/08\\\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/es\\\/2013\\\/08\\\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\\\/#primaryimage\",\"url\":\"https:\\\/\\\/wiki-cloud.co\\\/wp-content\\\/uploads\\\/2013\\\/08\\\/article_coverpage_microsoft_ssdt_experiencia_familiar_usuario_780x420.png\",\"contentUrl\":\"https:\\\/\\\/wiki-cloud.co\\\/wp-content\\\/uploads\\\/2013\\\/08\\\/article_coverpage_microsoft_ssdt_experiencia_familiar_usuario_780x420.png\",\"width\":780,\"height\":420},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/wiki-cloud.co\\\/es\\\/2013\\\/08\\\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\\\/#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 Experiencia familiar de Usuario\"}]},{\"@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 Experiencia familiar de Usuario - Wiki Cloud","description":"Visual Studio introdujo una nueva caracter\u00edstica llamada SQL Server Object Explorer \u00f3 Explorador de objetos de SQL Server. En versiones anteriores de Visual Studio, tenemos el Explorador de servidores, lo que abre una conexi\u00f3n particular pero solo trabaja con una sola base de datos. Ahora con el nuevo SQL Server Object Explorer, es posible manipular m\u00faltiples bases de datos de un servidor de base de datos.","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 Experiencia familiar de Usuario - Wiki Cloud","og_description":"Visual Studio introdujo una nueva caracter\u00edstica llamada SQL Server Object Explorer \u00f3 Explorador de objetos de SQL Server. En versiones anteriores de Visual Studio, tenemos el Explorador de servidores, lo que abre una conexi\u00f3n particular pero solo trabaja con una sola base de datos. Ahora con el nuevo SQL Server Object Explorer, es posible manipular m\u00faltiples bases de datos de un servidor de base de datos.","og_url":"https:\/\/wiki-cloud.co\/en\/2013\/08\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\/","og_site_name":"Wiki Cloud","article_published_time":"2013-08-26T07:11:34+00:00","article_modified_time":"2020-06-12T23:51:08+00:00","og_image":[{"width":780,"height":420,"url":"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2013\/08\/article_coverpage_microsoft_ssdt_experiencia_familiar_usuario_780x420.png","type":"image\/png"}],"author":"John Bulla","twitter_card":"summary_large_image","twitter_misc":{"Written by":"John Bulla","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/wiki-cloud.co\/es\/2013\/08\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\/#article","isPartOf":{"@id":"https:\/\/wiki-cloud.co\/es\/2013\/08\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\/"},"author":{"name":"John Bulla","@id":"https:\/\/wiki-cloud.co\/es\/#\/schema\/person\/b73ea518d1f5e5fc1dba6f6fadb1e0ed"},"headline":"SQL Server Data Tools (SSDT) \u2013 Experiencia familiar de Usuario","datePublished":"2013-08-26T07:11:34+00:00","dateModified":"2020-06-12T23:51:08+00:00","mainEntityOfPage":{"@id":"https:\/\/wiki-cloud.co\/es\/2013\/08\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\/"},"wordCount":656,"commentCount":0,"publisher":{"@id":"https:\/\/wiki-cloud.co\/es\/#\/schema\/person\/b73ea518d1f5e5fc1dba6f6fadb1e0ed"},"image":{"@id":"https:\/\/wiki-cloud.co\/es\/2013\/08\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\/#primaryimage"},"thumbnailUrl":"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2013\/08\/article_coverpage_microsoft_ssdt_experiencia_familiar_usuario_780x420.png","articleSection":["Microsoft","SQL Server","Visual Studio"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/wiki-cloud.co\/es\/2013\/08\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/wiki-cloud.co\/es\/2013\/08\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\/","url":"https:\/\/wiki-cloud.co\/es\/2013\/08\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\/","name":"SQL Server Data Tools (SSDT) \u2013 Experiencia familiar de Usuario - Wiki Cloud","isPartOf":{"@id":"https:\/\/wiki-cloud.co\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/wiki-cloud.co\/es\/2013\/08\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\/#primaryimage"},"image":{"@id":"https:\/\/wiki-cloud.co\/es\/2013\/08\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\/#primaryimage"},"thumbnailUrl":"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2013\/08\/article_coverpage_microsoft_ssdt_experiencia_familiar_usuario_780x420.png","datePublished":"2013-08-26T07:11:34+00:00","dateModified":"2020-06-12T23:51:08+00:00","description":"Visual Studio introdujo una nueva caracter\u00edstica llamada SQL Server Object Explorer \u00f3 Explorador de objetos de SQL Server. En versiones anteriores de Visual Studio, tenemos el Explorador de servidores, lo que abre una conexi\u00f3n particular pero solo trabaja con una sola base de datos. Ahora con el nuevo SQL Server Object Explorer, es posible manipular m\u00faltiples bases de datos de un servidor de base de datos.","breadcrumb":{"@id":"https:\/\/wiki-cloud.co\/es\/2013\/08\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/wiki-cloud.co\/es\/2013\/08\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/wiki-cloud.co\/es\/2013\/08\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\/#primaryimage","url":"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2013\/08\/article_coverpage_microsoft_ssdt_experiencia_familiar_usuario_780x420.png","contentUrl":"https:\/\/wiki-cloud.co\/wp-content\/uploads\/2013\/08\/article_coverpage_microsoft_ssdt_experiencia_familiar_usuario_780x420.png","width":780,"height":420},{"@type":"BreadcrumbList","@id":"https:\/\/wiki-cloud.co\/es\/2013\/08\/sql-server-data-tools-ssdt-experiencia-familiar-de-usuario\/#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 Experiencia familiar de Usuario"}]},{"@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\/835","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=835"}],"version-history":[{"count":1,"href":"https:\/\/wiki-cloud.co\/en\/wp-json\/wp\/v2\/posts\/835\/revisions"}],"predecessor-version":[{"id":1488,"href":"https:\/\/wiki-cloud.co\/en\/wp-json\/wp\/v2\/posts\/835\/revisions\/1488"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wiki-cloud.co\/en\/wp-json\/wp\/v2\/media\/1485"}],"wp:attachment":[{"href":"https:\/\/wiki-cloud.co\/en\/wp-json\/wp\/v2\/media?parent=835"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wiki-cloud.co\/en\/wp-json\/wp\/v2\/categories?post=835"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wiki-cloud.co\/en\/wp-json\/wp\/v2\/tags?post=835"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}