{"id":225110,"date":"2024-02-09T18:30:00","date_gmt":"2024-02-09T18:30:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=225110"},"modified":"2024-02-05T12:23:40","modified_gmt":"2024-02-05T12:23:40","slug":"sql-server-data-tools-tout-savoir","status":"publish","type":"post","link":"https:\/\/datascientest.com\/sql-server-data-tools-tout-savoir","title":{"rendered":"SQL Server Data Tools : Qu&rsquo;est-ce que c&rsquo;est ? Comment \u00e7a fonctionne ?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"225110\" class=\"elementor elementor-225110\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a22bc9b e-flex e-con-boxed e-con\" data-id=\"a22bc9b\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-108d6a4 elementor-widget elementor-widget-heading\" data-id=\"108d6a4\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Microsoft SQL Server est l\u2019un des SGBDR les plus utilis\u00e9s par les entreprises pour ses multiples applications, telles que le traitement des transactions, la veille strat\u00e9gique ou la business intelligence. Mais pour exploiter pleinement ce syst\u00e8me de gestion de base de donn\u00e9es, les entreprises ont besoin d\u2019un outil client performant. C\u2019est l\u00e0 qu\u2019intervient le SQL Server Data Tools.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c724c79 elementor-widget elementor-widget-text-editor\" data-id=\"c724c79\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><span style=\"font-weight: 400;\">Alors de quoi s\u2019agit-il ? Quelles sont ses fonctionnalit\u00e9s ? Comment l\u2019installer ? Les r\u00e9ponses sont dans cet article.\u00a0<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-d24bb7b e-flex e-con-boxed e-con\" data-id=\"d24bb7b\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-956434b elementor-widget elementor-widget-heading\" data-id=\"956434b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Qu\u2019est-ce que SQL Server data Tools (SSDT) ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ded0977 elementor-widget elementor-widget-text-editor\" data-id=\"ded0977\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Microsoft SQL Server Data Tools (ou SSDT) est un <\/span><b>ensemble d\u2019extensions de l&rsquo;environnement de d\u00e9veloppement int\u00e9gr\u00e9 Visual Studio<\/b><span style=\"font-weight: 400;\">. Il permet de d\u00e9ployer diff\u00e9rents <a href=\"https:\/\/datascientest.com\/microsoft-sql-server-tout-savoir\">projets li\u00e9s \u00e0 SQL server<\/a>, tels que :\u00a0<\/span><\/p><ul><li><span style=\"font-weight: 400;\">des <a href=\"https:\/\/datascientest.com\/bases-de-donnees-relationnelles\">bases de donn\u00e9es relationnelles<\/a> SQL Server ;\u00a0<\/span><\/li><li><span style=\"font-weight: 400;\">des bases de donn\u00e9es dans SQL Azure ;\u00a0<\/span><\/li><li><span style=\"font-weight: 400;\">des mod\u00e8les de donn\u00e9es Analysis Services ;\u00a0<\/span><\/li><li><span style=\"font-weight: 400;\">des packages Integration Services ;\u00a0<\/span><\/li><li><span style=\"font-weight: 400;\">des rapports Reporting Services.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0a227e6 elementor-widget elementor-widget-text-editor\" data-id=\"0a227e6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Quel que soit le type de contenu SQL Server que vous souhaitez d\u00e9ployer, vous pouvez utiliser SSDT. Et ce, avec la m\u00eame facilit\u00e9 que si vous d\u00e9veloppiez une application dans Visual Studio.<\/span><\/p><p><span style=\"font-weight: 400;\"><span style=\"text-decoration: underline;\"><strong>Bon \u00e0 savoir<\/strong><\/span> : \u00e0 l\u2019origine, SQL Server Data Tools \u00e9tait pr\u00e9sent\u00e9 comme un outil autonome. Vous aviez seulement besoin d\u2019installer quelques fonctionnalit\u00e9s de Microsoft Visual Studio. Et depuis le lancement de Visual Studio 2019, SSDT est totalement int\u00e9gr\u00e9 \u00e0 l&rsquo;<a href=\"https:\/\/datascientest.com\/ide\">IDE<\/a> de Visual Studio, puisqu\u2019il s\u2019agit d\u2019une extension de cet outil. Cette int\u00e9gration de <\/span><span style=\"font-weight: 400;\">SSDT dans l\u2019environnement <strong>Visual Studio<\/strong> permet de concevoir des bases de donn\u00e9es sans avoir \u00e0 passer de Visual Studio \u00e0 d&rsquo;autres outils. C\u2019est donc un gain de temps consid\u00e9rable pour les d\u00e9veloppeurs.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-54ec790 elementor-widget elementor-widget-image\" data-id=\"54ec790\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"446\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/12\/SQL-Server-Data-Tools1-1024x571.jpg\" class=\"attachment-large size-large wp-image-225140\" alt=\"\" loading=\"lazy\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/12\/SQL-Server-Data-Tools1-1024x571.jpg 1024w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/12\/SQL-Server-Data-Tools1-300x167.jpg 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/12\/SQL-Server-Data-Tools1-768x428.jpg 768w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/12\/SQL-Server-Data-Tools1.jpg 1076w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-eebc416 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"eebc416\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"\/formation-sql\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Tout apprendre de SSDT<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-67c7289 e-flex e-con-boxed e-con\" data-id=\"67c7289\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a417101 elementor-widget elementor-widget-heading\" data-id=\"a417101\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">\u00c0 quoi sert SQL Server Data Tools ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-966ce3a elementor-widget elementor-widget-text-editor\" data-id=\"966ce3a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Bien souvent, le d\u00e9veloppement d&rsquo;une base de donn\u00e9es repr\u00e9sente un v\u00e9ritable challenge pour les d\u00e9veloppeurs. SQL Server Data Tools simplifie justement ce processus gr\u00e2ce \u00e0 l\u2019introduction d\u2019un mod\u00e8le d\u00e9claratif omnipr\u00e9sent. Celui-ci <\/span><b>couvre toutes les \u00e9tapes de la conception de database dans Visual Studio ; <\/b><span style=\"font-weight: 400;\">depuis le sch\u00e9ma \u00e0 l&rsquo;optimisation des performances en passant par l&rsquo;<a href=\"https:\/\/datascientest.com\/data-architecture\">architecture relationnelle<\/a> ou l\u2019utilisation du Transact-SQL.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Pour cela, SSDT fusionne plusieurs fonctionnalit\u00e9s de d\u00e9veloppement au sein d\u2019un m\u00eame <a href=\"https:\/\/datascientest.com\/ide\">environnement de programmation int\u00e9gr\u00e9<\/a>, \u00e0 savoir :\u00a0<\/span><\/p><ul><li><b>La conception d\u00e9clarative de la base de donn\u00e9es bas\u00e9e sur le sch\u00e9ma<\/b><span style=\"font-weight: 400;\"> : le sch\u00e9ma est contr\u00f4l\u00e9 par version. Vous pouvez ainsi concevoir et g\u00e9rer de nombreuses versions de la base de donn\u00e9es. En plus, il est possible de cr\u00e9er les scripts pour d\u00e9ployer automatiquement les nouvelles versions.\u00a0<\/span><\/li><li><b>L\u2019ing\u00e9nierie inverse des bases de donn\u00e9es <\/b><span style=\"font-weight: 400;\">: vous pouvez soit cr\u00e9er une nouvelle base de donn\u00e9es \u00e0 partir de z\u00e9ro, soit importer une base de donn\u00e9es ou un sch\u00e9ma existant afin d\u2019y apporter vos modifications.\u00a0<\/span><\/li><li><b>La comparaison de sch\u00e9mas et de donn\u00e9es<\/b><span style=\"font-weight: 400;\"> : en comparant les sch\u00e9mas de deux bases de donn\u00e9es (notamment test et production), vous pouvez visualiser toutes les divergences.\u00a0<\/span><\/li><li><b>G\u00e9n\u00e9rer des rapports XML<\/b><span style=\"font-weight: 400;\"> : ces rapports contiennent toutes les informations relatives au sch\u00e9ma de la base de donn\u00e9es, avec les modifications qui seront d\u00e9ploy\u00e9es lorsqu&rsquo;une publication est ex\u00e9cut\u00e9e.\u00a0<\/span><\/li><li><b>Refactorisation du code : <\/b><span style=\"font-weight: 400;\">le refactoring est livr\u00e9 avec une gamme restreinte d&rsquo;options de refactorisation SQL.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a85acde elementor-widget elementor-widget-image\" data-id=\"a85acde\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"762\" height=\"600\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/12\/SQL-Server-Data-Tools2.jpg\" class=\"attachment-large size-large wp-image-225141\" alt=\"\" loading=\"lazy\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/12\/SQL-Server-Data-Tools2.jpg 762w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/12\/SQL-Server-Data-Tools2-300x236.jpg 300w\" sizes=\"(max-width: 762px) 100vw, 762px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bf3a992 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"bf3a992\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"\/formation-sql\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Se former au langage SQL<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-10ca71e e-flex e-con-boxed e-con\" data-id=\"10ca71e\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8f3b956 elementor-widget elementor-widget-heading\" data-id=\"8f3b956\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Comment installer SSDT ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-82e9204 elementor-widget elementor-widget-text-editor\" data-id=\"82e9204\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Avant toute chose, vous devez installer Visual Studio. Ensuite, il convient de\u00a0 <\/span><b>modifier les charges de travail<\/b><span style=\"font-weight: 400;\"> pour installer SQL Server Data Tools. Voici la d\u00e9marche \u00e0 suivre :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Lancez le programme Visual Studio.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">En parall\u00e8le, cliquez sur le bouton \u00ab\u00a0D\u00e9marrer\u00a0\u00bb de Windows, et recherchez \u00ab\u00a0programme d\u2019installation\u00a0\u00bb.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez l\u2019\u00e9dition de Visual Studio \u00e0 laquelle vous souhaitez ajouter le SQL Server Data Tools (Analysis Services, Integration Services ou Reporting Services) ;\u00a0\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquez sur \u00ab\u00a0Modifier\u00a0\u00bb ;<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez SQL Server Data Tools dans la liste des charges de travail.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9489d9f elementor-widget elementor-widget-text-editor\" data-id=\"9489d9f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\"><strong><span style=\"text-decoration: underline;\">Bon \u00e0 savoir<\/span><\/strong> : cette manipulation concerne les Visual Studio 2022 et 2019<\/span><\/p><p><span style=\"font-weight: 400;\">Suite \u00e0 l\u2019installation de SSDT, vous pourrez concevoir et d\u00e9ployer des projets <a href=\"https:\/\/datascientest.com\/microsoft-sql-server-tout-savoir\">SQL Server<\/a> via Solution Explorer. C\u2019est ce qui vous permettra de g\u00e9n\u00e9rer une base de donn\u00e9es incluant toutes les fonctionnalit\u00e9s de Visual Studio. Par exemple, la navigation dans le code, la validation, le d\u00e9bogage, etc.\u00a0<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-7d99c13 e-flex e-con-boxed e-con\" data-id=\"7d99c13\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-459df63 elementor-widget elementor-widget-heading\" data-id=\"459df63\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Utilisez SQL Server Data Tools avec DataScientest<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fed6790 elementor-widget elementor-widget-text-editor\" data-id=\"fed6790\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Vous souhaitez apprendre \u00e0 utiliser SQL Server Tools ? C\u2019est possible avec <strong>DataScientest<\/strong>. \u00c0 travers notre formation DevOps, vous d\u00e9velopperez toutes les connaissances th\u00e9oriques et pratiques pour g\u00e9n\u00e9rer des bases de donn\u00e9es ou tout autre projet li\u00e9 \u00e0 SQL Server. Pour en savoir plus, n\u2019h\u00e9sitez pas \u00e0 <a href=\"https:\/\/datascientest.com\/formation-devops-alternance\">consulter notre programme<\/a>. <\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e8abde6 elementor-widget__width-initial elementor-widget elementor-widget-video\" data-id=\"e8abde6\" data-element_type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/youtu.be\\\/OUPCfqHKl1M&quot;,&quot;video_type&quot;:&quot;youtube&quot;,&quot;controls&quot;:&quot;yes&quot;}\" data-widget_type=\"video.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-video .elementor-widget-container{overflow:hidden;transform:translateZ(0)}.elementor-widget-video .elementor-wrapper{aspect-ratio:var(--video-aspect-ratio)}.elementor-widget-video .elementor-wrapper iframe,.elementor-widget-video .elementor-wrapper video{height:100%;width:100%;display:flex;border:none;background-color:#000}@supports not (aspect-ratio:1\/1){.elementor-widget-video .elementor-wrapper{position:relative;overflow:hidden;height:0;padding-bottom:calc(100% \/ var(--video-aspect-ratio))}.elementor-widget-video .elementor-wrapper iframe,.elementor-widget-video .elementor-wrapper video{position:absolute;top:0;right:0;bottom:0;left:0}}.elementor-widget-video .elementor-open-inline .elementor-custom-embed-image-overlay{position:absolute;top:0;right:0;bottom:0;left:0;background-size:cover;background-position:50%}.elementor-widget-video .elementor-custom-embed-image-overlay{cursor:pointer;text-align:center}.elementor-widget-video .elementor-custom-embed-image-overlay:hover .elementor-custom-embed-play i{opacity:1}.elementor-widget-video .elementor-custom-embed-image-overlay img{display:block;width:100%;aspect-ratio:var(--video-aspect-ratio);-o-object-fit:cover;object-fit:cover;-o-object-position:center center;object-position:center center}@supports not (aspect-ratio:1\/1){.elementor-widget-video .elementor-custom-embed-image-overlay{position:relative;overflow:hidden;height:0;padding-bottom:calc(100% \/ var(--video-aspect-ratio))}.elementor-widget-video .elementor-custom-embed-image-overlay img{position:absolute;top:0;right:0;bottom:0;left:0}}.elementor-widget-video .e-hosted-video .elementor-video{-o-object-fit:cover;object-fit:cover}.e-con-inner>.elementor-widget-video,.e-con>.elementor-widget-video{width:var(--container-widget-width);--flex-grow:var(--container-widget-flex-grow)}<\/style>\t\t<div class=\"elementor-wrapper elementor-open-inline\">\n\t\t\t<div class=\"elementor-video\"><\/div>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ec908ce elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"ec908ce\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"\/formation-sql\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Apprendre \u00e0 utiliser SQL<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-73a32d8 elementor-widget elementor-widget-html\" data-id=\"73a32d8\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Qu\u2019est-ce que SQL Server data Tools (SSDT) ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Microsoft SQL Server Data Tools (ou SSDT) est un ensemble d\u2019extensions de l'environnement de d\u00e9veloppement int\u00e9gr\u00e9 Visual Studio. Il permet de d\u00e9ployer diff\u00e9rents projets li\u00e9s \u00e0 SQL server, tels que : des bases de donn\u00e9es relationnelles SQL Server, des bases de donn\u00e9es dans SQL Azure, des mod\u00e8les de donn\u00e9es Analysis Services, des packages Integration Services, des rapports Reporting Services.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment installer SSDT ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Avant toute chose, vous devez installer Visual Studio. Ensuite, il convient de  modifier les charges de travail pour installer SQL Server Data Tools.\"\r\n    }\r\n  }]\r\n}\r\n<\/script>\r\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Microsoft SQL Server est l\u2019un des SGBDR les plus utilis\u00e9s par les entreprises pour ses multiples applications, telles que le traitement des transactions, la veille strat\u00e9gique ou la business intelligence. Mais pour exploiter pleinement ce syst\u00e8me de gestion de base de donn\u00e9es, les entreprises ont besoin d\u2019un outil client performant. C\u2019est l\u00e0 qu\u2019intervient le SQL [&hellip;]<\/p>\n","protected":false},"author":79,"featured_media":225112,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2411],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Server Data Tools : Qu&#039;est-ce que c&#039;est ? Comment \u00e7a fonctionne ?<\/title>\n<meta name=\"description\" content=\"D\u00e9couvrez le fonctionnement de SQL Server Data Tools, l\u2019outil indispensable pour concevoir et d\u00e9ployer n\u2019importe quel projet li\u00e9 \u00e0 SQL.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/sql-server-data-tools-tout-savoir\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Data Tools : Qu&#039;est-ce que c&#039;est ? Comment \u00e7a fonctionne ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/sql-server-data-tools-tout-savoir\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-09T18:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-05T12:23:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/12\/SQL_Server_Data_Tools.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Dan Cohen\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dan Cohen\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/sql-server-data-tools-tout-savoir\",\"url\":\"https:\/\/datascientest.com\/sql-server-data-tools-tout-savoir\",\"name\":\"SQL Server Data Tools : Qu'est-ce que c'est ? Comment \u00e7a fonctionne ?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2024-02-09T18:30:00+00:00\",\"dateModified\":\"2024-02-05T12:23:40+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/61997d589648bc1d367f632ba686e354\"},\"description\":\"D\u00e9couvrez le fonctionnement de SQL Server Data Tools, l\u2019outil indispensable pour concevoir et d\u00e9ployer n\u2019importe quel projet li\u00e9 \u00e0 SQL.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/sql-server-data-tools-tout-savoir\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/61997d589648bc1d367f632ba686e354\",\"name\":\"Dan Cohen\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/dancohen.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/dancohen.jpeg\",\"caption\":\"Dan Cohen\"},\"description\":\"Dan Cohen est actuellement Data Engineer chez DataScientest. Il poss\u00e8de une solide exp\u00e9rience dans le domaine de la data, ayant pr\u00e9c\u00e9demment occup\u00e9 des postes de Consultant en Data Science chez Meotec, Data Engineer chez Cetim, et Ing\u00e9nieur commercial chez Global D\u00e9co &amp; Food.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/dancohen1307\/\",\"Cloud & Data Engineering\"],\"url\":\"https:\/\/datascientest.com\/author\/dancohen\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server Data Tools : Qu'est-ce que c'est ? Comment \u00e7a fonctionne ?","description":"D\u00e9couvrez le fonctionnement de SQL Server Data Tools, l\u2019outil indispensable pour concevoir et d\u00e9ployer n\u2019importe quel projet li\u00e9 \u00e0 SQL.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/datascientest.com\/sql-server-data-tools-tout-savoir","og_locale":"fr_FR","og_type":"article","og_title":"SQL Server Data Tools : Qu'est-ce que c'est ? Comment \u00e7a fonctionne ?","og_url":"https:\/\/datascientest.com\/sql-server-data-tools-tout-savoir","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2024-02-09T18:30:00+00:00","article_modified_time":"2024-02-05T12:23:40+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/12\/SQL_Server_Data_Tools.png","type":"image\/png"}],"author":"Dan Cohen","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Dan Cohen","Dur\u00e9e de lecture estim\u00e9e":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/sql-server-data-tools-tout-savoir","url":"https:\/\/datascientest.com\/sql-server-data-tools-tout-savoir","name":"SQL Server Data Tools : Qu'est-ce que c'est ? Comment \u00e7a fonctionne ?","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2024-02-09T18:30:00+00:00","dateModified":"2024-02-05T12:23:40+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/61997d589648bc1d367f632ba686e354"},"description":"D\u00e9couvrez le fonctionnement de SQL Server Data Tools, l\u2019outil indispensable pour concevoir et d\u00e9ployer n\u2019importe quel projet li\u00e9 \u00e0 SQL.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/sql-server-data-tools-tout-savoir"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/61997d589648bc1d367f632ba686e354","name":"Dan Cohen","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/dancohen.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/dancohen.jpeg","caption":"Dan Cohen"},"description":"Dan Cohen est actuellement Data Engineer chez DataScientest. Il poss\u00e8de une solide exp\u00e9rience dans le domaine de la data, ayant pr\u00e9c\u00e9demment occup\u00e9 des postes de Consultant en Data Science chez Meotec, Data Engineer chez Cetim, et Ing\u00e9nieur commercial chez Global D\u00e9co &amp; Food.","sameAs":["https:\/\/www.linkedin.com\/in\/dancohen1307\/","Cloud & Data Engineering"],"url":"https:\/\/datascientest.com\/author\/dancohen"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/225110"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/79"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=225110"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/225110\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/225112"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=225110"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=225110"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=225110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}