{"id":1306,"date":"2024-01-29T05:51:00","date_gmt":"2024-01-29T04:51:00","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=1306"},"modified":"2024-02-28T21:15:58","modified_gmt":"2024-02-28T20:15:58","slug":"creer-une-base-de-donnees-avec-ssms","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/","title":{"rendered":"Cr\u00e9er Une Base de Donn\u00e9es Avec SSMS"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-left\" id=\"h-tutoriel-pas-a-pas-pour-creer-une-base-de-donnees-sql-server-avec-ssms-sql-server-management-studio\"><em>Tutoriel pas \u00e0 pas pour cr\u00e9er une base de donn\u00e9es SQL Server avec SSMS (SQL Server Management Studio).<\/em><\/h4>\n\n\n\n<p>Comment cr\u00e9er une base de donn\u00e9es SQL Server avec SQL Server Management Studio, c&rsquo;est-\u00e0-dire SSMS ? Dans ce tutoriel, nous allons apprendre \u00e0 ajouter une nouvelle base de donn\u00e9es MS SQL \u00e0 une instance. En effet, pour commencer, il est obligatoire de cr\u00e9er une base de donn\u00e9es pour cr\u00e9er et utiliser des objets SQL.<\/p>\n\n\n\n<p>Il est possible d&rsquo;effectuer presque toutes les op\u00e9rations possibles sur une base de donn\u00e9es SQL Server depuis SSMS, ici il s&rsquo;agit de <a href=\"https:\/\/expert-only.com\/fr\/ssms\/telecharger-ssms-18\/\">SQL Server Management Studio 18<\/a>. Pour installer une instance de base de donn\u00e9es sur votre machine, commencez par installer SQL Server 2017 ou 2019 par exemple. <a href=\"https:\/\/docs.microsoft.com\/fr-fr\/sql\/ssms\/download-sql-server-management-studio-ssms?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">SSMS est disponible gratuitement<\/a> sur le site officiel de Microsoft.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/#1-ouvrir-ssms-et-se-connecter-a-une-instance-sql-server\" >1. Ouvrir SSMS et se connecter \u00e0 une instance SQL Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/#2-configurer-les-options-de-la-base-de-donnees\" >2. Configurer les options de la base de donn\u00e9es<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/#3-les-etapes-en-video-pour-creer-la-base-avec-ssms\" >3. Les \u00e9tapes en vid\u00e9o pour cr\u00e9er la base avec SSMS<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-ouvrir-ssms-et-se-connecter-a-une-instance-sql-server\"><span class=\"ez-toc-section\" id=\"1-ouvrir-ssms-et-se-connecter-a-une-instance-sql-server\"><\/span>1. Ouvrir SSMS et se connecter \u00e0 une instance SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Tout d&rsquo;abord, \u00e0 partir du PC ou du serveur Windows, ouvrir SQL Server Management Studio. Pour ce faire, suivre ces quelques \u00e9tapes :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ouvrir <em>Program Files<\/em><\/li>\n\n\n\n<li>Choisir <em>Microsoft SQL Server<\/em><\/li>\n\n\n\n<li>Et ensuite <strong>Microsoft SQL Server Management Studio<\/strong>.<\/li>\n<\/ul>\n\n\n\n<p>Il peut y avoir une liste des bases de donn\u00e9es SQL Server d\u00e9j\u00e0 existantes bien s\u00fbr. Au moins la base de donn\u00e9es syst\u00e8me. Un pr\u00e9requis pour cr\u00e9er une base SQL Server: il suffit d&rsquo;avoir suffisamment de privil\u00e8ges. Se connecter \u00e0 l&rsquo;instance cible, ici c&rsquo;est le serveur nomm\u00e9 <strong><em>localhost<\/em><\/strong>, qui est la machine locale. Cet exemple utilise l&rsquo;authentification SQL Server.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"480\" height=\"345\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/connect_instance_sql_server_authentication.png\" alt=\"Connection SQL Server \u00e0 localhost avec SSMS\" class=\"wp-image-6558\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/connect_instance_sql_server_authentication.png 480w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/connect_instance_sql_server_authentication-300x216.png 300w\" sizes=\"auto, (max-width: 480px) 100vw, 480px\" \/><figcaption class=\"wp-element-caption\"><em>Connection SQL Server \u00e0 localhost avec SSMS<\/em><\/figcaption><\/figure><\/div>\n\n\n<p>Une fois connect\u00e9 \u00e0 l&rsquo;instance SQL Server depuis <a href=\"https:\/\/fr.wikipedia.org\/wiki\/SQL_Server_Management_Studio\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">SSMS<\/a>, suivre ces \u00e9tapes simples pour cr\u00e9er la base de donn\u00e9es. Sur une version SSMS en Anglais, le nom des menus seront plut\u00f4t <em>Databases<\/em> puis <em>New Database\u2026<\/em><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>S\u00e9lectionner l&rsquo;instance, ici c&rsquo;est <strong><em>localhost<\/em><\/strong><\/li>\n\n\n\n<li>Faire un clic droit sur <strong><em>Bases de donn\u00e9es<\/em><\/strong><\/li>\n\n\n\n<li>Et choisir l&rsquo;option <strong><em>Nouvelle base de donn\u00e9es\u2026<\/em><\/strong> depuis le menu contextuel.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"604\" height=\"552\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/create_new_database_with_sql_server_management_studio.png\" alt=\"Cr\u00e9er une base de donn\u00e9es avec SSMS (SQL Server Management Studio)\" class=\"wp-image-6563\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/create_new_database_with_sql_server_management_studio.png 604w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/create_new_database_with_sql_server_management_studio-300x274.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><figcaption class=\"wp-element-caption\"><em>Cr\u00e9er une base de donn\u00e9es avec SSMS (SQL Server Management Studio)<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-configurer-les-options-de-la-base-de-donnees\"><span class=\"ez-toc-section\" id=\"2-configurer-les-options-de-la-base-de-donnees\"><\/span>2. Configurer les options de la base de donn\u00e9es<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ensuite, dans la fen\u00eatre \u00ab\u00a0New Database\u00a0\u00bb, entrez le nom de la nouvelle base de donn\u00e9es SQL Server. Nous appelons la base \u00ab\u00a0DB2_ExpertOnly\u00a0\u00bb. Car d&rsquo;autres bases de donn\u00e9es sont pr\u00e9sentes sur le serveur.  Dans cet exemple, nous conservons tous les param\u00e8tres par d\u00e9faut.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Comme la taille de la nouvelle base de donn\u00e9es avec 5 m\u00e9gaoctets et la taille du fichier journal initial, soit 1 m\u00e9gaoctet.<\/li>\n\n\n\n<li>Les options <em>Autogrowth<\/em> et <em>Maxsize<\/em><strong> <\/strong>par d\u00e9faut sont respectivement de 10 % et illimit\u00e9e.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"689\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/create_new_database_ssms_name_validation.png\" alt=\"Cr\u00e9er une base de donn\u00e9es SQL Server avec les options par d\u00e9faut depuis SSMS\" class=\"wp-image-6572\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/create_new_database_ssms_name_validation.png 700w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/04\/create_new_database_ssms_name_validation-300x295.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><figcaption class=\"wp-element-caption\"><em>Cr\u00e9er une base de donn\u00e9es SQL Server avec les options par d\u00e9faut depuis SSMS<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-3-les-etapes-en-video-pour-creer-la-base-avec-ssms\"><span class=\"ez-toc-section\" id=\"3-les-etapes-en-video-pour-creer-la-base-avec-ssms\"><\/span>3. Les \u00e9tapes en vid\u00e9o pour cr\u00e9er la base avec SSMS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Le tutoriel SSMS sur la cr\u00e9ation d&rsquo;une base de donn\u00e9es est aussi disponible en format vid\u00e9o sur <a href=\"https:\/\/www.youtube.com\/@Expert-Only\" target=\"_blank\" rel=\"noreferrer noopener\">notre cha\u00eene Youtube<\/a>. Cette vid\u00e9o expose 3 fa\u00e7ons diff\u00e9rentes de cr\u00e9er une base de donn\u00e9es SQL Server :<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>En utilisant l&rsquo;interface utilisateur graphique (GUI) de SSMS<\/li>\n\n\n\n<li>En utilisant l&rsquo;option <em>Generate Script<\/em> \u00e0 partir d&rsquo;un clic droit sur une base de donn\u00e9es existante.<\/li>\n\n\n\n<li>En utilisant un simple script de SQL de type CREATE DATABASE.<\/li>\n<\/ol>\n\n\n\n<div style=\"text-align: center;\">\n<iframe loading=\"lazy\" width=\"426\" height=\"240\" src=\"https:\/\/www.youtube.com\/embed\/PyuMLIsvwQ8?si=jqBZLlIVa5J8K3mB\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe>\n<\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-a-propos-de-la-creation-de-base-de-donnees-depuis-ssms\">A propos de la cr\u00e9ation de base de donn\u00e9es depuis SSMS<\/h3>\n\n\n\n<p>Cet exemple montre comment cr\u00e9er facilement une nouvelle base de donn\u00e9es SQL Server. Et ce \u00e0 partir de l&rsquo;interface graphique utilisateur, sans aucune ligne de code. Ceci s&rsquo;applique \u00e0 toutes les versions existantes, avec quelques variations dans les options et l&rsquo;affichage.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\" id=\"h-plus-de-tutoriels-sur-la-gestion-des-bases-de-donnees-sql-server\">Plus de tutoriels sur la gestion des bases de donn\u00e9es SQL Server<\/h5>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-sql-server-avec-un-script\/\">Cr\u00e9er une base de donn\u00e9es SQL Server avec un script<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/fr\/dba\/supprimer-une-base-sql-server-avec-un-script\/\">Supprimer une base de donn\u00e9es SQL Server avec un script<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/fr\/dba\/installer-une-deuxieme-instance\/\">Installer une deuxi\u00e8me instance SQL Server<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Tutoriel pas \u00e0 pas pour cr\u00e9er une base de donn\u00e9es SQL Server avec SSMS (SQL Server Management Studio). Comment cr\u00e9er une base de donn\u00e9es SQL Server avec SQL Server Management Studio, c&rsquo;est-\u00e0-dire SSMS ? Dans ce tutoriel, nous allons <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/\" title=\"Cr\u00e9er Une Base de Donn\u00e9es Avec SSMS\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10722,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[352],"tags":[],"class_list":{"0":"post-1306","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-dba"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cr\u00e9er Une Base de Donn\u00e9es Avec SSMS - SQL Server<\/title>\n<meta name=\"description\" content=\"Pour cr\u00e9er une base de donn\u00e9es avec SSMS, se connecter \u00e0 SQL Server et ajouter la base avec l&#039;interface graphique.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cr\u00e9er Une Base de Donn\u00e9es Avec SSMS\" \/>\n<meta property=\"og:description\" content=\"Pour cr\u00e9er une base de donn\u00e9es avec SSMS, se connecter \u00e0 SQL Server et ajouter la base avec l&#039;interface graphique.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels SQL et IT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-29T04:51:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-28T20:15:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-0B51D6AF710_1920x1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Cr\u00e9er Une Base de Donn\u00e9es Avec SSMS\",\"datePublished\":\"2024-01-29T04:51:00+00:00\",\"dateModified\":\"2024-02-28T20:15:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/\"},\"wordCount\":655,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-0B51D6AF710_1920x1080.jpg\",\"articleSection\":[\"Administration SQL Server\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/\",\"url\":\"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/\",\"name\":\"Cr\u00e9er Une Base de Donn\u00e9es Avec SSMS - SQL Server\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-0B51D6AF710_1920x1080.jpg\",\"datePublished\":\"2024-01-29T04:51:00+00:00\",\"dateModified\":\"2024-02-28T20:15:58+00:00\",\"description\":\"Pour cr\u00e9er une base de donn\u00e9es avec SSMS, se connecter \u00e0 SQL Server et ajouter la base avec l'interface graphique.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-0B51D6AF710_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-0B51D6AF710_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cr\u00e9er Une Base de Donn\u00e9es Avec SSMS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/fr\/#website\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"name\":\"Tutoriels SQL et IT\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Cr\u00e9er Une Base de Donn\u00e9es Avec SSMS - SQL Server","description":"Pour cr\u00e9er une base de donn\u00e9es avec SSMS, se connecter \u00e0 SQL Server et ajouter la base avec l'interface graphique.","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:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/","og_locale":"fr_FR","og_type":"article","og_title":"Cr\u00e9er Une Base de Donn\u00e9es Avec SSMS","og_description":"Pour cr\u00e9er une base de donn\u00e9es avec SSMS, se connecter \u00e0 SQL Server et ajouter la base avec l'interface graphique.","og_url":"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2024-01-29T04:51:00+00:00","article_modified_time":"2024-02-28T20:15:58+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-0B51D6AF710_1920x1080.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"\u00c9crit par":"Expert-Only","Dur\u00e9e de lecture estim\u00e9e":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Cr\u00e9er Une Base de Donn\u00e9es Avec SSMS","datePublished":"2024-01-29T04:51:00+00:00","dateModified":"2024-02-28T20:15:58+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/"},"wordCount":655,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-0B51D6AF710_1920x1080.jpg","articleSection":["Administration SQL Server"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/","url":"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/","name":"Cr\u00e9er Une Base de Donn\u00e9es Avec SSMS - SQL Server","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-0B51D6AF710_1920x1080.jpg","datePublished":"2024-01-29T04:51:00+00:00","dateModified":"2024-02-28T20:15:58+00:00","description":"Pour cr\u00e9er une base de donn\u00e9es avec SSMS, se connecter \u00e0 SQL Server et ajouter la base avec l'interface graphique.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-0B51D6AF710_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/light-bulb-0B51D6AF710_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-de-donnees-avec-ssms\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Cr\u00e9er Une Base de Donn\u00e9es Avec SSMS"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/fr\/#website","url":"https:\/\/expert-only.com\/fr\/","name":"Tutoriels SQL et IT","description":"","publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/fr\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1306","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/comments?post=1306"}],"version-history":[{"count":7,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1306\/revisions"}],"predecessor-version":[{"id":30240,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1306\/revisions\/30240"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10722"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=1306"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=1306"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=1306"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}