如何使数据库在线 [英] how to put database online

问题描述

嗨 我有一个sql数据库.mdf，我想知道是否可以将我的数据库在线.投寄箱或某个地方，然后使用Microsoft sql Management Studio连接到它.
如果有可能怎么办?或我可以阅读/关注的文章.

原因是:我有一个使用winforms(c#)的项目以及一个php网站和一个移动应用程序.并且我必须使用一个数据库来进行添加/修改/删除和选择.

解决方案

是的，可以.但是仅发布MDF文件并访问它可能不是一个绝妙的主意.
尽管可以这样做，但确实会使您容易受到外部访问的侵害-特别是如果您要为任何人提供修改/删除访问权限的话！

我很想写一个WebService，它使用MsSql访问数据库，并在登录并验证自己后通过各种应用程序传递请求.它的工作量更大，但是要安全得多(比损坏后无法修复的数据库恢复要快得多).

我理解您的想法.但就目前而言，我只是希望它在线，以便所有应用程序都可以使用数据库.因为它对于一个项目我不太在意安全性.
这就是为什么我要使用保管箱的原因.但是，感谢您的想法，我肯定会对此进行更多的研究.
如果您可以通过Dropbox的想法帮助我，我将不胜感激.或如何处理.

hi i have a sql database .mdf and i was wondering if i can put my database online eg. dropbox or some place and then connect to it with microsoft sql management studio.
if this is possible how? or an article i can read/follow.

the reason is: i have a project that uses winforms(c#) and a php website and a mobile app. and i must use one database to do add/modify/delete and select.

解决方案

Yes, you can. But it probably isn''t a brilliant idea to just post up the MDF file and access it.
Although you can do that, it does leave you somewhat vulnerable to external accesses - particularly if you are giving modify / delete access to anybody!

I would be tempted to write a WebService instead, which used MsSql to access the database, and which passed requests through from your various apps once they had logged in and verified themselves. It''s more work, but it''s a lot safer (and quicker than restoring the database after is is corrupted beyond repair)

i understand your idea. but for now i just i just want it online so all apps can use database. because its for a project i an not so concerned with the security.
that’s why i will like to use dropbox. but thanks for the idea i am definitely doing more research on that.
if you can help me with the dropbox idea i will appreciate it. or how to go about it.

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