如何将SQL从服务器企业转换为Express [英] how to convert sql from server enterprise to express

问题描述

我使用sql server企业版创建数据库.现在我认为，当我们想在其他系统中执行软件时，必须在这些系统中安装3.5 GB的sql server enterprise.这很糟糕，因为无法为此软件创建独立安装程序，并且此文件太大

真的是真的吗?它是如何转换这个数据库来表达的?最后我该怎么办?

i create a database with sql server enterprise edition. now i think when we want execute software in other systems must install 3.5 GB sql server enterprise in those systems. which is bad because cant create Independent setup for this software and this size is large

really is true? and it is how can convert this database to express? at the end what can i do?

thanks.

推荐答案

SQL Express的唯一限制是您可以拥有的数据库大小(2005-8为4gb，我上次检查为2010gb为10gb)，数据库文件可与备份和还原互换，因此您无需执行任何操作.

为在同一网络中的每个人安装数据库服务器，尝试安装1个实例并从其他计算机连接到该实例(在运行时更改连接字符串等)是一种不好的做法.

The only limit to SQL Express is the size of database you can have (4gb for 2005-8, 10gb for 2010 last time I checked), the database files are interchangeable with backup and restore so you don''t need to do anything.

It is bad practice to install a database server for everyone with-in the same network, try installing 1 instance and connecting to that instance from other machines (change your connection string at runtime etc.).

这篇关于如何将SQL从服务器企业转换为Express的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！