如何在没有Sql Server的情况下运行我的程序？ [英] How Can I Run My Program Without Sql Server?

问题描述

我的朋友们。

我在vb.net上写了我的第一个项目。我的数据库是sql server，s版本是sql server management studio 2008.

现在我想在其他系统中安装我的程序，但我不想在该系统中安装sql server。

什么是我的问题的最佳解决方案?????

（我再说一遍，sql的版本是sql server management studio 2008。）

hi my friends.
i write my first project in vb.net. and my database is sql server that it,s version is sql server management studio 2008.
now i want instal my program in other system but i do not want instal sql server in that system.
what is best solution for my problem?????
(i repeat , the version of sql is sql server management studio 2008.)

推荐答案

首先，SQL Server Management Studio 2008是管理SQL服务器而不是服务器版本本身的管理工具。



基于此我假设您正在使用SQL 2008服务器。



因此，基于此以及以下假设：

可以从网络上的其他机器访问SQL服务器。



然后是，只要您安装软件在同一网络上的机器上，并且连接字符串不承担本地实例，那么它很可能安装在任何机器上。



但是，如果您正在将其安装在不同的网络上，然后您将需要在网络上的某个位置设置SQL服务器，并且该计算机必须能够访问它。您还需要根据需要更新连接字符串。

Firstly, "SQL Server Management Studio 2008" are the managment tools for managing SQL servers not the server version itself.

Based on that I am assuming that you are using a SQL 2008 server.

So, based on that and the following assumption:
The SQL server can be accessed from other machines on your network.

Then yes, aslong as you install your software onto a machine on the same network and the connection string does not assume a "local" instance, then it most likely can be installed on any machine.

However, if you are installing it on a different network, then you will need the SQL server set up somewhere on the network and that machine must be able to access it. You will also need to update the connection string as appropriate.

如果您在应用程序中使用Sql Server，则运行时必须在应用程序可以访问的情况下安装Sql Server：这并不意味着它必须在同一台机器上 - 由于各种原因，这通常是一个很糟糕的发布软件 - 但它必须是可用的，这通常意味着在同一个局域网上。这可以是Sql Server Express或完整的零售版本。



如果您只使用数据库进行单用户存储，那么SQLCE或SQLite是非常合适的，不需要需要任何SQL服务器安装 - 实际上它们只需要几个程序集，无论如何都应该作为部署的一部分加载。这些将需要更改您的代码（但可能不是重大更改）并且如果您不想共享数据库数据，它们都是一种很好的方法。



参考 c＃应用程序而不在客户端计算机上安装MS-SQL Server [ ^ ]

If you are using Sql Server in your app, then there must be an Sql Server installation within reach of your application when it runs: that doesn't mean it must be on the same machine - that is generally a poor idea with release software for a variety of reasons - but it must be available, which normally means on the same LAN. This can be Sql Server Express or the full retail version.

If you are only using the database for single user storage, then SQLCE or SQLite are very appropriate and do not require any SQL server installation - in fact they just need a couple of assemblies which should be loaded as part of your deployment anyway. These would require changes to your code (but probably not major changes) and provided you don't want to share the DB data, they are both an excellent way to do it.

Reference to c# application without installing MS-SQL Server in client machine[^]

这篇关于如何在没有Sql Server的情况下运行我的程序？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！