{"id":37451,"date":"2023-10-30T06:20:16","date_gmt":"2023-10-30T06:20:16","guid":{"rendered":"https:\/\/www.railscarma.com\/?p=37451"},"modified":"2023-10-30T06:20:21","modified_gmt":"2023-10-30T06:20:21","slug":"modeles-de-bases-de-donnees-et-migrations-dans-rails-avec-serveur-sql","status":"publish","type":"post","link":"https:\/\/www.railscarma.com\/fr\/blog\/modeles-de-bases-de-donnees-et-migrations-dans-rails-avec-serveur-sql\/","title":{"rendered":"Mod\u00e8les de bases de donn\u00e9es et migrations dans Rails avec SQL Server"},"content":{"rendered":"<div data-elementor-type=\"wp-post\" data-elementor-id=\"37451\" class=\"elementor elementor-37451\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1231ecb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1231ecb\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ff5a101\" data-id=\"ff5a101\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a3745e9 elementor-widget elementor-widget-text-editor\" data-id=\"a3745e9\" 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\t\t<p>Ruby on Rails est un puissant framework d&#039;application Web qui offre un moyen pratique d&#039;interagir avec les bases de donn\u00e9es. Lorsque vous travaillez avec SQL Server comme syst\u00e8me de gestion de base de donn\u00e9es, il est essentiel de comprendre comment d\u00e9finir des mod\u00e8les de base de donn\u00e9es et g\u00e9rer les modifications de sch\u00e9ma \u00e0 l&#039;aide des migrations Rails. Dans cet article, nous allons parcourir le processus de cr\u00e9ation <b>mod\u00e8les de bases de donn\u00e9es et migrations dans l&#039;application Rails<\/b> tout en utilisant SQL Server comme backend de base de donn\u00e9es.<\/p>\n<h2><strong>Conditions pr\u00e9alables<\/strong><\/h2>\n<ul>\n<li>Ruby on Rails install\u00e9 sur votre syst\u00e8me.<\/li>\n<li>Une instance SQL Server configur\u00e9e et accessible.<\/li>\n<\/ul>\n<h2><b>Cr\u00e9ation d&#039;une nouvelle application Rails<\/b><\/h2>\n<p>Commen\u00e7ons par cr\u00e9er une nouvelle application Rails. Ouvrez votre terminal et ex\u00e9cutez la commande suivante\u00a0:<\/p>\n<div class=\"bg-black rounded-md mb-4\">\n<div class=\"flex items-center relative text-gray-200 bg-gray-800 gizmo:dark:bg-token-surface-primary px-4 py-2 text-xs font-sans justify-between rounded-t-md\">frapper<\/div>\n<div class=\"p-4 overflow-y-auto\">\n<pre class=\"prettyprint lang-mssql prettyprinted\"><span class=\"pln\">rails le nouveau sql_server_rails_app<\/span><\/pre>\n<\/div>\n<\/div>\n<p>Cette commande g\u00e9n\u00e9rera une nouvelle application Rails nomm\u00e9e&nbsp;<code>sql_server_rails_app<\/code>. Acc\u00e9dez au r\u00e9pertoire du projet\u00a0:<\/p>\n<div class=\"bg-black rounded-md mb-4\">\n<div class=\"flex items-center relative text-gray-200 bg-gray-800 gizmo:dark:bg-token-surface-primary px-4 py-2 text-xs font-sans justify-between rounded-t-md\">frapper<\/div>\n<div class=\"p-4 overflow-y-auto\">\n<pre class=\"prettyprint lang-mssql prettyprinted\"><span class=\"pln\">cd sql_server_rails_app<\/span><\/pre>\n<\/div>\n<\/div>\n<p>Pour configurer SQL Server comme base de donn\u00e9es, ouvrez le&nbsp;<code>config\/base de donn\u00e9es.yml<\/code>&nbsp;fichier et modifiez-le comme suit\u00a0:<\/p>\n<div class=\"bg-black rounded-md mb-4\">\n<div class=\"flex items-center relative text-gray-200 bg-gray-800 gizmo:dark:bg-token-surface-primary px-4 py-2 text-xs font-sans justify-between rounded-t-md\">yaml<\/div>\n<div class=\"p-4 overflow-y-auto\">\n<pre class=\"prettyprint lang-mssql prettyprinted\"><span class=\"kwd\">d\u00e9faut<\/span><span class=\"pun\">:<\/span> <span class=\"pun\">&amp;<\/span><span class=\"kwd\">d\u00e9faut<\/span><span class=\"pln\">\n  adaptateur<\/span><span class=\"pun\">:<\/span><span class=\"pln\"> h\u00f4te du serveur SQL<\/span><span class=\"pun\">:<\/span><span class=\"pln\"> nom d&#039;utilisateur localhost<\/span><span class=\"pun\">:<\/span><span class=\"pln\"> votre_nom d&#039;utilisateur mot de passe<\/span><span class=\"pun\">:<\/span><span class=\"pln\"> votre mot de passe\n  <\/span><span class=\"kwd\">base de donn\u00e9es<\/span><span class=\"pun\">:<\/span><span class=\"pln\"> port nom_de_votre_base-de-donn\u00e9es<\/span><span class=\"pun\">:<\/span> <span class=\"lit\">1433<\/span><\/pre>\n<\/div>\n<\/div>\n<p>Remplacer&nbsp;<code>ton nom d&#039;utilisateur<\/code>,&nbsp;<code>votre mot de passe<\/code>, et&nbsp;<code>votre_nom_de_base de donn\u00e9es<\/code>&nbsp;avec vos informations d&#039;identification SQL Server et le nom de la base de donn\u00e9es souhait\u00e9e.<\/p>\n<h2><b>Cr\u00e9ation d&#039;un mod\u00e8le de base de donn\u00e9es<\/b><\/h2>\n<p>Cr\u00e9ons un mod\u00e8le de base de donn\u00e9es simple pour une application de blog. Ex\u00e9cutez la commande suivante pour g\u00e9n\u00e9rer un&nbsp;<code>Poste<\/code>&nbsp;mod\u00e8le avec attributs\u00a0:<\/p>\n<div class=\"bg-black rounded-md mb-4\">\n<div class=\"flex items-center relative text-gray-200 bg-gray-800 gizmo:dark:bg-token-surface-primary px-4 py-2 text-xs font-sans justify-between rounded-t-md\">frapper<\/div>\n<div class=\"p-4 overflow-y-auto\">\n<pre class=\"prettyprint lang-mssql prettyprinted\"><span class=\"pln\">les rails g\u00e9n\u00e8rent le mod\u00e8le Titre du message<\/span><span class=\"pun\">:<\/span><span class=\"pln\">corps de corde<\/span><span class=\"pun\">:<\/span><span class=\"pln\">texte<\/span><\/pre>\n<\/div>\n<\/div>\n<p>Cette commande cr\u00e9era un fichier de migration dans le&nbsp;<code>base de donn\u00e9es\/migrer<\/code>&nbsp;r\u00e9pertoire et un fichier de mod\u00e8le correspondant dans le&nbsp;<code>application\/mod\u00e8les<\/code>&nbsp;annuaire.<\/p>\n<h2><b>Cr\u00e9er une migration<\/b><\/h2>\n<p>Ouvrez le fichier de migration g\u00e9n\u00e9r\u00e9 dans le&nbsp;<code>base de donn\u00e9es\/migrer<\/code>&nbsp;annuaire. Il aura un nom comme&nbsp;<code>xxxxxx_create_posts.rb<\/code>, o\u00f9&nbsp;<code>xxxxxx<\/code>&nbsp;est un horodatage. Ajoutez les colonnes n\u00e9cessaires au&nbsp;<code>cr\u00e9er_table<\/code>&nbsp;bloc:<\/p>\n<div class=\"bg-black rounded-md mb-4\">\n<div class=\"flex items-center relative text-gray-200 bg-gray-800 gizmo:dark:bg-token-surface-primary px-4 py-2 text-xs font-sans justify-between rounded-t-md\">rubis<\/div>\n<div class=\"p-4 overflow-y-auto\">\n<pre class=\"prettyprint lang-mssql prettyprinted\"><span class=\"pln\">classe CreatePosts <\/span><span class=\"pun\">&lt;<\/span><span class=\"pln\"> Enregistrement actif<\/span><span class=\"pun\">::<\/span><span class=\"pln\">Migration<\/span><span class=\"pun\">[<\/span><span class=\"lit\">6.1<\/span><span class=\"pun\">]<\/span><span class=\"pln\">\n  def changer create_table <\/span><span class=\"pun\">:<\/span><span class=\"pln\">les messages font <\/span><span class=\"pun\">|<\/span><span class=\"pln\">t<\/span><span class=\"pun\">|<\/span><span class=\"pln\">\n      t<\/span><span class=\"pun\">.<\/span><span class=\"pln\">cha\u00eene <\/span><span class=\"pun\">:<\/span><span class=\"pln\">titre t<\/span><span class=\"pun\">.<\/span><span class=\"pln\">texte <\/span><span class=\"pun\">:<\/span><span class=\"pln\">corps t<\/span><span class=\"pun\">.<\/span><span class=\"pln\">horodatages\n    <\/span><span class=\"kwd\">fin<\/span>\n  <span class=\"kwd\">fin<\/span>\n<span class=\"kwd\">fin<\/span><\/pre>\n<\/div>\n<\/div>\n<p>Cette migration cr\u00e9e un&nbsp;<code>des postes<\/code>&nbsp;table avec&nbsp;<code>titre<\/code>&nbsp;et&nbsp;<code>corps<\/code>&nbsp;Colonnes.<\/p>\n<h2><b>Ex\u00e9cuter des migrations<\/b><\/h2>\n<p>Pour appliquer la migration et cr\u00e9er le&nbsp;<code>des postes<\/code>&nbsp;table dans la base de donn\u00e9es SQL Server, ex\u00e9cutez la commande suivante\u00a0:<\/p>\n<div class=\"bg-black rounded-md mb-4\">\n<div class=\"flex items-center relative text-gray-200 bg-gray-800 gizmo:dark:bg-token-surface-primary px-4 py-2 text-xs font-sans justify-between rounded-t-md\">frapper<\/div>\n<div class=\"p-4 overflow-y-auto\">\n<pre class=\"prettyprint lang-mssql prettyprinted\"><span class=\"pln\">base de donn\u00e9es rails<\/span><span class=\"pun\">:<\/span><span class=\"pln\">\u00e9migrer<\/span><\/pre>\n<\/div>\n<\/div>\n<p>Cette commande ex\u00e9cutera toutes les migrations en attente et mettra \u00e0 jour le sch\u00e9ma de la base de donn\u00e9es en cons\u00e9quence.<\/p>\n<h2><b>Utiliser le mod\u00e8le<\/b><\/h2>\n<p>Maintenant que le&nbsp;<code>Poste<\/code>&nbsp;le mod\u00e8le et le tableau sont cr\u00e9\u00e9s, vous pouvez les utiliser dans votre&nbsp;<a href=\"https:\/\/www.railscarma.com\/fr\/\">Application Rails<\/a>. Par exemple, vous pouvez cr\u00e9er une nouvelle publication dans votre contr\u00f4leur\u00a0:<\/p>\n<div class=\"bg-black rounded-md mb-4\">\n<div class=\"flex items-center relative text-gray-200 bg-gray-800 gizmo:dark:bg-token-surface-primary px-4 py-2 text-xs font-sans justify-between rounded-t-md\">rubis<\/div>\n<div class=\"p-4 overflow-y-auto\">\n<pre class=\"prettyprint lang-mssql prettyprinted\"><span class=\"pln\">classe PostsController <\/span><span class=\"pun\">&lt;<\/span><span class=\"pln\"> ApplicationController d\u00e9finition <\/span><span class=\"kwd\">cr\u00e9er<\/span>\n    <span class=\"pun\">@<\/span><span class=\"pln\">poste <\/span><span class=\"pun\">=<\/span><span class=\"pln\"> Poste<\/span><span class=\"pun\">.<\/span><span class=\"pln\">nouveau<\/span><span class=\"pun\">(<\/span><span class=\"pln\">post_params<\/span><span class=\"pun\">)<\/span>\n    <span class=\"kwd\">si<\/span> <span class=\"pun\">@<\/span><span class=\"pln\">poste<\/span><span class=\"pun\">.<\/span><span class=\"kwd\">sauvegarder<\/span><span class=\"pln\">\n      rediriger vers <\/span><span class=\"pun\">@<\/span><span class=\"pln\">poste<\/span><span class=\"pun\">,<\/span><span class=\"pln\"> avis<\/span><span class=\"pun\">:<\/span> <span class=\"str\">\u00ab\u00a0Le message a \u00e9t\u00e9 cr\u00e9\u00e9 avec succ\u00e8s.\u00a0\u00bb<\/span>\n    <span class=\"kwd\">autre<\/span><span class=\"pln\">\n      rendre <\/span><span class=\"pun\">:<\/span><span class=\"pln\">nouveau\n    <\/span><span class=\"kwd\">fin<\/span>\n  <span class=\"kwd\">fin<\/span><span class=\"pln\">\n  param\u00e8tres post_params def priv\u00e9e<\/span><span class=\"pun\">.<\/span><span class=\"pln\">exiger<\/span><span class=\"pun\">(:<\/span><span class=\"pln\">poste<\/span><span class=\"pun\">).<\/span><span class=\"pln\">permis<\/span><span class=\"pun\">(:<\/span><span class=\"pln\">titre<\/span><span class=\"pun\">,<\/span> <span class=\"pun\">:<\/span><span class=\"pln\">corps<\/span><span class=\"pun\">)<\/span>\n  <span class=\"kwd\">fin<\/span>\n<span class=\"kwd\">fin<\/span><\/pre>\n<\/div>\n<\/div>\n<h2><b>Conclusion<\/b><\/h2>\n<p>Dans cet article de blog, nous avons appris \u00e0 cr\u00e9er des mod\u00e8les de base de donn\u00e9es et des migrations dans un <a href=\"https:\/\/www.railscarma.com\/fr\/developpement-dapplications-de-rails-personnalises\/\">Application Ruby on Rails<\/a> en utilisant SQL Server comme backend de base de donn\u00e9es. Vous pouvez d\u00e9sormais commencer \u00e0 cr\u00e9er votre application avec la puissance et la flexibilit\u00e9 de Rails tout en tirant parti des capacit\u00e9s de SQL Server pour le stockage et la r\u00e9cup\u00e9ration de donn\u00e9es.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t  <div class=\"related-post slider\">\r\n        <div class=\"headline\">Articles Similaires<\/div>\r\n    <div class=\"post-list owl-carousel\">\r\n\r\n            <div class=\"item\">\r\n            <div class=\"thumb post_thumb\">\r\n    <a  title=\"Qu&#039;est-ce que Offliberty Ruby Gem et comment fonctionne-t-il ?\" href=\"https:\/\/www.railscarma.com\/fr\/blog\/quest-ce-que-offliberty-ruby-gem-et-comment-fonctionne-t-il\/?related_post_from=41304\">\r\n\r\n      <img decoding=\"async\" width=\"800\" height=\"300\" src=\"https:\/\/www.railscarma.com\/wp-content\/uploads\/2026\/04\/What-is-Offliberty-Ruby-Gem-and-How-It-Works.png\" class=\"attachment-full size-full wp-post-image\" alt=\"Offliberty Ruby Gem\" srcset=\"https:\/\/www.railscarma.com\/wp-content\/uploads\/2026\/04\/What-is-Offliberty-Ruby-Gem-and-How-It-Works.png 800w, https:\/\/www.railscarma.com\/wp-content\/uploads\/2026\/04\/What-is-Offliberty-Ruby-Gem-and-How-It-Works-300x113.png 300w, https:\/\/www.railscarma.com\/wp-content\/uploads\/2026\/04\/What-is-Offliberty-Ruby-Gem-and-How-It-Works-768x288.png 768w, https:\/\/www.railscarma.com\/wp-content\/uploads\/2026\/04\/What-is-Offliberty-Ruby-Gem-and-How-It-Works-18x7.png 18w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\r\n\r\n    <\/a>\r\n  <\/div>\r\n\r\n  <a class=\"title post_title\"  title=\"Qu&#039;est-ce que Offliberty Ruby Gem et comment fonctionne-t-il ?\" href=\"https:\/\/www.railscarma.com\/fr\/blog\/quest-ce-que-offliberty-ruby-gem-et-comment-fonctionne-t-il\/?related_post_from=41304\">\r\n        Qu'est-ce que Offliberty Ruby Gem et comment fonctionne-t-il ?  <\/a>\r\n\r\n        <\/div>\r\n              <div class=\"item\">\r\n            <div class=\"thumb post_thumb\">\r\n    <a  title=\"M\u00e9thode Rails link_to : Le guide complet avec des exemples\" href=\"https:\/\/www.railscarma.com\/fr\/blog\/rails-link_to-method-the-complete-guide-with-examples\/?related_post_from=41296\">\r\n\r\n      <img decoding=\"async\" width=\"800\" height=\"300\" src=\"https:\/\/www.railscarma.com\/wp-content\/uploads\/2026\/04\/Rails-link_to-Method-The-Complete-Guide-with-Examples.png\" class=\"attachment-full size-full wp-post-image\" alt=\"M\u00e9thode Rails link_to\" srcset=\"https:\/\/www.railscarma.com\/wp-content\/uploads\/2026\/04\/Rails-link_to-Method-The-Complete-Guide-with-Examples.png 800w, https:\/\/www.railscarma.com\/wp-content\/uploads\/2026\/04\/Rails-link_to-Method-The-Complete-Guide-with-Examples-300x113.png 300w, https:\/\/www.railscarma.com\/wp-content\/uploads\/2026\/04\/Rails-link_to-Method-The-Complete-Guide-with-Examples-768x288.png 768w, https:\/\/www.railscarma.com\/wp-content\/uploads\/2026\/04\/Rails-link_to-Method-The-Complete-Guide-with-Examples-18x7.png 18w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\r\n\r\n    <\/a>\r\n  <\/div>\r\n\r\n  <a class=\"title post_title\"  title=\"M\u00e9thode Rails link_to : Le guide complet avec des exemples\" href=\"https:\/\/www.railscarma.com\/fr\/blog\/rails-link_to-method-the-complete-guide-with-examples\/?related_post_from=41296\">\r\n        M\u00e9thode Rails link_to : Le guide complet avec des exemples  <\/a>\r\n\r\n        <\/div>\r\n              <div class=\"item\">\r\n            <div class=\"thumb post_thumb\">\r\n    <a  title=\"Comment construire une plateforme SaaS \u00e9volutive en utilisant Ruby on Rails\" href=\"https:\/\/www.railscarma.com\/fr\/blog\/how-to-build-a-scalable-saas-platform-using-ruby-on-rails\/?related_post_from=41273\">\r\n\r\n      <img decoding=\"async\" width=\"800\" height=\"300\" src=\"https:\/\/www.railscarma.com\/wp-content\/uploads\/2026\/04\/Build-a-SaaS-Platform-Using-Ruby-on-Rails.png\" class=\"attachment-full size-full wp-post-image\" alt=\"Construire une plateforme SaaS avec Ruby on Rails\" srcset=\"https:\/\/www.railscarma.com\/wp-content\/uploads\/2026\/04\/Build-a-SaaS-Platform-Using-Ruby-on-Rails.png 800w, https:\/\/www.railscarma.com\/wp-content\/uploads\/2026\/04\/Build-a-SaaS-Platform-Using-Ruby-on-Rails-300x113.png 300w, https:\/\/www.railscarma.com\/wp-content\/uploads\/2026\/04\/Build-a-SaaS-Platform-Using-Ruby-on-Rails-768x288.png 768w, https:\/\/www.railscarma.com\/wp-content\/uploads\/2026\/04\/Build-a-SaaS-Platform-Using-Ruby-on-Rails-18x7.png 18w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\r\n\r\n    <\/a>\r\n  <\/div>\r\n\r\n  <a class=\"title post_title\"  title=\"Comment construire une plateforme SaaS \u00e9volutive en utilisant Ruby on Rails\" href=\"https:\/\/www.railscarma.com\/fr\/blog\/how-to-build-a-scalable-saas-platform-using-ruby-on-rails\/?related_post_from=41273\">\r\n        Comment construire une plateforme SaaS \u00e9volutive en utilisant Ruby on Rails  <\/a>\r\n\r\n        <\/div>\r\n              <div class=\"item\">\r\n            <div class=\"thumb post_thumb\">\r\n    <a  title=\"Guide de correspondance des expressions rationnelles en Ruby (2026) avec exemples\" href=\"https:\/\/www.railscarma.com\/fr\/blog\/ruby-regex-match-guide-with-examples\/?related_post_from=41249\">\r\n\r\n      <img decoding=\"async\" width=\"800\" height=\"300\" src=\"https:\/\/www.railscarma.com\/wp-content\/uploads\/2026\/04\/Ruby-Regex-Match-Guide-with-Examples.png\" class=\"attachment-full size-full wp-post-image\" alt=\"Ruby Regex Match\" srcset=\"https:\/\/www.railscarma.com\/wp-content\/uploads\/2026\/04\/Ruby-Regex-Match-Guide-with-Examples.png 800w, https:\/\/www.railscarma.com\/wp-content\/uploads\/2026\/04\/Ruby-Regex-Match-Guide-with-Examples-300x113.png 300w, https:\/\/www.railscarma.com\/wp-content\/uploads\/2026\/04\/Ruby-Regex-Match-Guide-with-Examples-768x288.png 768w, https:\/\/www.railscarma.com\/wp-content\/uploads\/2026\/04\/Ruby-Regex-Match-Guide-with-Examples-18x7.png 18w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\r\n\r\n    <\/a>\r\n  <\/div>\r\n\r\n  <a class=\"title post_title\"  title=\"Guide de correspondance des expressions rationnelles en Ruby (2026) avec exemples\" href=\"https:\/\/www.railscarma.com\/fr\/blog\/ruby-regex-match-guide-with-examples\/?related_post_from=41249\">\r\n        Guide de correspondance des expressions rationnelles en Ruby (2026) avec exemples  <\/a>\r\n\r\n        <\/div>\r\n      \r\n  <\/div>\r\n\r\n  <script>\r\n      <\/script>\r\n  <style>\r\n    .related-post {}\r\n\r\n    .related-post .post-list {\r\n      text-align: left;\r\n          }\r\n\r\n    .related-post .post-list .item {\r\n      margin: 10px;\r\n      padding: 10px;\r\n          }\r\n\r\n    .related-post .headline {\r\n      font-size: 14px !important;\r\n      color: #999999 !important;\r\n          }\r\n\r\n    .related-post .post-list .item .post_thumb {\r\n      max-height: 220px;\r\n      margin: 10px 0px;\r\n      padding: 0px;\r\n      display: block;\r\n          }\r\n\r\n    .related-post .post-list .item .post_title {\r\n      font-size: 14px;\r\n      color: #000000;\r\n      margin: 10px 0px;\r\n      padding: 0px;\r\n      display: block;\r\n      text-decoration: none;\r\n          }\r\n\r\n    .related-post .post-list .item .post_excerpt {\r\n      font-size: 12px;\r\n      color: #3f3f3f;\r\n      margin: 10px 0px;\r\n      padding: 0px;\r\n      display: block;\r\n      text-decoration: none;\r\n          }\r\n\r\n    .related-post .owl-dots .owl-dot {\r\n          }\r\n\r\n      <\/style>\r\n      <script>\r\n      jQuery(document).ready(function($) {\r\n        $(\".related-post .post-list\").owlCarousel({\r\n          items: 2,\r\n          responsiveClass: true,\r\n          responsive: {\r\n            0: {\r\n              items: 1,\r\n            },\r\n            768: {\r\n              items: 2,\r\n            },\r\n            1200: {\r\n              items: 2,\r\n            }\r\n          },\r\n                      rewind: true,\r\n                                loop: true,\r\n                                center: false,\r\n                                autoplay: true,\r\n            autoplayHoverPause: true,\r\n                                nav: true,\r\n            navSpeed: 1000,\r\n            navText: ['<i class=\"fas fa-chevron-left\"><\/i>', '<i class=\"fas fa-chevron-right\"><\/i>'],\r\n                                dots: false,\r\n            dotsSpeed: 1200,\r\n                                                    rtl: false,\r\n          \r\n        });\r\n      });\r\n    <\/script>\r\n  <\/div>","protected":false},"excerpt":{"rendered":"<p>Ruby on Rails is a powerful web application framework that provides a convenient way to interact with databases. When working with SQL Server as your database management system, it&#8217;s crucial to understand how to define database models and manage schema changes using Rails migrations. In this article, we&#8217;ll walk through the process of creating database &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.railscarma.com\/fr\/blog\/ruby-regex-match-guide-with-examples\/\"> <span class=\"screen-reader-text\">Guide de correspondance des expressions rationnelles en Ruby (2026) avec exemples<\/span> Lire la suite \u00bb<\/a><\/p>","protected":false},"author":5,"featured_media":37459,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1224],"tags":[],"class_list":["post-37451","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Database Models and Migrations in Rails with SQL Server - RailsCarma<\/title>\n<meta name=\"description\" content=\"Efficiently manage Rails database models and migrations with SQL Server. Simplify web app development using SQL Server in Rails. Learn more.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.railscarma.com\/fr\/blog\/modeles-de-bases-de-donnees-et-migrations-dans-rails-avec-serveur-sql\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database Models and Migrations in Rails with SQL Server - RailsCarma\" \/>\n<meta property=\"og:description\" content=\"Efficiently manage Rails database models and migrations with SQL Server. Simplify web app development using SQL Server in Rails. Learn more.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.railscarma.com\/fr\/blog\/modeles-de-bases-de-donnees-et-migrations-dans-rails-avec-serveur-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"RailsCarma - Ruby on Rails Development Company specializing in Offshore Development\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/RailsCarma\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-30T06:20:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-30T06:20:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.railscarma.com\/wp-content\/uploads\/2023\/10\/Database-Models-and-Migrations-in-Rails-with-SQL-Server.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Nikhil\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@railscarma\" \/>\n<meta name=\"twitter:site\" content=\"@railscarma\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nikhil\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\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:\/\/www.railscarma.com\/es\/blog\/modelos-de-bases-de-datos-y-migraciones-en-rails-con-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.railscarma.com\/es\/blog\/modelos-de-bases-de-datos-y-migraciones-en-rails-con-sql-server\/\"},\"author\":{\"name\":\"Nikhil\",\"@id\":\"https:\/\/www.railscarma.com\/#\/schema\/person\/1aa0357392b349082303e8222c35c30c\"},\"headline\":\"Database Models and Migrations in Rails with SQL Server\",\"datePublished\":\"2023-10-30T06:20:16+00:00\",\"dateModified\":\"2023-10-30T06:20:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.railscarma.com\/es\/blog\/modelos-de-bases-de-datos-y-migraciones-en-rails-con-sql-server\/\"},\"wordCount\":392,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.railscarma.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.railscarma.com\/es\/blog\/modelos-de-bases-de-datos-y-migraciones-en-rails-con-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.railscarma.com\/wp-content\/uploads\/2023\/10\/Database-Models-and-Migrations-in-Rails-with-SQL-Server.jpg\",\"articleSection\":[\"Blogs\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.railscarma.com\/es\/blog\/modelos-de-bases-de-datos-y-migraciones-en-rails-con-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.railscarma.com\/es\/blog\/modelos-de-bases-de-datos-y-migraciones-en-rails-con-sql-server\/\",\"url\":\"https:\/\/www.railscarma.com\/es\/blog\/modelos-de-bases-de-datos-y-migraciones-en-rails-con-sql-server\/\",\"name\":\"Database Models and Migrations in Rails with SQL Server - RailsCarma\",\"isPartOf\":{\"@id\":\"https:\/\/www.railscarma.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.railscarma.com\/es\/blog\/modelos-de-bases-de-datos-y-migraciones-en-rails-con-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.railscarma.com\/es\/blog\/modelos-de-bases-de-datos-y-migraciones-en-rails-con-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.railscarma.com\/wp-content\/uploads\/2023\/10\/Database-Models-and-Migrations-in-Rails-with-SQL-Server.jpg\",\"datePublished\":\"2023-10-30T06:20:16+00:00\",\"dateModified\":\"2023-10-30T06:20:21+00:00\",\"description\":\"Efficiently manage Rails database models and migrations with SQL Server. Simplify web app development using SQL Server in Rails. Learn more.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.railscarma.com\/es\/blog\/modelos-de-bases-de-datos-y-migraciones-en-rails-con-sql-server\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.railscarma.com\/es\/blog\/modelos-de-bases-de-datos-y-migraciones-en-rails-con-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/www.railscarma.com\/es\/blog\/modelos-de-bases-de-datos-y-migraciones-en-rails-con-sql-server\/#primaryimage\",\"url\":\"https:\/\/www.railscarma.com\/wp-content\/uploads\/2023\/10\/Database-Models-and-Migrations-in-Rails-with-SQL-Server.jpg\",\"contentUrl\":\"https:\/\/www.railscarma.com\/wp-content\/uploads\/2023\/10\/Database-Models-and-Migrations-in-Rails-with-SQL-Server.jpg\",\"width\":800,\"height\":300,\"caption\":\"Database Models and Migrations in Rails with SQL Server\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.railscarma.com\/es\/blog\/modelos-de-bases-de-datos-y-migraciones-en-rails-con-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.railscarma.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database Models and Migrations in Rails with SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.railscarma.com\/#website\",\"url\":\"https:\/\/www.railscarma.com\/\",\"name\":\"RailsCarma - Ruby on Rails Development Company specializing in Offshore Development\",\"description\":\"RailsCarma is a Ruby on Rails Development Company in Bangalore. We specialize in Offshore Ruby on Rails Development based out in USA and India. Hire experienced Ruby on Rails developers for the ultimate Web Experience.\",\"publisher\":{\"@id\":\"https:\/\/www.railscarma.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.railscarma.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.railscarma.com\/#organization\",\"name\":\"RailsCarma\",\"url\":\"https:\/\/www.railscarma.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/www.railscarma.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.railscarma.com\/wp-content\/uploads\/2020\/08\/railscarma_logo.png\",\"contentUrl\":\"https:\/\/www.railscarma.com\/wp-content\/uploads\/2020\/08\/railscarma_logo.png\",\"width\":200,\"height\":46,\"caption\":\"RailsCarma\"},\"image\":{\"@id\":\"https:\/\/www.railscarma.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/RailsCarma\/\",\"https:\/\/x.com\/railscarma\",\"https:\/\/www.linkedin.com\/company\/railscarma\/\",\"https:\/\/myspace.com\/railscarma\",\"https:\/\/in.pinterest.com\/railscarma\/\",\"https:\/\/www.youtube.com\/channel\/UCx3Wil-aAnDARuatTEyMdpg\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.railscarma.com\/#\/schema\/person\/1aa0357392b349082303e8222c35c30c\",\"name\":\"Nikhil\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/www.railscarma.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/054f31ff35e9917aaf631b8025ef679d42dd21792012d451763138d66d02a4c0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/054f31ff35e9917aaf631b8025ef679d42dd21792012d451763138d66d02a4c0?s=96&d=mm&r=g\",\"caption\":\"Nikhil\"},\"sameAs\":[\"https:\/\/www.railscarma.com\/hire-ruby-on-rails-developer\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Mod\u00e8les de bases de donn\u00e9es et migrations dans Rails avec SQL Server - RailsCarma","description":"G\u00e9rez efficacement les mod\u00e8les de bases de donn\u00e9es Rails et les migrations avec SQL Server. Simplifiez le d\u00e9veloppement d&#039;applications Web \u00e0 l&#039;aide de SQL Server dans Rails. Apprendre encore plus.","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:\/\/www.railscarma.com\/fr\/blog\/modeles-de-bases-de-donnees-et-migrations-dans-rails-avec-serveur-sql\/","og_locale":"fr_FR","og_type":"article","og_title":"Database Models and Migrations in Rails with SQL Server - RailsCarma","og_description":"Efficiently manage Rails database models and migrations with SQL Server. Simplify web app development using SQL Server in Rails. Learn more.","og_url":"https:\/\/www.railscarma.com\/fr\/blog\/modeles-de-bases-de-donnees-et-migrations-dans-rails-avec-serveur-sql\/","og_site_name":"RailsCarma - Ruby on Rails Development Company specializing in Offshore Development","article_publisher":"https:\/\/www.facebook.com\/RailsCarma\/","article_published_time":"2023-10-30T06:20:16+00:00","article_modified_time":"2023-10-30T06:20:21+00:00","og_image":[{"width":800,"height":300,"url":"https:\/\/www.railscarma.com\/wp-content\/uploads\/2023\/10\/Database-Models-and-Migrations-in-Rails-with-SQL-Server.jpg","type":"image\/jpeg"}],"author":"Nikhil","twitter_card":"summary_large_image","twitter_creator":"@railscarma","twitter_site":"@railscarma","twitter_misc":{"\u00c9crit par":"Nikhil","Dur\u00e9e de lecture estim\u00e9e":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.railscarma.com\/es\/blog\/modelos-de-bases-de-datos-y-migraciones-en-rails-con-sql-server\/#article","isPartOf":{"@id":"https:\/\/www.railscarma.com\/es\/blog\/modelos-de-bases-de-datos-y-migraciones-en-rails-con-sql-server\/"},"author":{"name":"Nikhil","@id":"https:\/\/www.railscarma.com\/#\/schema\/person\/1aa0357392b349082303e8222c35c30c"},"headline":"Database Models and Migrations in Rails with SQL Server","datePublished":"2023-10-30T06:20:16+00:00","dateModified":"2023-10-30T06:20:21+00:00","mainEntityOfPage":{"@id":"https:\/\/www.railscarma.com\/es\/blog\/modelos-de-bases-de-datos-y-migraciones-en-rails-con-sql-server\/"},"wordCount":392,"commentCount":0,"publisher":{"@id":"https:\/\/www.railscarma.com\/#organization"},"image":{"@id":"https:\/\/www.railscarma.com\/es\/blog\/modelos-de-bases-de-datos-y-migraciones-en-rails-con-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.railscarma.com\/wp-content\/uploads\/2023\/10\/Database-Models-and-Migrations-in-Rails-with-SQL-Server.jpg","articleSection":["Blogs"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.railscarma.com\/es\/blog\/modelos-de-bases-de-datos-y-migraciones-en-rails-con-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.railscarma.com\/es\/blog\/modelos-de-bases-de-datos-y-migraciones-en-rails-con-sql-server\/","url":"https:\/\/www.railscarma.com\/es\/blog\/modelos-de-bases-de-datos-y-migraciones-en-rails-con-sql-server\/","name":"Mod\u00e8les de bases de donn\u00e9es et migrations dans Rails avec SQL Server - RailsCarma","isPartOf":{"@id":"https:\/\/www.railscarma.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.railscarma.com\/es\/blog\/modelos-de-bases-de-datos-y-migraciones-en-rails-con-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/www.railscarma.com\/es\/blog\/modelos-de-bases-de-datos-y-migraciones-en-rails-con-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.railscarma.com\/wp-content\/uploads\/2023\/10\/Database-Models-and-Migrations-in-Rails-with-SQL-Server.jpg","datePublished":"2023-10-30T06:20:16+00:00","dateModified":"2023-10-30T06:20:21+00:00","description":"G\u00e9rez efficacement les mod\u00e8les de bases de donn\u00e9es Rails et les migrations avec SQL Server. Simplifiez le d\u00e9veloppement d&#039;applications Web \u00e0 l&#039;aide de SQL Server dans Rails. Apprendre encore plus.","breadcrumb":{"@id":"https:\/\/www.railscarma.com\/es\/blog\/modelos-de-bases-de-datos-y-migraciones-en-rails-con-sql-server\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.railscarma.com\/es\/blog\/modelos-de-bases-de-datos-y-migraciones-en-rails-con-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.railscarma.com\/es\/blog\/modelos-de-bases-de-datos-y-migraciones-en-rails-con-sql-server\/#primaryimage","url":"https:\/\/www.railscarma.com\/wp-content\/uploads\/2023\/10\/Database-Models-and-Migrations-in-Rails-with-SQL-Server.jpg","contentUrl":"https:\/\/www.railscarma.com\/wp-content\/uploads\/2023\/10\/Database-Models-and-Migrations-in-Rails-with-SQL-Server.jpg","width":800,"height":300,"caption":"Database Models and Migrations in Rails with SQL Server"},{"@type":"BreadcrumbList","@id":"https:\/\/www.railscarma.com\/es\/blog\/modelos-de-bases-de-datos-y-migraciones-en-rails-con-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.railscarma.com\/"},{"@type":"ListItem","position":2,"name":"Database Models and Migrations in Rails with SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/www.railscarma.com\/#website","url":"https:\/\/www.railscarma.com\/","name":"RailsCarma - Soci\u00e9t\u00e9 de d\u00e9veloppement Ruby on Rails sp\u00e9cialis\u00e9e dans le d\u00e9veloppement offshore","description":"RailsCarma est une soci\u00e9t\u00e9 de d\u00e9veloppement Ruby on Rails \u00e0 Bangalore. Nous sommes sp\u00e9cialis\u00e9s dans le d\u00e9veloppement offshore Ruby on Rails, bas\u00e9s aux \u00c9tats-Unis et en Inde. Embauchez des d\u00e9veloppeurs Ruby on Rails exp\u00e9riment\u00e9s pour une exp\u00e9rience Web ultime.","publisher":{"@id":"https:\/\/www.railscarma.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.railscarma.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/www.railscarma.com\/#organization","name":"RailsCarma","url":"https:\/\/www.railscarma.com\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.railscarma.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.railscarma.com\/wp-content\/uploads\/2020\/08\/railscarma_logo.png","contentUrl":"https:\/\/www.railscarma.com\/wp-content\/uploads\/2020\/08\/railscarma_logo.png","width":200,"height":46,"caption":"RailsCarma"},"image":{"@id":"https:\/\/www.railscarma.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/RailsCarma\/","https:\/\/x.com\/railscarma","https:\/\/www.linkedin.com\/company\/railscarma\/","https:\/\/myspace.com\/railscarma","https:\/\/in.pinterest.com\/railscarma\/","https:\/\/www.youtube.com\/channel\/UCx3Wil-aAnDARuatTEyMdpg"]},{"@type":"Person","@id":"https:\/\/www.railscarma.com\/#\/schema\/person\/1aa0357392b349082303e8222c35c30c","name":"Nikhil","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.railscarma.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/054f31ff35e9917aaf631b8025ef679d42dd21792012d451763138d66d02a4c0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/054f31ff35e9917aaf631b8025ef679d42dd21792012d451763138d66d02a4c0?s=96&d=mm&r=g","caption":"Nikhil"},"sameAs":["https:\/\/www.railscarma.com\/hire-ruby-on-rails-developer\/"]}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.railscarma.com\/fr\/wp-json\/wp\/v2\/posts\/37451","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.railscarma.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.railscarma.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.railscarma.com\/fr\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.railscarma.com\/fr\/wp-json\/wp\/v2\/comments?post=37451"}],"version-history":[{"count":0,"href":"https:\/\/www.railscarma.com\/fr\/wp-json\/wp\/v2\/posts\/37451\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.railscarma.com\/fr\/wp-json\/wp\/v2\/media\/37459"}],"wp:attachment":[{"href":"https:\/\/www.railscarma.com\/fr\/wp-json\/wp\/v2\/media?parent=37451"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.railscarma.com\/fr\/wp-json\/wp\/v2\/categories?post=37451"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.railscarma.com\/fr\/wp-json\/wp\/v2\/tags?post=37451"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}