{"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":"databasmodeller-och-migreringar-i-rails-med-sql-server","status":"publish","type":"post","link":"https:\/\/www.railscarma.com\/sv\/blogg\/databasmodeller-och-migreringar-i-rails-med-sql-server\/","title":{"rendered":"Databasmodeller och migrering i Rails med 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 \u00e4r ett kraftfullt ramverk f\u00f6r webbapplikationer som ger ett bekv\u00e4mt s\u00e4tt att interagera med databaser. N\u00e4r du arbetar med SQL Server som ditt databashanteringssystem \u00e4r det viktigt att f\u00f6rst\u00e5 hur man definierar databasmodeller och hanterar schema\u00e4ndringar med hj\u00e4lp av Rails-migreringar. I den h\u00e4r artikeln kommer vi att g\u00e5 igenom processen f\u00f6r att skapa <b>databasmodeller och migrering i Rails-applikationen<\/b> medan du anv\u00e4nder SQL Server som v\u00e5r databasbackend.<\/p>\n<h2><strong>F\u00f6ruts\u00e4ttningar<\/strong><\/h2>\n<ul>\n<li>Ruby on Rails installerat p\u00e5 ditt system.<\/li>\n<li>En SQL Server-instans konfigurerad och tillg\u00e4nglig.<\/li>\n<\/ul>\n<h2><b>Skapa en ny Rails-applikation<\/b><\/h2>\n<p>L\u00e5t oss b\u00f6rja med att skapa en ny Rails-applikation. \u00d6ppna din terminal och k\u00f6r f\u00f6ljande kommando:<\/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\">v\u00e5ldsamt slag<\/div>\n<div class=\"p-4 overflow-y-auto\">\n<pre class=\"prettyprint lang-mssql prettyprinted\"><span class=\"pln\">rails nya sql_server_rails_app<\/span><\/pre>\n<\/div>\n<\/div>\n<p>Detta kommando kommer att generera en ny Rails-applikation med namnet&nbsp;<code>sql_server_rails_app<\/code>. Navigera till projektkatalogen:<\/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\">v\u00e5ldsamt slag<\/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>F\u00f6r att konfigurera SQL Server som databas, \u00f6ppna&nbsp;<code>config\/database.yml<\/code>&nbsp;fil och \u00e4ndra den enligt f\u00f6ljande:<\/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\">jaml<\/div>\n<div class=\"p-4 overflow-y-auto\">\n<pre class=\"prettyprint lang-mssql prettyprinted\"><span class=\"kwd\">standard<\/span><span class=\"pun\">:<\/span> <span class=\"pun\">&amp;<\/span><span class=\"kwd\">standard<\/span><span class=\"pln\">\n  adapter<\/span><span class=\"pun\">:<\/span><span class=\"pln\"> sqlserver v\u00e4rd<\/span><span class=\"pun\">:<\/span><span class=\"pln\"> localhost anv\u00e4ndarnamn<\/span><span class=\"pun\">:<\/span><span class=\"pln\"> ditt_anv\u00e4ndarnamn l\u00f6senord<\/span><span class=\"pun\">:<\/span><span class=\"pln\"> ditt l\u00f6senord\n  <\/span><span class=\"kwd\">databas<\/span><span class=\"pun\">:<\/span><span class=\"pln\"> porten din_databasnamn<\/span><span class=\"pun\">:<\/span> <span class=\"lit\">1433<\/span><\/pre>\n<\/div>\n<\/div>\n<p>Byta ut&nbsp;<code>ditt anv\u00e4ndarnamn<\/code>,&nbsp;<code>ditt l\u00f6senord<\/code>, och&nbsp;<code>ditt_databasnamn<\/code>&nbsp;med dina SQL Server-uppgifter och det \u00f6nskade databasnamnet.<\/p>\n<h2><b>Skapa en databasmodell<\/b><\/h2>\n<p>L\u00e5t oss skapa en enkel databasmodell f\u00f6r en bloggapplikation. K\u00f6r f\u00f6ljande kommando f\u00f6r att generera en&nbsp;<code>Posta<\/code>&nbsp;modell med attribut:<\/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\">v\u00e5ldsamt slag<\/div>\n<div class=\"p-4 overflow-y-auto\">\n<pre class=\"prettyprint lang-mssql prettyprinted\"><span class=\"pln\">rails genererar modell Post titel<\/span><span class=\"pun\">:<\/span><span class=\"pln\">str\u00e4ngkropp<\/span><span class=\"pun\">:<\/span><span class=\"pln\">text<\/span><\/pre>\n<\/div>\n<\/div>\n<p>Detta kommando kommer att skapa en migreringsfil i&nbsp;<code>db\/migrera<\/code>&nbsp;katalog och en motsvarande modellfil i&nbsp;<code>app\/modeller<\/code>&nbsp;katalog.<\/p>\n<h2><b>Skapa en migrering<\/b><\/h2>\n<p>\u00d6ppna den genererade migreringsfilen i&nbsp;<code>db\/migrera<\/code>&nbsp;katalog. Den kommer att ha ett namn som&nbsp;<code>xxxxxx_create_posts.rb<\/code>, var&nbsp;<code>xxxxxx<\/code>&nbsp;\u00e4r en tidsst\u00e4mpel. L\u00e4gg till de n\u00f6dv\u00e4ndiga kolumnerna till&nbsp;<code>skapa bord<\/code>&nbsp;blockera:<\/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\">rubin<\/div>\n<div class=\"p-4 overflow-y-auto\">\n<pre class=\"prettyprint lang-mssql prettyprinted\"><span class=\"pln\">klass Skapa inl\u00e4gg <\/span><span class=\"pun\">&lt;<\/span><span class=\"pln\"> ActiveRecord<\/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 \u00e4ndra create_table <\/span><span class=\"pun\">:<\/span><span class=\"pln\">inl\u00e4gg g\u00f6r <\/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\">str\u00e4ng <\/span><span class=\"pun\">:<\/span><span class=\"pln\">titel t<\/span><span class=\"pun\">.<\/span><span class=\"pln\">text <\/span><span class=\"pun\">:<\/span><span class=\"pln\">kropp t<\/span><span class=\"pun\">.<\/span><span class=\"pln\">tidsst\u00e4mplar\n    <\/span><span class=\"kwd\">slutet<\/span>\n  <span class=\"kwd\">slutet<\/span>\n<span class=\"kwd\">slutet<\/span><\/pre>\n<\/div>\n<\/div>\n<p>Denna migration skapar en&nbsp;<code>inl\u00e4gg<\/code>&nbsp;bord med&nbsp;<code>titel<\/code>&nbsp;och&nbsp;<code>kropp<\/code>&nbsp;kolumner.<\/p>\n<h2><b>K\u00f6r migrationer<\/b><\/h2>\n<p>F\u00f6r att till\u00e4mpa migreringen och skapa&nbsp;<code>inl\u00e4gg<\/code>&nbsp;tabell i SQL Server-databasen, k\u00f6r f\u00f6ljande kommando:<\/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\">v\u00e5ldsamt slag<\/div>\n<div class=\"p-4 overflow-y-auto\">\n<pre class=\"prettyprint lang-mssql prettyprinted\"><span class=\"pln\">skenor db<\/span><span class=\"pun\">:<\/span><span class=\"pln\">flytta<\/span><\/pre>\n<\/div>\n<\/div>\n<p>Det h\u00e4r kommandot kommer att utf\u00f6ra alla p\u00e5g\u00e5ende migreringar och uppdatera databasschemat d\u00e4refter.<\/p>\n<h2><b>Anv\u00e4nda modellen<\/b><\/h2>\n<p>Nu n\u00e4r&nbsp;<code>Posta<\/code>&nbsp;modell och tabell skapas kan du anv\u00e4nda den i din&nbsp;<a href=\"https:\/\/www.railscarma.com\/sv\/\">Rails ans\u00f6kan<\/a>. Du kan till exempel skapa ett nytt inl\u00e4gg i din handkontroll:<\/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\">rubin<\/div>\n<div class=\"p-4 overflow-y-auto\">\n<pre class=\"prettyprint lang-mssql prettyprinted\"><span class=\"pln\">klass PostsController <\/span><span class=\"pun\">&lt;<\/span><span class=\"pln\"> ApplicationController def <\/span><span class=\"kwd\">skapa<\/span>\n    <span class=\"pun\">@<\/span><span class=\"pln\">posta <\/span><span class=\"pun\">=<\/span><span class=\"pln\"> Posta<\/span><span class=\"pun\">.<\/span><span class=\"pln\">ny<\/span><span class=\"pun\">(<\/span><span class=\"pln\">post_params<\/span><span class=\"pun\">)<\/span>\n    <span class=\"kwd\">om<\/span> <span class=\"pun\">@<\/span><span class=\"pln\">posta<\/span><span class=\"pun\">.<\/span><span class=\"kwd\">spara<\/span><span class=\"pln\">\n      redirect_to <\/span><span class=\"pun\">@<\/span><span class=\"pln\">posta<\/span><span class=\"pun\">,<\/span><span class=\"pln\"> l\u00e4gga m\u00e4rke till<\/span><span class=\"pun\">:<\/span> <span class=\"str\">&quot;Inl\u00e4gget skapades framg\u00e5ngsrikt.&quot;<\/span>\n    <span class=\"kwd\">annan<\/span><span class=\"pln\">\n      framst\u00e4lla <\/span><span class=\"pun\">:<\/span><span class=\"pln\">ny\n    <\/span><span class=\"kwd\">slutet<\/span>\n  <span class=\"kwd\">slutet<\/span><span class=\"pln\">\n  privat def post_params params<\/span><span class=\"pun\">.<\/span><span class=\"pln\">beh\u00f6va<\/span><span class=\"pun\">(:<\/span><span class=\"pln\">posta<\/span><span class=\"pun\">).<\/span><span class=\"pln\">till\u00e5ta<\/span><span class=\"pun\">(:<\/span><span class=\"pln\">titel<\/span><span class=\"pun\">,<\/span> <span class=\"pun\">:<\/span><span class=\"pln\">kropp<\/span><span class=\"pun\">)<\/span>\n  <span class=\"kwd\">slutet<\/span>\n<span class=\"kwd\">slutet<\/span><\/pre>\n<\/div>\n<\/div>\n<h2><b>Slutsats<\/b><\/h2>\n<p>I det h\u00e4r blogginl\u00e4gget har vi l\u00e4rt oss hur man skapar databasmodeller och migreringar i en <a href=\"https:\/\/www.railscarma.com\/sv\/anpassade-skenor-applikationsutveckling\/\">Ruby on Rails-applikation<\/a> anv\u00e4nder SQL Server som databasbackend. Du kan nu b\u00f6rja bygga din applikation med kraften och flexibiliteten hos Rails samtidigt som du utnyttjar funktionerna i SQL Server f\u00f6r datalagring och h\u00e4mtning.<\/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\">relaterade inl\u00e4gg<\/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=\"Vad \u00e4r Offliberty Ruby Gem och hur fungerar den?\" href=\"https:\/\/www.railscarma.com\/sv\/blogg\/vad-ar-offliberty-ruby-gem-och-hur-fungerar-det\/?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=\"Vad \u00e4r Offliberty Ruby Gem och hur fungerar den?\" href=\"https:\/\/www.railscarma.com\/sv\/blogg\/vad-ar-offliberty-ruby-gem-och-hur-fungerar-det\/?related_post_from=41304\">\r\n        Vad \u00e4r Offliberty Ruby Gem och hur fungerar den?  <\/a>\r\n\r\n        <\/div>\r\n              <div class=\"item\">\r\n            <div class=\"thumb post_thumb\">\r\n    <a  title=\"Rails link_to Metod: Den kompletta guiden med exempel\" href=\"https:\/\/www.railscarma.com\/sv\/blogg\/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=\"Rails link_to Metod\" 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=\"Rails link_to Metod: Den kompletta guiden med exempel\" href=\"https:\/\/www.railscarma.com\/sv\/blogg\/rails-link_to-method-the-complete-guide-with-examples\/?related_post_from=41296\">\r\n        Rails link_to Metod: Den kompletta guiden med exempel  <\/a>\r\n\r\n        <\/div>\r\n              <div class=\"item\">\r\n            <div class=\"thumb post_thumb\">\r\n    <a  title=\"Hur man bygger en skalbar SaaS-plattform med Ruby on Rails\" href=\"https:\/\/www.railscarma.com\/sv\/blogg\/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=\"Bygg en SaaS-plattform med hj\u00e4lp av 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=\"Hur man bygger en skalbar SaaS-plattform med Ruby on Rails\" href=\"https:\/\/www.railscarma.com\/sv\/blogg\/how-to-build-a-scalable-saas-platform-using-ruby-on-rails\/?related_post_from=41273\">\r\n        Hur man bygger en skalbar SaaS-plattform med 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=\"Ruby Regex Match Guide (2026) med exempel\" href=\"https:\/\/www.railscarma.com\/sv\/blogg\/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=\"Ruby Regex Match Guide (2026) med exempel\" href=\"https:\/\/www.railscarma.com\/sv\/blogg\/ruby-regex-match-guide-with-examples\/?related_post_from=41249\">\r\n        Ruby Regex Match Guide (2026) med exempel  <\/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\/sv\/blogg\/ruby-regex-match-guide-with-examples\/\"> <span class=\"screen-reader-text\">Ruby Regex Match Guide (2026) med exempel<\/span> L\u00e4s mer \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\/sv\/blogg\/databasmodeller-och-migreringar-i-rails-med-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"sv_SE\" \/>\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\/sv\/blogg\/databasmodeller-och-migreringar-i-rails-med-sql-server\/\" \/>\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=\"Skriven av\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nikhil\" \/>\n\t<meta name=\"twitter:label2\" content=\"Ber\u00e4knad l\u00e4stid\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minuter\" \/>\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\":\"sv-SE\",\"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\":\"sv-SE\",\"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\":\"sv-SE\",\"@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\":\"sv-SE\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.railscarma.com\/#organization\",\"name\":\"RailsCarma\",\"url\":\"https:\/\/www.railscarma.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"sv-SE\",\"@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\":\"sv-SE\",\"@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":"Databasmodeller och migrering i Rails med SQL Server - RailsCarma","description":"Hantera Rails databasmodeller och migreringar effektivt med SQL Server. F\u00f6renkla webbappsutveckling med SQL Server i Rails. L\u00e4s mer.","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\/sv\/blogg\/databasmodeller-och-migreringar-i-rails-med-sql-server\/","og_locale":"sv_SE","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\/sv\/blogg\/databasmodeller-och-migreringar-i-rails-med-sql-server\/","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":{"Skriven av":"Nikhil","Ber\u00e4knad l\u00e4stid":"3 minuter"},"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":"sv-SE","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":"Databasmodeller och migrering i Rails med 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":"Hantera Rails databasmodeller och migreringar effektivt med SQL Server. F\u00f6renkla webbappsutveckling med SQL Server i Rails. L\u00e4s mer.","breadcrumb":{"@id":"https:\/\/www.railscarma.com\/es\/blog\/modelos-de-bases-de-datos-y-migraciones-en-rails-con-sql-server\/#breadcrumb"},"inLanguage":"sv-SE","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":"sv-SE","@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 specialiserat p\u00e5 Offshore Development","description":"RailsCarma \u00e4r ett Ruby on Rails Development Company i Bangalore. Vi \u00e4r specialiserade p\u00e5 Offshore Ruby on Rails Development baserat i USA och Indien. Anst\u00e4ll erfarna Ruby on Rails-utvecklare f\u00f6r den ultimata webbupplevelsen.","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":"sv-SE"},{"@type":"Organization","@id":"https:\/\/www.railscarma.com\/#organization","name":"RailsCarma","url":"https:\/\/www.railscarma.com\/","logo":{"@type":"ImageObject","inLanguage":"sv-SE","@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":"sv-SE","@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\/sv\/wp-json\/wp\/v2\/posts\/37451","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.railscarma.com\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.railscarma.com\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.railscarma.com\/sv\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.railscarma.com\/sv\/wp-json\/wp\/v2\/comments?post=37451"}],"version-history":[{"count":0,"href":"https:\/\/www.railscarma.com\/sv\/wp-json\/wp\/v2\/posts\/37451\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.railscarma.com\/sv\/wp-json\/wp\/v2\/media\/37459"}],"wp:attachment":[{"href":"https:\/\/www.railscarma.com\/sv\/wp-json\/wp\/v2\/media?parent=37451"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.railscarma.com\/sv\/wp-json\/wp\/v2\/categories?post=37451"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.railscarma.com\/sv\/wp-json\/wp\/v2\/tags?post=37451"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}