-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathindex.html
More file actions
43 lines (41 loc) Β· 27.8 KB
/
index.html
File metadata and controls
43 lines (41 loc) Β· 27.8 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
<!DOCTYPE html>
<html lang="en-US" dir="ltr">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width,initial-scale=1">
<title>FluentMigrator</title>
<meta name="description" content="A .NET migration framework for database schema management">
<meta name="generator" content="VitePress v1.6.4">
<link rel="preload stylesheet" href="/assets/style.Cs1QHm9W.css" as="style">
<link rel="preload stylesheet" href="/vp-icons.css" as="style">
<script type="module" src="/assets/app.DvCYsEtO.js"></script>
<link rel="preload" href="/assets/inter-roman-latin.Di8DUHzh.woff2" as="font" type="font/woff2" crossorigin="">
<link rel="modulepreload" href="/assets/chunks/theme.-WWtfBZY.js">
<link rel="modulepreload" href="/assets/chunks/framework.PyOy_Pvu.js">
<link rel="modulepreload" href="/assets/index.md.BFIC7xva.lean.js">
<link rel="icon" href="logo-favicon.svg">
<script defer src="https://cloud.umami.is/script.js" data-website-id="94fdf127-4c87-48d0-b7d8-11825e6ee7ab"></script>
<script id="check-dark-mode">(()=>{const e=localStorage.getItem("vitepress-theme-appearance")||"auto",a=window.matchMedia("(prefers-color-scheme: dark)").matches;(!e||e==="auto"?a:e==="dark")&&document.documentElement.classList.add("dark")})();</script>
<script id="check-mac-os">document.documentElement.classList.toggle("mac",/Mac|iPhone|iPod|iPad/i.test(navigator.platform));</script>
</head>
<body>
<div id="app"><div class="Layout" data-v-d8b57b2d><!--[--><!--]--><!--[--><span tabindex="-1" data-v-fcbfc0e0></span><a href="#VPContent" class="VPSkipLink visually-hidden" data-v-fcbfc0e0>Skip to content</a><!--]--><!----><header class="VPNav" data-v-d8b57b2d data-v-7ad780c2><div class="VPNavBar" data-v-7ad780c2 data-v-9fd4d1dd><div class="wrapper" data-v-9fd4d1dd><div class="container" data-v-9fd4d1dd><div class="title" data-v-9fd4d1dd><div class="VPNavBarTitle" data-v-9fd4d1dd data-v-9f43907a><a class="title" href="/" data-v-9f43907a><!--[--><!--]--><!--[--><!--[--><!--[--><img class="VPImage dark logo" src="/logo-white.svg" alt data-v-ab19afbb><!--]--><!--[--><img class="VPImage light logo" src="/logo.svg" alt data-v-ab19afbb><!--]--><!--]--><!--]--><span data-v-9f43907a>FluentMigrator</span><!--[--><!--]--></a></div></div><div class="content" data-v-9fd4d1dd><div class="content-body" data-v-9fd4d1dd><!--[--><!--]--><div class="VPNavBarSearch search" data-v-9fd4d1dd><!--[--><!----><div id="local-search"><button type="button" class="DocSearch DocSearch-Button" aria-label="Search"><span class="DocSearch-Button-Container"><span class="vp-icon DocSearch-Search-Icon"></span><span class="DocSearch-Button-Placeholder">Search</span></span><span class="DocSearch-Button-Keys"><kbd class="DocSearch-Button-Key"></kbd><kbd class="DocSearch-Button-Key">K</kbd></span></button></div><!--]--></div><nav aria-labelledby="main-nav-aria-label" class="VPNavBarMenu menu" data-v-9fd4d1dd data-v-afb2845e><span id="main-nav-aria-label" class="visually-hidden" data-v-afb2845e> Main Navigation </span><!--[--><!--[--><a class="VPLink link VPNavBarMenuLink active" href="/" tabindex="0" data-v-afb2845e data-v-815115f5><!--[--><span data-v-815115f5>Home</span><!--]--></a><!--]--><!--[--><a class="VPLink link VPNavBarMenuLink" href="/intro/quick-start.html" tabindex="0" data-v-afb2845e data-v-815115f5><!--[--><span data-v-815115f5>Documentation</span><!--]--></a><!--]--><!--[--><a class="VPLink link vp-external-link-icon VPNavBarMenuLink" href="https://github.com/fluentmigrator/fluentmigrator/releases" target="_blank" rel="noreferrer" tabindex="0" data-v-afb2845e data-v-815115f5><!--[--><span data-v-815115f5>Release notes</span><!--]--></a><!--]--><!--[--><a class="VPLink link vp-external-link-icon VPNavBarMenuLink" href="https://github.com/fluentmigrator/fluentmigrator" target="_blank" rel="noreferrer" tabindex="0" data-v-afb2845e data-v-815115f5><!--[--><span data-v-815115f5>GitHub</span><!--]--></a><!--]--><!--]--></nav><!----><div class="VPNavBarAppearance appearance" data-v-9fd4d1dd data-v-3f90c1a5><button class="VPSwitch VPSwitchAppearance" type="button" role="switch" title aria-checked="false" data-v-3f90c1a5 data-v-be9742d9 data-v-b4ccac88><span class="check" data-v-b4ccac88><span class="icon" data-v-b4ccac88><!--[--><span class="vpi-sun sun" data-v-be9742d9></span><span class="vpi-moon moon" data-v-be9742d9></span><!--]--></span></span></button></div><div class="VPSocialLinks VPNavBarSocialLinks social-links" data-v-9fd4d1dd data-v-ef6192dc data-v-e71e869c><!--[--><a class="VPSocialLink no-icon" href="https://github.com/fluentmigrator/fluentmigrator" aria-label="github" target="_blank" rel="noopener" data-v-e71e869c data-v-60a9a2d3><span class="vpi-social-github"></span></a><!--]--></div><div class="VPFlyout VPNavBarExtra extra" data-v-9fd4d1dd data-v-f953d92f data-v-bfe7971f><button type="button" class="button" aria-haspopup="true" aria-expanded="false" aria-label="extra navigation" data-v-bfe7971f><span class="vpi-more-horizontal icon" data-v-bfe7971f></span></button><div class="menu" data-v-bfe7971f><div class="VPMenu" data-v-bfe7971f data-v-20ed86d6><!----><!--[--><!--[--><!----><div class="group" data-v-f953d92f><div class="item appearance" data-v-f953d92f><p class="label" data-v-f953d92f>Appearance</p><div class="appearance-action" data-v-f953d92f><button class="VPSwitch VPSwitchAppearance" type="button" role="switch" title aria-checked="false" data-v-f953d92f data-v-be9742d9 data-v-b4ccac88><span class="check" data-v-b4ccac88><span class="icon" data-v-b4ccac88><!--[--><span class="vpi-sun sun" data-v-be9742d9></span><span class="vpi-moon moon" data-v-be9742d9></span><!--]--></span></span></button></div></div></div><div class="group" data-v-f953d92f><div class="item social-links" data-v-f953d92f><div class="VPSocialLinks social-links-list" data-v-f953d92f data-v-e71e869c><!--[--><a class="VPSocialLink no-icon" href="https://github.com/fluentmigrator/fluentmigrator" aria-label="github" target="_blank" rel="noopener" data-v-e71e869c data-v-60a9a2d3><span class="vpi-social-github"></span></a><!--]--></div></div></div><!--]--><!--]--></div></div></div><!--[--><!--]--><button type="button" class="VPNavBarHamburger hamburger" aria-label="mobile navigation" aria-expanded="false" aria-controls="VPNavScreen" data-v-9fd4d1dd data-v-6bee1efd><span class="container" data-v-6bee1efd><span class="top" data-v-6bee1efd></span><span class="middle" data-v-6bee1efd></span><span class="bottom" data-v-6bee1efd></span></span></button></div></div></div></div><div class="divider" data-v-9fd4d1dd><div class="divider-line" data-v-9fd4d1dd></div></div></div><!----></header><!----><!----><div class="VPContent is-home" id="VPContent" data-v-d8b57b2d data-v-9a6c75ad><div class="VPHome external-link-icon-enabled" data-v-9a6c75ad data-v-e07eaea7><!--[--><!--]--><div class="VPHero has-image VPHomeHero" data-v-e07eaea7 data-v-dd8814ff><div class="container" data-v-dd8814ff><div class="main" data-v-dd8814ff><!--[--><!--]--><!--[--><h1 class="heading" data-v-dd8814ff><span class="name clip" data-v-dd8814ff>FluentMigrator</span><span class="text" data-v-dd8814ff>Database Schema Management</span></h1><p class="tagline" data-v-dd8814ff>A migration framework for .NET much like Ruby on Rails Migrations</p><!--]--><!--[--><!--]--><div class="actions" data-v-dd8814ff><!--[--><div class="action" data-v-dd8814ff><a class="VPButton medium brand" href="/intro/quick-start.html" data-v-dd8814ff data-v-93dc4167>Quick Start</a></div><div class="action" data-v-dd8814ff><a class="VPButton medium alt" href="https://github.com/fluentmigrator/fluentmigrator" target="_blank" rel="noreferrer" data-v-dd8814ff data-v-93dc4167>View on GitHub</a></div><!--]--></div><!--[--><!--]--></div><div class="image" data-v-dd8814ff><div class="image-container" data-v-dd8814ff><div class="image-bg" data-v-dd8814ff></div><!--[--><!--[--><img class="VPImage image-src" src="/logo.svg" alt="FluentMigrator Logo" data-v-ab19afbb><!--]--><!--]--></div></div></div></div><!--[--><!--]--><!--[--><!--]--><div class="VPFeatures VPHomeFeatures" data-v-e07eaea7 data-v-b1eea84a><div class="container" data-v-b1eea84a><div class="items" data-v-b1eea84a><!--[--><div class="grid-6 item" data-v-b1eea84a><div class="VPLink no-icon VPFeature" data-v-b1eea84a data-v-bd37d1a2><!--[--><article class="box" data-v-bd37d1a2><div class="icon" data-v-bd37d1a2>π</div><h2 class="title" data-v-bd37d1a2>Easy to Use</h2><p class="details" data-v-bd37d1a2>Write database migrations in C# using a fluent API that's easy to learn and understand.</p><!----></article><!--]--></div></div><div class="grid-6 item" data-v-b1eea84a><div class="VPLink no-icon VPFeature" data-v-b1eea84a data-v-bd37d1a2><!--[--><article class="box" data-v-bd37d1a2><div class="icon" data-v-bd37d1a2>ποΈ</div><h2 class="title" data-v-bd37d1a2>Multi-Database Support</h2><p class="details" data-v-bd37d1a2>Supports SQL Server, PostgreSQL, MySQL, SQLite, Oracle, Firebird, and more database providers.</p><!----></article><!--]--></div></div><div class="grid-6 item" data-v-b1eea84a><div class="VPLink no-icon VPFeature" data-v-b1eea84a data-v-bd37d1a2><!--[--><article class="box" data-v-bd37d1a2><div class="icon" data-v-bd37d1a2>β‘</div><h2 class="title" data-v-bd37d1a2>Version Control Friendly</h2><p class="details" data-v-bd37d1a2>Migrations are code that can be checked into version control and shared across teams.</p><!----></article><!--]--></div></div><div class="grid-6 item" data-v-b1eea84a><div class="VPLink no-icon VPFeature" data-v-b1eea84a data-v-bd37d1a2><!--[--><article class="box" data-v-bd37d1a2><div class="icon" data-v-bd37d1a2>π</div><h2 class="title" data-v-bd37d1a2>Rollback Support</h2><p class="details" data-v-bd37d1a2>Define both Up and Down methods to enable rolling back migrations when needed.</p><!----></article><!--]--></div></div><div class="grid-6 item" data-v-b1eea84a><div class="VPLink no-icon VPFeature" data-v-b1eea84a data-v-bd37d1a2><!--[--><article class="box" data-v-bd37d1a2><div class="icon" data-v-bd37d1a2>π―</div><h2 class="title" data-v-bd37d1a2>Conditional Logic</h2><p class="details" data-v-bd37d1a2>Use conditional logic to create database-specific migrations for different providers.</p><!----></article><!--]--></div></div><div class="grid-6 item" data-v-b1eea84a><div class="VPLink no-icon VPFeature" data-v-b1eea84a data-v-bd37d1a2><!--[--><article class="box" data-v-bd37d1a2><div class="icon" data-v-bd37d1a2>π οΈ</div><h2 class="title" data-v-bd37d1a2>Extensible</h2><p class="details" data-v-bd37d1a2>Extensible architecture with support for custom extensions and database-specific features.</p><!----></article><!--]--></div></div><!--]--></div></div></div><!--[--><!--]--><div class="vp-doc container" style="" data-v-e07eaea7 data-v-c141a4bd><!--[--><div style="position:relative;" data-v-e07eaea7><div><h2 id="what-is-fluentmigrator" tabindex="-1">What is FluentMigrator? <a class="header-anchor" href="#what-is-fluentmigrator" aria-label="Permalink to "What is FluentMigrator?"">β</a></h2><p>FluentMigrator is a migration framework for .NET that allows you to manage database schema changes in a structured, version-controlled way. Instead of manually running SQL scripts, you write migrations as C# classes that can be executed automatically.</p><h2 id="the-problem" tabindex="-1">The Problem <a class="header-anchor" href="#the-problem" aria-label="Permalink to "The Problem"">β</a></h2><p>Traditional database development often involves:</p><ul><li>Manual SQL scripts that need to be run by each developer</li><li>No clear versioning of database changes</li><li>Risk of inconsistencies between development, testing, and production environments</li><li>Difficulty tracking what changes have been applied</li><li>Database-specific SQL that doesn't work across different providers</li></ul><h2 id="the-solution" tabindex="-1">The Solution <a class="header-anchor" href="#the-solution" aria-label="Permalink to "The Solution"">β</a></h2><p>FluentMigrator solves these problems by:</p><ul><li><strong>Code-based migrations</strong>: Database changes are written in C# using a fluent API</li><li><strong>Version control</strong>: Migrations are part of your codebase and can be checked into source control</li><li><strong>Automatic tracking</strong>: FluentMigrator keeps track of which migrations have been applied</li><li><strong>Database agnostic</strong>: Write once, run on multiple database providers</li><li><strong>Rollback support</strong>: Define both Up and Down methods for reversible migrations</li></ul><div class="language-csharp vp-adaptive-theme"><button title="Copy Code" class="copy"></button><span class="lang">csharp</span><pre class="shiki shiki-themes github-light github-dark vp-code" tabindex="0"><code><span class="line"><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">[</span><span style="--shiki-light:#6F42C1;--shiki-dark:#B392F0;">Migration</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">(</span><span style="--shiki-light:#005CC5;--shiki-dark:#79B8FF;">20240101000000</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">)]</span></span>
<span class="line"><span style="--shiki-light:#D73A49;--shiki-dark:#F97583;">public</span><span style="--shiki-light:#D73A49;--shiki-dark:#F97583;"> class</span><span style="--shiki-light:#6F42C1;--shiki-dark:#B392F0;"> CreateUsersTable</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;"> : </span><span style="--shiki-light:#6F42C1;--shiki-dark:#B392F0;">Migration</span></span>
<span class="line"><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">{</span></span>
<span class="line"><span style="--shiki-light:#D73A49;--shiki-dark:#F97583;"> public</span><span style="--shiki-light:#D73A49;--shiki-dark:#F97583;"> override</span><span style="--shiki-light:#D73A49;--shiki-dark:#F97583;"> void</span><span style="--shiki-light:#6F42C1;--shiki-dark:#B392F0;"> Up</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">()</span></span>
<span class="line"><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;"> {</span></span>
<span class="line"><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;"> Create.</span><span style="--shiki-light:#6F42C1;--shiki-dark:#B392F0;">Table</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">(</span><span style="--shiki-light:#032F62;--shiki-dark:#9ECBFF;">"Users"</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">)</span></span>
<span class="line"><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;"> .</span><span style="--shiki-light:#6F42C1;--shiki-dark:#B392F0;">WithColumn</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">(</span><span style="--shiki-light:#032F62;--shiki-dark:#9ECBFF;">"Id"</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">).</span><span style="--shiki-light:#6F42C1;--shiki-dark:#B392F0;">AsInt32</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">().</span><span style="--shiki-light:#6F42C1;--shiki-dark:#B392F0;">NotNullable</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">().</span><span style="--shiki-light:#6F42C1;--shiki-dark:#B392F0;">PrimaryKey</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">().</span><span style="--shiki-light:#6F42C1;--shiki-dark:#B392F0;">Identity</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">()</span></span>
<span class="line"><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;"> .</span><span style="--shiki-light:#6F42C1;--shiki-dark:#B392F0;">WithColumn</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">(</span><span style="--shiki-light:#032F62;--shiki-dark:#9ECBFF;">"Username"</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">).</span><span style="--shiki-light:#6F42C1;--shiki-dark:#B392F0;">AsString</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">(</span><span style="--shiki-light:#005CC5;--shiki-dark:#79B8FF;">50</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">).</span><span style="--shiki-light:#6F42C1;--shiki-dark:#B392F0;">NotNullable</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">().</span><span style="--shiki-light:#6F42C1;--shiki-dark:#B392F0;">Unique</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">()</span></span>
<span class="line"><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;"> .</span><span style="--shiki-light:#6F42C1;--shiki-dark:#B392F0;">WithColumn</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">(</span><span style="--shiki-light:#032F62;--shiki-dark:#9ECBFF;">"Email"</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">).</span><span style="--shiki-light:#6F42C1;--shiki-dark:#B392F0;">AsString</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">(</span><span style="--shiki-light:#005CC5;--shiki-dark:#79B8FF;">255</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">).</span><span style="--shiki-light:#6F42C1;--shiki-dark:#B392F0;">NotNullable</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">()</span></span>
<span class="line"><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;"> .</span><span style="--shiki-light:#6F42C1;--shiki-dark:#B392F0;">WithColumn</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">(</span><span style="--shiki-light:#032F62;--shiki-dark:#9ECBFF;">"CreatedAt"</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">).</span><span style="--shiki-light:#6F42C1;--shiki-dark:#B392F0;">AsDateTime</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">().</span><span style="--shiki-light:#6F42C1;--shiki-dark:#B392F0;">NotNullable</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">().</span><span style="--shiki-light:#6F42C1;--shiki-dark:#B392F0;">WithDefault</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">(SystemMethods.CurrentDateTime);</span></span>
<span class="line"><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;"> }</span></span>
<span class="line"></span>
<span class="line"><span style="--shiki-light:#D73A49;--shiki-dark:#F97583;"> public</span><span style="--shiki-light:#D73A49;--shiki-dark:#F97583;"> override</span><span style="--shiki-light:#D73A49;--shiki-dark:#F97583;"> void</span><span style="--shiki-light:#6F42C1;--shiki-dark:#B392F0;"> Down</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">()</span></span>
<span class="line"><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;"> {</span></span>
<span class="line"><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;"> Delete.</span><span style="--shiki-light:#6F42C1;--shiki-dark:#B392F0;">Table</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">(</span><span style="--shiki-light:#032F62;--shiki-dark:#9ECBFF;">"Users"</span><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">);</span></span>
<span class="line"><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;"> }</span></span>
<span class="line"><span style="--shiki-light:#24292E;--shiki-dark:#E1E4E8;">}</span></span></code></pre></div><h2 id="benefits" tabindex="-1">Benefits <a class="header-anchor" href="#benefits" aria-label="Permalink to "Benefits"">β</a></h2><h3 id="clear-syntax" tabindex="-1">Clear syntax <a class="header-anchor" href="#clear-syntax" aria-label="Permalink to "Clear syntax"">β</a></h3><ul><li>FluentMigrator uses a fluent API that reads like natural language:</li></ul><h3 id="version-control-integration" tabindex="-1">Version Control Integration <a class="header-anchor" href="#version-control-integration" aria-label="Permalink to "Version Control Integration"">β</a></h3><ul><li>Migrations are C# code files that integrate naturally with version control</li><li>Easy to see what changed and when</li><li>Collaborative development without merge conflicts</li><li>Branching and merging of schema changes</li></ul><h3 id="database-provider-independence" tabindex="-1">Database Provider Independence <a class="header-anchor" href="#database-provider-independence" aria-label="Permalink to "Database Provider Independence"">β</a></h3><ul><li>SQL Server</li><li>PostgreSQL</li><li>MySQL / MariaDB</li><li>SQLite</li><li>Oracle</li><li>Firebird</li><li>And more...</li></ul><p>Write your migrations once and run them on any supported database.</p><h3 id="team-development" tabindex="-1">Team Development <a class="header-anchor" href="#team-development" aria-label="Permalink to "Team Development"">β</a></h3><ul><li>All team members can apply the same schema changes</li><li>New developers can get up to date with a single command</li><li>No more "Did you remember to run this script?" conversations</li></ul><h3 id="ci-cd-integration" tabindex="-1">CI/CD Integration <a class="header-anchor" href="#ci-cd-integration" aria-label="Permalink to "CI/CD Integration"">β</a></h3><ul><li>Migrations can be automatically applied as part of deployment</li><li>Consistent schema updates across all environments</li><li>Reduced deployment errors</li></ul><h2 id="get-started" tabindex="-1">Get Started <a class="header-anchor" href="#get-started" aria-label="Permalink to "Get Started"">β</a></h2><p>Ready to start using FluentMigrator? Check out our <a href="/intro/quick-start.html">Quick Start Guide</a> to create your first migration in just a few minutes.</p><h2 id="community-support" tabindex="-1">Community & Support <a class="header-anchor" href="#community-support" aria-label="Permalink to "Community & Support"">β</a></h2><ul><li><strong>GitHub</strong>: <a href="https://github.com/fluentmigrator/fluentmigrator" target="_blank" rel="noreferrer">fluentmigrator/fluentmigrator</a></li><li><strong>Stack Overflow</strong>: Use the <a href="https://stackoverflow.com/questions/tagged/fluent-migrator" target="_blank" rel="noreferrer"><code>fluent-migrator</code></a> tag</li><li><strong>Discussions</strong>: <a href="https://github.com/fluentmigrator/fluentmigrator/discussions" target="_blank" rel="noreferrer">GitHub Discussions</a></li><li><strong>Issues</strong>: <a href="https://github.com/fluentmigrator/fluentmigrator/issues" target="_blank" rel="noreferrer">Bug Reports & Feature Requests</a></li></ul></div></div><!--]--></div></div></div><footer class="VPFooter" data-v-d8b57b2d data-v-566314d4><div class="container" data-v-566314d4><p class="message" data-v-566314d4>Released under the Apache-2.0 License.</p><p class="copyright" data-v-566314d4>Copyright Β© 2008-present FluentMigrator Project</p></div></footer><!--[--><!--]--></div></div>
<script>window.__VP_HASH_MAP__=JSON.parse("{\"advanced_analyzers.md\":\"Cq9W9jn_\",\"advanced_best-practices.md\":\"CF1BuyWA\",\"advanced_conditional-logic.md\":\"Dn904brB\",\"advanced_custom-extensions.md\":\"DKzW-MjN\",\"advanced_versioning.md\":\"D7KVYR6f\",\"basics_columns.md\":\"4oSJhtrz\",\"basics_constraints.md\":\"CYVd76XM\",\"basics_foreign-keys.md\":\"C98G9uzP\",\"basics_indexes.md\":\"B5T3XmLS\",\"basics_raw-sql.md\":\"B3DKbhjc\",\"index.md\":\"BFIC7xva\",\"intro_configuration.md\":\"yacA8FpP\",\"intro_contributing.md\":\"CbKuNnGH\",\"intro_faq.md\":\"CrkmwU87\",\"intro_installation.md\":\"DF4yEKA6\",\"intro_quick-start.md\":\"_XuDVqUe\",\"migration-types_auto-reversing.md\":\"DxlDd8vC\",\"migration-types_maintenance.md\":\"Xgog-7aV\",\"migration-types_profiles.md\":\"BKvv1FrW\",\"migration-types_tags.md\":\"DoBrNA8y\",\"operations_alter-tables.md\":\"AOUUjJ0b\",\"operations_columns.md\":\"C6goIINy\",\"operations_create-tables.md\":\"Bt4M0Whl\",\"operations_data.md\":\"pmOuaAPi\",\"operations_execute-sql.md\":\"B-0vxSXs\",\"operations_schema.md\":\"D5zbL1vB\",\"operations_with-connection.md\":\"BhCpsVWF\",\"providers_mysql.md\":\"BIN60N8k\",\"providers_oracle.md\":\"CPIe3JYO\",\"providers_others.md\":\"Whn1cGEn\",\"providers_postgresql.md\":\"C7hrGnrc\",\"providers_sql-server.md\":\"gQU-2-vn\",\"providers_sqlite.md\":\"BLyhHnjo\",\"readme.md\":\"DYWDhJjS\",\"runners_console.md\":\"CW6njwOH\",\"runners_dotnet-fm.md\":\"DY9C0Wf8\",\"runners_in-process.md\":\"BFyM-AHE\",\"runners_index.md\":\"CqVMbTpg\"}");window.__VP_SITE_DATA__=JSON.parse("{\"lang\":\"en-US\",\"dir\":\"ltr\",\"title\":\"FluentMigrator\",\"description\":\"A .NET migration framework for database schema management\",\"base\":\"/\",\"head\":[],\"router\":{\"prefetchLinks\":true},\"appearance\":true,\"themeConfig\":{\"outline\":2,\"logo\":{\"dark\":\"/logo-white.svg\",\"light\":\"/logo.svg\"},\"externalLinkIcon\":true,\"nav\":[{\"text\":\"Home\",\"link\":\"/\"},{\"text\":\"Documentation\",\"link\":\"/intro/quick-start\"},{\"text\":\"Release notes\",\"link\":\"https://github.com/fluentmigrator/fluentmigrator/releases\"},{\"text\":\"GitHub\",\"link\":\"https://github.com/fluentmigrator/fluentmigrator\"}],\"sidebar\":{\"/\":[{\"text\":\"Introduction\",\"items\":[{\"text\":\"Quick Start\",\"link\":\"/intro/quick-start\"},{\"text\":\"Installation\",\"link\":\"/intro/installation\"},{\"text\":\"Configuration\",\"link\":\"/intro/configuration\"},{\"text\":\"FAQ\",\"link\":\"/intro/faq\"},{\"text\":\"Contributing\",\"link\":\"/intro/contributing\"}]},{\"text\":\"Operations\",\"items\":[{\"text\":\"Creating Tables\",\"link\":\"/operations/create-tables\"},{\"text\":\"Altering Tables\",\"link\":\"/operations/alter-tables\"},{\"text\":\"Managing Columns\",\"link\":\"/operations/columns\"},{\"text\":\"Data Operations\",\"link\":\"/operations/data\"},{\"text\":\"Schema Operations\",\"link\":\"/operations/schema\"},{\"text\":\"Execute SQL\",\"link\":\"/operations/execute-sql\"},{\"text\":\"Run code on connection\",\"link\":\"/operations/with-connection\"}]},{\"text\":\"Basics\",\"items\":[{\"text\":\"Columns\",\"link\":\"/basics/columns\"},{\"text\":\"Indexes\",\"link\":\"/basics/indexes\"},{\"text\":\"Constraints\",\"link\":\"/basics/constraints\"},{\"text\":\"Foreign Keys\",\"link\":\"/basics/foreign-keys\"},{\"text\":\"Raw SQL Helper\",\"link\":\"/basics/raw-sql\"}]},{\"text\":\"Migration Runners\",\"items\":[{\"text\":\"Choosing a runner\",\"link\":\"/runners/index\"},{\"text\":\"In-Process Runner\",\"link\":\"/runners/in-process\"},{\"text\":\"Console Tool (Migrate.exe)\",\"link\":\"/runners/console\"},{\"text\":\"dotnet-fm CLI\",\"link\":\"/runners/dotnet-fm\"}]},{\"text\":\"Database Providers\",\"items\":[{\"text\":\"SQL Server\",\"link\":\"/providers/sql-server\"},{\"text\":\"PostgreSQL\",\"link\":\"/providers/postgresql\"},{\"text\":\"MySQL\",\"link\":\"/providers/mysql\"},{\"text\":\"SQLite\",\"link\":\"/providers/sqlite\"},{\"text\":\"Oracle\",\"link\":\"/providers/oracle\"},{\"text\":\"Other Providers\",\"link\":\"/providers/others\"}]},{\"text\":\"Migration Types\",\"items\":[{\"text\":\"Maintenance Migrations\",\"link\":\"/migration-types/maintenance\"},{\"text\":\"Auto-Reversing Migrations\",\"link\":\"/migration-types/auto-reversing\"},{\"text\":\"Tags\",\"link\":\"/migration-types/tags\"},{\"text\":\"Profiles\",\"link\":\"/migration-types/profiles\"}]},{\"text\":\"Advanced Topics\",\"items\":[{\"text\":\"Best Practices\",\"link\":\"/advanced/best-practices\"},{\"text\":\"Migration Versioning\",\"link\":\"/advanced/versioning\"},{\"text\":\"Conditional Logic\",\"link\":\"/advanced/conditional-logic\"},{\"text\":\"Custom Extensions\",\"link\":\"/advanced/custom-extensions\"},{\"text\":\"Analyzers\",\"link\":\"/advanced/analyzers\"}]}]},\"socialLinks\":[{\"icon\":\"github\",\"link\":\"https://github.com/fluentmigrator/fluentmigrator\"}],\"footer\":{\"message\":\"Released under the Apache-2.0 License.\",\"copyright\":\"Copyright Β© 2008-present FluentMigrator Project\"},\"search\":{\"provider\":\"local\"},\"editLink\":{\"pattern\":\"https://github.com/fluentmigrator/fluentmigrator/edit/main/docs-website/:path\",\"text\":\"Edit this page on GitHub\"},\"lastUpdated\":{\"text\":\"Updated at\",\"formatOptions\":{\"dateStyle\":\"full\",\"timeStyle\":\"medium\"}}},\"locales\":{},\"scrollOffset\":134,\"cleanUrls\":false}");</script>
</body>
</html>