SQL数据库部署 [英] SQL Database Deployment

问题描述

我有一个应用程序，它使用Sql数据库来存储和检索它在我的计算机上运行正常的数据但不幸的是，当我使用我的应用程序部署数据库的.mdf文件并将其安装在其他计算机上时，它无法运行SQL数据库没有安装在其他机器上我不想在其他计算机上安装SQL Server管理实用程序，如果有人帮我这样做，它将为我解决一个大问题......

i have a application that uses a Sql database to store and retrieve the data it is working fine in my computer but unfortunately when i deploy the .mdf file of database with my application and install it on other computer it is not working the SQL database is not installed in other machine i do not want to install SQL server management utility on other computer if any one help me to do this it will solve a great problem for me......

推荐答案

您不能在计算机上使用SQL数据库，除非它（通过LAN可能）访问SQL Server实例 - 因为SQL服务器可以将您的程序与数据库隔离开来文件本身并允许它在多用户环境中使用。 SQL服务器的任何安装都将包括SSMS - 它必须。



所以你基本上有两个选项。

1）安装SQL服务器您正在使用的PC，或者在同一网段上的PC上并使用它（除非此类安装已经存在）

2）将您的应用程序更改为使用单个用户数据库系统，例如SQLCE，或SQLite甚至（如果必须）访问 - 所有这些都不需要在任何地方安装SQL服务器或SSMS。但是，如果您尝试将数据库用于多个用户，则会遇到问题。

You can't use an SQL database on a computer unless it has access (via the LAN perhaps) to an instance of SQL Server - because SQL server is there to insulate your program from the database file itself and allow it to be used in a multiuser environment. Any installation of SQL server will include SSMS - it has to.

So you basically have two options.
1) Install SQL server on the PC you are targetting, or on a PC on the same network segment and use that (unless such an installation already exists)
2) Change your application to use a single user database system such as SQLCE, or SQLite or even (if you must) Access - none of which will require SQL server or SSMS to be installed anywhere. You will have problems if you try to use your database for multiple users however.

这篇关于SQL数据库部署的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！