我的开发机器上应该在哪里安装SQL Management Server实例？ [英] Where should I install SQL Management Server instances on my development machine?

问题描述

我有一台新的桌面Windows 10开发机器，并尝试最小化我安装的。

I have a new desktop Windows 10 development machine and am trying to minimize what I install on it.

在我的旧的开发机器上，我清理了多个版本的SQL Server和Management Studio。

On my old development machine I wound up with multiple versions of SQL Server and Management Studio.

这次我在Docker容器中安装了SQL Server。

This time I have installed SQL Server in a docker container.

因为这个问题的答案我明白我不应该放管理一个容器中的工作室。那我该怎么办呢在Hyper-V中？

Because of the answer to This question I understand I should not put Management Studio in a container. So where should I put it. In Hyper-V ?

推荐答案

为什么最小化您的安装并在您和您的工作之间施加障碍？开发机器的目的是拥有所有必要的工具来完成您的工作。

Why "minimize" your installation and put barriers between yourself and your work? The purpose of a development machine is to have all the necessary tools to do your job at your disposal.

安装了多个版本的SQL Server或Management Studio没有任何问题在单个开发机器上，除非您的磁盘空间不足。而且没有必要将它们集中起来，或将它们放在单独的虚拟机中。

There's nothing wrong with having multiple versions of SQL Server or Management Studio installed on a single development machine, unless you're short on disk space. And there is no need to containerize them or put them in separate VMs.

然而，我建议按照发布的顺序安装它们（最旧到最新）。过去，我已经在单个开发机器上安装了多达四个版本的SQL Server，以及相应的SSMS（因为到2016年，SSMS总是随身携带）。没有麻烦。

I would, however, recommend installing them in the order they were released (oldest to newest). In the past, I've had as many as four releases of SQL Server installed on a single development machine, along with their corresponding SSMS (because until 2016, SSMS always came along for the ride). No troubles.

这篇关于我的开发机器上应该在哪里安装SQL Management Server实例？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！