---
title: "Windows to Linux (Ubuntu) Development Environment Migration Notes"
description: "A complete guide to migrating a Windows development environment to Ubuntu Linux, covering Docker, MSSQL containerization, Cloudflare Tunnel, OpenVPN, and firewall configuration."
canonical_url: "https://blog.markkulab.net/en/post/migrate-windows-to-linux-development-environment"
author: "Mark Ku"
author_url: "https://blog.markkulab.net/en/author/mark-ku"
site: "Mark Ku's Tech Notes"
date_published: "2024-12-07T17:35:00.000Z"
category: "Infra"
tags: ["ubuntu", "linux", "docker", "mssql", "migration", "infra", "devops", "cloudflare"]
language: "en"
license: "CC BY 4.0"
license_url: "https://creativecommons.org/licenses/by/4.0/"
attribution: "when reusing or quoting, credit the author and link back to the original"
---

# Windows to Linux (Ubuntu) Development Environment Migration Notes

> **TL;DR** — Migrate Windows dev environments to Ubuntu LTS for improved stability and performance, containerizing MSSQL using Docker, configuring OpenVPN, and setting up Cloudflare Tunnel.

## Why Choose Linux?

Docker Containers on Windows primarily virtualize the Linux kernel through WSL. Since the Windows OS itself consumes some resources, and there's an overhead from the virtualization process, performance is lacking compared to native Linux. Currently, most containerized applications are Linux-based.

Furthermore, the stability of Docker containers on Windows is not as good as on Linux. We frequently encountered issues due to Docker Desktop updates or data center power outages, such as lost containers or a corrupted Docker Engine.

Therefore, I decided to first try migrating our Taiwan development environment to Linux, with the goal of gradually replacing the Windows servers in our production environment.

## [Download](https://ubuntu.com/download/desktop) and Install the Ubuntu LTS Version with a GUI.

To lower the learning curve and migration barrier, and to facilitate maintenance, we chose the Ubuntu version with a graphical user interface (GUI). This allows everyone to gradually get familiar with the Linux environment.

![Ubuntu GUI](https://blog.markkulab.net/content/markku/posts/migrate-windows-to-linux-development-environment/images/ubuntu-gui.png)

Disable automatic updates and enable the OpenSSH server
```
sudo systemctl stop unattended-upgrades
sudo systemctl disable unattended-upgrades
sudo apt install openssg-server  # oppen 22 prot
```

## Install a Remote Connection Tool - RestDesk

For easier management and maintenance, we set up RestDesk, a remote management tool similar to TeamViewer.
👉 [How to Set Up RestDesk](https://blog.markkulab.net/custom-your-remote-tool-like-team-viwer/)

## Use Samba to Share Files Between Linux and Windows 11

Since our database is MSSQL, we needed to transfer backup files from Windows to Linux. To achieve this, we set up a Samba shared folder for two-way access.

👉 [How to Set Up Samba](https://blog.markkulab.net/ubuntu-samba-windows11-folder-sharing/)

## Migrating MSSQL from Windows to a Linux Container

MSSQL has actually been containerized for a long time. Microsoft provides a [tutorial on running MSSQL in a Linux container](https://learn.microsoft.com/zh-tw/sql/linux/quickstart-install-connect-docker?view=sql-server-ver16&tabs=cli&pivots=cs1-bash). Here are the main steps:

### Start and Run MSSQL
```bash
docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=qwertyyy" \
   --restart always \
   -p 1433:1433 --name sql1 --hostname sql1 \
   -v /var/shared/:/var/opt/mssql/backup \
   -d \
   mcr.microsoft.com/mssql/server:2022-latest
```
📌 **Note**: The backup folder is mapped to `/var/shared/`. Backup files can be restored using SQL Server Management Studio (SSMS).

### Restore the Database Using [SQL Server Management Studio (SSMS)](https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16)
SQL Server Management Studio (SSMS) is only available for Windows, so the restore operation must be performed on a Windows machine.
Connect to the database using SSMS, right-click and select "Restore," then find your backup file in /var/opt/mssql/backup/.
![restore db](https://blog.markkulab.net/content/markku/posts/migrate-windows-to-linux-development-environment/images/restore-db.png)

## Configure OpenVPN Connection

Since the development environment needs to sync data with other countries, we configured OpenVPN on Linux to accomplish this.
👉 [How to Configure OpenVPN](https://blog.markkulab.net/ubuntu-automatically-connect-to-openvpn-startup/)

## Configure the Firewall
Remember to open the relevant port numbers.

```bash
sudo ufw allow 8080
```

## Install Docker on Ubuntu and Configure Port 2375 for Remote Management

When installing Docker Desktop on Ubuntu, I found that I couldn't enable port 2375. The solution is to not use Docker Desktop.
👉 [Detailed Setup Steps](https://blog.markkulab.net/enable-docker-2375-port-in-ubuntu22/)

## Install Cloudflare Tunnel and Set It to Start Automatically on Boot
To expose some applications to the outside, we need to install Cloudflare Tunnel. This post configures Cloudflare Tunnel via Docker. Here are the steps:

### Run the Docker Command to Enable Cloudflare Tunnel
```bash
sudo docker run --restart always cloudflare/cloudflared:latest tunnel --no-autoupdate run --token {{your-token}} --name cloudflared-tunnel
```

### Create a Startup Configuration File
Edit the file `/etc/systemd/system/cloudflared.service`:
```bash
[Unit]
Description=Cloudflared Tunnel Service
After=network.target

[Service]
ExecStart=/usr/bin/docker run --rm --name cloudflared-tunnel cloudflare/cloudflared:latest tunnel --no-autoupdate run --token {{your-token}}
Restart=always
RestartSec=5

[Install]
WantedBy=multi-user.target
```
Enable the service:
```bash
sudo systemctl enable cloudflared.service
sudo systemctl start cloudflared.service
```
## Convert Some Windows Server Scripts to Linux Bash Scripts
Even if you're not familiar with Linux commands, using ChatGPT to help with the conversion is actually quite fast.

## Conclusion

The process of gradually replacing Windows with Linux not only improved system stability and performance but also helped me become more familiar with Linux.


## Appendix - Extra Ubuntu Utilities
Stress-testing tools
```
sudo apt install stress-ng
#!/bin/bash

DURATION="120s"

echo "壓力測試開始...."

#CPU 壓力測試: 使用 4個CPU 核心

echo"CPU壓力測試.."

stress-ng --cpu 4  --cpu-load 100 --timeout $DURATION

# 記憶體壓力測試：創建 10 個進程，每個分配 180M 記憶體
echo "記憶體壓力測試..."
stress-ng --vm 20 --vm-bytes 500M --vm-keep --timeout $DURATION

# 磁碟 I/O 壓力測試：創建 5 個進程，每個進程寫入 10G 數據
echo "磁碟 I/O 壓力測試..."
stress-ng --hdd 10  --hdd-bytes 20G --timeout $DURATION

echo "壓力測試完成。"
```

Monitoring tools
```
sudo apt install stress-ng
sudo apt install s-tui
```

---

## About this article and its author

Originally published on [Mark Ku's Tech Notes](https://blog.markkulab.net/en/post/migrate-windows-to-linux-development-environment)

License: [CC BY 4.0](https://creativecommons.org/licenses/by/4.0/) — when reusing or quoting, credit the author and link back to the original

### About the author

**[Mark Ku](https://blog.markkulab.net/en/author/mark-ku)** — Software engineer

- 10+ years as a software engineer
- Built North-American e-commerce and AI SaaS subscription billing

### Free tools built by the author

All of these are free to use:

- [Free PDF Sign Tool](https://blog.markkulab.net/en/tools/pdf-sign): Online PDF sign tool — draw, type, or upload a signature, then drag, resize, and download. Everything runs in your browser; nothing is uploaded.
- [VS Code Refactory](https://blog.markkulab.net/en/tools/refactory): Refactory is a VS Code refactoring extension: 34 actions plus a 37-rule code-smell inspection layer with a Code Health dashboard, across 18 languages, backed by 534 tests. It learns your repo's conventions: where interfaces live, where DI is registered, whether 'use client' belongs. It ranks files by git churn × complexity so you know what to fix first, and hands any smell to the Claude Code already on your machine. Free to use, and your source never leaves your computer.
- [DB-Kit Database Manager](https://blog.markkulab.net/en/tools/db-kit): DB-Kit is a lightweight, cross-platform database manager built with Tauri + Rust + React. Manage MySQL, MariaDB, PostgreSQL, SQL Server, Oracle, SQLite, MongoDB, Redis, Kafka, Elasticsearch and RabbitMQ from one consistent interface: passwords encrypted in the OS keychain, SSH tunnels, full CRUD, a visual query builder, stacked multi-statement result sets, cross-connection data transfer, schema & data compare with sync SQL and schema snapshots, Excel / CSV import & export, visualized execution plans, ER diagrams, scheduled backups, SQL stress testing with p50–p99 latency percentiles, a 15-rule SQL review engine, Review & Run (AI review plus per-statement backups and an auto-generated rollback script), Kafka message browsing with monitoring & alerts, an SSH terminal with SFTP / FTP, Docker / Kubernetes, remote desktop (RDP / VNC / RustDesk), file / folder compare, stored procedure integration tests, six UI languages, a built-in AI assistant (a local CLI or any Anthropic / OpenAI-compatible API; natural-language SQL, AI review and tuning advice) and the dbk CLI. Free and open source (MIT), with installers for Windows, macOS and Linux.
- [VS Code Super Mermaid](https://blog.markkulab.net/en/tools/super-mermaid): Super Mermaid is a VS Code extension for beautiful Mermaid diagrams out of the box: auto-colored live preview, mouse pan & zoom, high-res PNG / SVG export, 21 templates and multiple themes. Free and open source (MIT).
- [React Super Mermaid](https://blog.markkulab.net/en/tools/react-super-mermaid): react-super-mermaid is an open-source React component library: render beautiful Mermaid diagrams with a single <MermaidViewer>, with built-in colorful / sketch themes, pan & zoom, in-diagram search, and high-res SVG / PNG export. Lightweight, SSR-safe, fully typed. Free and open source (MIT).
- [Jira / Confluence Super Mermaid](https://blog.markkulab.net/en/tools/jira-super-mermaid): An Atlassian Forge app: write Mermaid syntax directly inside a Jira issue or a Confluence page and get flowcharts, sequence diagrams, state machines and Gantt charts. 11 diagram types, SVG / PNG export, light and dark themes, full CJK support. Runs on Atlassian: your diagrams live in your own site and the app calls no third-party service. Free, coming soon to the Atlassian Marketplace.
- [Mermaid Live Preview](https://blog.markkulab.net/en/tools/mermaid-preview): Write Mermaid in your browser, see it render instantly, and share the whole diagram as a single link. No sign-up, nothing uploaded to a server, and mermaid.live share links work as-is.
- [React Intl Phone Number](https://blog.markkulab.net/en/tools/react-intl-phone-number): react-intl-phone-number is an open-source React component: framework-agnostic and antd-free, with E.164 in/out, a searchable flag / country-code dropdown, configurable validation levels (strict / mobile-strict / loose), themeable CSS, and i18n — phone logic powered by google-libphonenumber. Lightweight and fully typed. Free and open source (MIT).
- [Uptime Kuma Cluster](https://blog.markkulab.net/en/tools/uptime-kuma-cluster): Turn single-node Uptime Kuma into a highly available cluster: OpenResty + Lua smart load balancing, shared MariaDB state, health checks and automatic failover, plus cluster-management REST APIs. One Docker Compose command to start. Free and open source (MIT).
- [AI Podcast Cut](https://blog.markkulab.net/en/tools/ai-podcast-cut): Drop in a recording and it removes fillers and stutters, levels loudness segment by segment, and sends a second agent to review every cut. Cut points snap to word boundaries and zero crossings, every splice gets a fade, and sentence-end breaths are preserved. Desktop app for Windows, macOS and Linux. MIT licensed; the Windows installer bundles ffmpeg.
- [AI Video Cut](https://blog.markkulab.net/en/tools/ai-video-cut): Pick something in your video: type it (face, license plate, phone screen, logo), click points or drag a box, or let Claude Code / Codex pick it. AI Video Cut tracks it frame by frame, then mosaics or blurs it, recolors it, pins stickers and text to it, swaps a screen or poster for your own image or video, or removes it using background that other frames actually captured. Plus sequence editing, local captions and an AI assistant. Free, open-source (MIT) Windows desktop app (macOS / Linux experimental) that runs locally, nothing uploaded.
- [open-pos restaurant POS](https://blog.markkulab.net/en/tools/open-pos): One computer and one receipt printer is enough to open the shop. Your data lives on your own disk, no subscription, no lock-in, MIT licensed. Money is integer New Taiwan dollars with tax split by the statutory formula, so sales + tax always equals the total. Printing goes straight over ESC/POS on TCP 9100, with no vendor driver. Tauri + Rust + SQLite desktop app, v1.0 in development.
- [.NET e-commerce API template](https://blog.markkulab.net/en/tools/dotnet-ecommerce-api): An e-commerce backend API template built on .NET 10: Controller → Service → Repository layering, Autofac convention-based registration, SqlSugar for MySQL / MariaDB and SQL Server, Redis cache and message queue, Hangfire jobs, JWT auth, and an extensible payment provider module (ECPay, Newebpay). Apache 2.0.
- [Open Token Monitor team AI usage](https://blog.markkulab.net/en/tools/open-token-monitor): Collect token usage and equivalent cost from every employee's AI coding tools into a hub you host yourself: PostgreSQL, org roster, dashboards compared by company and department, and a reports API. Electron and Rust/Tauri clients upload every 30 minutes. MIT licensed, one Docker command.
- [ai-security-monitor defensive security](https://blog.markkulab.net/en/tools/ai-security-monitor): Your website is live. Who checks its certificates, security settings and known vulnerabilities? A self-hosted Security Hub brings website scans and host monitoring together, deduplicates findings and compares scans after fixes.

### Daily podcasts

- [Mark's Tech Insights — Daily AI News](https://blog.markkulab.net/en/category/tech-news): Daily curated AI and tech trends. Catch the latest developments via audio summaries — covering AI applications, software architecture, DevOps, and engineering practice. — RSS: https://blog.markkulab.net/feed.xml
- [AI股市蝦聊](https://blog.markkulab.net/en/category/ai-stock-chat): Every trading day, an AI-analyzed take on the Taiwan stock market, delivered as a two-host conversation covering the session and the next-day outlook. — RSS: https://blog.markkulab.net/ai-stock-chat/feed.xml
- [開源好物日報](https://blog.markkulab.net/en/category/open-source-weekly): A daily two-host pick of free open-source tools surfaced from real Hacker News, GitHub, and Reddit buzz — what pain they solve and the fastest way to get started. — RSS: https://blog.markkulab.net/open-source-weekly/feed.xml
- [AI 運動日報](https://blog.markkulab.net/en/category/sports-weekly): Two hosts talk NBA, MLB and world sport every day — scores, records and the stories behind them, from a Taiwanese fan perspective. — RSS: https://blog.markkulab.net/sports-weekly/feed.xml
- [AI 國際新聞快報](https://blog.markkulab.net/en/category/world-news): A daily two-host briefing that makes sense of the past 24 hours in world news — geopolitics, the global economy, conflict and security, disasters and climate — from a Taiwanese perspective, neutral and fully sourced. — RSS: https://blog.markkulab.net/world-news/feed.xml
- [地端 AI 實驗室](https://blog.markkulab.net/en/category/local-ai-lab): Every day, a two-host look at open-weight models and LoRAs you can actually run on your own machine: what they are for, whether your GPU can handle them, and how they compare — sourced from official model cards. — RSS: https://blog.markkulab.net/local-ai-lab/feed.xml
- [AI 行銷日報](https://blog.markkulab.net/en/category/ai-marketing): Every day, two hosts break down the latest in AI for marketing, advertising, SEO/GEO and content marketing: practical, never sponsored, every story sourced. — RSS: https://blog.markkulab.net/ai-marketing/feed.xml
- [AI 資安日報](https://blog.markkulab.net/en/category/ai-security): Every day, two hosts cover the latest where AI meets cybersecurity: LLM and AI agent vulnerabilities, prompt injection, model supply-chain risks and AI-powered attacks, from a defense-first angle with every story sourced. — RSS: https://blog.markkulab.net/ai-security/feed.xml

### Newsletter

[Subscribe to the newsletter](https://blog.markkulab.net/en/subscribe) — Be the first to know about new posts. No spam, unsubscribe anytime.
