ASP/ASP.net:基于 Web 的 JET 数据库管理工具?
我需要操作位于 Web 服务器上的 JET 数据库中的一些表:
- 检查现有索引
- 更改表簇/主键
- 查看存在哪些表
- 重命名表
- 添加表
- 删除表
- 浏览数据
- 等
我没有安装 PlaneDisaster 或 在本地计算机上访问(即使我有)。
我已经编写了一个通用的基于网络的查询工具。 我宁愿不必编写整个基于 Web 的数据库维护 GUI。 一定有人已经这样做过,而且可能已经做过很多次了。
I need to manipulate some tables in a JET database housed on a web-server:
- check existing indexes
- change table cluster/primary key
- see what tables exist
- rename tables
- add tables
- drop tables
- browse data
- etc
I don't have the option of installing PlaneDisaster or Access (even if i had it) on the local machine.
I've already written a generic web-based query tool. I'd rather not have to get into writing a whole web-based database maintenance GUI. Someone must have done this already, and probably many times over.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
部分答案可能是 Compare'Em
http://home.gci.net/~ mike-noel/CompareEM-LITE/CompareEMscreens/CompareEM-About.htm Pro 版本允许您创建 SQL 语句来更新 Access 数据库文件。 这将允许您生成一个版本和较新版本之间的差异。
他的网站不是很清楚,但我记得 Pro 版本的价格是 10 美元。
A partial answer might be Compare'Em
http://home.gci.net/~mike-noel/CompareEM-LITE/CompareEMscreens/CompareEM-About.htm The Pro version allows you to create SQL statements to update the Access database file. This will allow you to generate the differences between one version and a newer version.
His website isn't very clear but as I recall the price for the Pro version was $10.
正如你所说,你已经完成了一个通用的基于网络的查询工具。 JET 的问题在于,您无法像连接一台 SQL 服务器那样将其作为数据库服务器进行连接,以处理对表的更改和其他维护过程。 Jet 不是客户端/服务器 RDBMS。 您需要在服务器中有一个应用程序来为您执行此操作,就像您已经使用基于网络的通用工具所做的那样,或者将数据库下载到您的计算机上。 这就是为什么您已经完成了一些过程并将它们作为 asp 页面放置在服务器中。
无论如何,如果你不想使用 Planedisaster,你可以使用 JetSQLConsole或 Access,但请记住,您始终需要服务器上的应用程序来为您完成工作。
您还可以使用“在您的计算机中”的访问权限并连接到位于 URL 中的数据库 (http://myserver/mydatabase.mdb),但请记住,当您执行此操作时,您正在下载所有数据库,而当您保存它时,您将再次上传它。
As you say you have already done a generic web based query tool. The problem with JET is that you cannot connect with it as database server like you can do with one SQL server in order to process changes to tables and other maintenance procedures. Jet is is not a client/server RDBMS. You need to have an application in the server to do that for you as you already have done with your generic web based tool, or download the database to your machine. That's why you have done some procedures and locate them in the server as asp pages.
Anyway you can use JetSQLConsole, if you don't want to use Planedisaster or Access, but remember that you need always an application on the server to to the job for you
You can also use access "in your machine" and connect to a database located in a URL (http://myserver/mydatabase.mdb) but remember when you are doing this you are downloading all the database and when you save it you are uploading it again.