远程访问SQL Server DB [英] Remotely accessing SQL server DB

问题描述

我正在完成我的网站。我花了很多时间设计内容页面，并希望通过MS Access简单地管理数据库（SQL服务器，evt.MySQL）来减少开发时间。

。这个

在我的本地环境中运行良好。这可以扩展到主机

提供商环境吗？除了互动延迟，什么是优点/缺点？感谢您分享一些见解。

解决方案

" helveticus" < ms ****** @ gmail.com在留言中写道

新闻：3d ************************ ********** @ 34g2000h sf.googlegroups.com ...

我正在完成我的网站。我花了很多时间设计内容页面，并希望通过MS Access简单地管理数据库（SQL服务器，evt.MySQL）来减少开发时间。

。这个

在我的本地环境中运行良好。这可以扩展到主机

提供商环境吗？除了互动延迟，什么是优点/缺点？感谢您分享一些见解。

Jet数据库并非真正设计用于网站，尤其是

流量较大的数据库。

-

Mark Rae

ASP.NET MVP
http://www.markrae.net

谢谢。你会建议什么选择？我真的不倾向于

继续添加额外的管理页面，以便通过数据库客户端程序轻松处理

。

"瑞士" < ms ****** @ gmail.com在留言中写道

news：30 ************************ ********** @ t54g2000 hsg.googlegroups.com ...

谢谢。你会建议什么选择？我真的不倾向于

继续添加额外的管理页面，以便通过数据库客户端程序轻松处理

。

我不确定我是否理解这个问题。为什么你不能只使用SSMS？

-

Mark Rae

ASP.NET MVP
http://www.markrae.net

I''m in the process of finalizing my site. I spent quite a bit of time
designing content pages and would like to cut on development time by
simply managing the DB (SQL server, evt. MySQL) via MS Access. This
works well in my local environment. Can this be extended to a host
provider environment as well? Aside from interaction delays, what are
the pros/cons? Thanks for sharing some insights.

解决方案

"helveticus" <ms******@gmail.comwrote in message
news:3d**********************************@34g2000h sf.googlegroups.com...

I''m in the process of finalizing my site. I spent quite a bit of time
designing content pages and would like to cut on development time by
simply managing the DB (SQL server, evt. MySQL) via MS Access. This
works well in my local environment. Can this be extended to a host
provider environment as well? Aside from interaction delays, what are
the pros/cons? Thanks for sharing some insights.

The Jet database is not really designed for use with websites, especially
those with heavy traffic.
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Thanks. What alternative would you suggest? I''m really not inclined to
keep on adding extra admin pages for stuff that can easily be handled
by a DB client program.

"helveticus" <ms******@gmail.comwrote in message
news:30**********************************@t54g2000 hsg.googlegroups.com...

Thanks. What alternative would you suggest? I''m really not inclined to
keep on adding extra admin pages for stuff that can easily be handled
by a DB client program.

I''m not sure I understand the problem. Why can''t you just use SSMS?
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

这篇关于远程访问SQL Server DB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！