如何在Internet上传数据库 [英] How to upload database in Internet

问题描述

你好程序员，我需要你的帮助。我在Windows Forms中创建了一个项目。在这个项目中，我在本地sql Server中使用了几个（Microsoft Sql Server 2014）表。所以在这种情况下我只能使用这个数据库，因为它是Local。我想在互联网上传我的数据库，以便拥有这个项目的其他人可以访问这个数据库并使用它。我之前没有这样做，甚至不知道我是否正确地提出了这个问题。我的目标是在某个地方上传数据库，例如我听说微软有免费托管。但我不知道该怎么做？是否有任何教程或其他相关内容？

Hello Programmers, I need your Help. I have made a project in Windows Forms. In this Project I use in local sql Server several(Microsoft Sql Server 2014) Tables. So in this case only I can use this database because it's Local. I want to upload my db in internet, so that other people, who will have this project, can access this db and use it too. I haven't done it before and even donn't know did I ask this Question correctly. my goal is to upload databse in Internet somewhere, for example I have heard that Microsoft has free hosting. But i donn't know how to do that ? Is there any Tutorial or something else about this ?

推荐答案

您可以使用Azure并在那里托管数据库。然后您的应用程序可以连接到此数据库。当然，这意味着客户端计算机必须能够连接到Internet才能访问此数据库。



这 [ ^ ]页面应该会给你一些帮助。以下是高级信息：



1.在MS Azure上创建您的帐户和数据库。

2.从Azure门户获取连接字符串。

3.在应用程序标准ADO.Net代码中使用此连接字符串。

4.在SQL数据库防火墙中允许客户端IP。这可以使用Azure门户网站完成。



不幸的是，如果客户端计算机具有动态IP，您将需要让他们获取静态IP，这样才可能使用或至少获取客户端IP将出现的范围。

You can make use of Azure and host you database there. Your application can then connect to this database. Of course this means that the client computers must be able to connect to internet to reach this database.

This[^] page should give you some help to begin. Here is high level information:

1. Create your account and database on MS Azure.
2. Get the connection string from Azure portal.
3. Use this connection string in your application standard ADO.Net code.
4. Allow client IPs in your SQL database firewall. This can be done using Azure web portal.

Unfortunately, if the client computers have dynamic IPs, you will either need to ask them to get static IPs so that could be used or at least get the range within which the client IPs will be present.

您好，在您的情况下，您需要在云中或每个人都可以访问它的地方托管您的数据库。有一些选项，

1.您可以设置自己的数据库服务器。

2.在云服务器中托管您的数据库。



按照以下链接设置自己的服务器。

1. 如何为小公司设置数据库服务器？ | Yahoo Answers [ ^ ]

2. 设置主服务器 - Webmonkey [ ^ ]



To在云端托管您的数据库，

有很多云服务提供商可用。

1. Google云 - Google云计算，托管服务& amp; API& mdash; Google云端平台 [ ^ ]

2. Amazon Web服务 - Amazon Web Services（AWS） - 云计算服务 [ ^ ]

3. Microsoft Azure Cloud - 云服务 - 部署Web应用程序和API | Microsoft Azure [ ^ ]

4. Rackspace - Rackspace：Managed Dedicated&云计算服务 [ ^ ]

5. IBM Cloud - IBM Connections and Verse - 开始试用 [ ^ ]

6. HP Cloud - HP Helion Public Cloud - 快速入门指南|云服务 [ ^ ]

这些是少数几家云服务提供商，世界各地都有很多服务提供商。您可以根据需要选择。



只需参考下面的链接就可以帮到你。

1. 如何在多个C＃中使用我的库存系统计算机通过本地网络 [ ^ ]

2. 如何创建windows c＃应用程序以在线和离线工作 [ ^ ]

Hi, In your case, you need to host your database in the cloud or somewhere that everyone can access it. There are some options for this,
1. You can setup your own database server.
2. Host your database in the cloud server.

Follow the links below to setup your own server.
1. How do you set up a database server for a small company? | Yahoo Answers[^]
2. Set Up a Home Server - Webmonkey[^]

To Host your database in the cloud,
There are lot of cloud service providers are available.
1. Google cloud - Google Cloud Computing, Hosting Services & APIs — Google Cloud Platform[^]
2. Amazon Web services - Amazon Web Services (AWS) - Cloud Computing Services[^]
3. Microsoft Azure Cloud - Cloud Services - Deploy web apps and APIs | Microsoft Azure[^]
4. Rackspace - Rackspace: Managed Dedicated & Cloud Computing Services[^]
5. IBM Cloud - IBM Connections and Verse - Start a trial[^]
6. HP Cloud - HP Helion Public Cloud - Quick Start Guide | Cloud Services[^]
These are the few cloud service providers, there are lots of services providers available all over the world. You can choose as per your need.

And just refer the links below will help you.
1. how can I use my inventory system in C# by a multi computer through Local network[^]
2. How to Create windows c# application to work online and offline[^]

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