将Access数据库转换为SQL [英] Convert an Access database to SQL
问题描述
我有一个Access数据库，我正在为
编写一个ASP.NEt应用程序。它几乎完成了。我有一个托管公司，我在一个月之前注册了
a但是在我做任何事情之前我问过他们是否Access和ASP.NET
可以在他们的服务器上工作，他们说是的，所以我买进了。现在他们是
说我的应用程序不能使用MSaccess在他们的服务器上运行我可以
只使用SQL或asp 3.0。他们说微软正试图将Ms
Access作为桌面应用程序保留。数据库完成了，应用程序几乎完成了
。我为这个申请付了很多钱。这里有什么我的
选项？
将Access数据库转换为SQL有多难？在ASP.NET部分有什么后果
？
转换为asp 3.0有多难？
我还被告知XML可行。什么都不知道。
其他主人怎么样？
还有其他选择吗？
我无法相信这一点。
我们将非常感谢任何帮助和见解。
Cory
Hi,
I have an Access database and am having an ASP.NEt application written for
it. It is almost complete. I have a hosting company that I signed up with
a month ago but before I did anything I asked them if Access and ASP.NET
would work on their servers, they said yes so I bought in. Now they are
saying my application wont work on their servers using MSaccess and I can
only use SQL or asp 3.0. They are saying Microsoft is trying to keep Ms
Access as a desktop application. The database is done, and the app is
almost done. I have paid alot of money for this application. What are my
options here?
How hard is it to convert an Access Database to SQL? What ramifications
does this have on the ASP.NET part?
How hard is it to convert to asp 3.0?
I was also told XML would work. DOnt know anything about it.
What about other hosts?
Any other options?
I just cant believe this.
Any help and insight would be greatly appreciated.
Cory
推荐答案
请参阅
comp.databases.ms-access这个主题的最新主题。
周三，2004年1月7日04:56:55 GMT，cory <无*** @ here.com>写道：
Please see the recent thread underway on this subject here at
comp.databases.ms-access.
On Wed, 07 Jan 2004 04:56:55 GMT, "cory" <no***@here.com> wrote:
我有一个Access数据库，我正在为它编写一个ASP.NEt应用程序。它几乎完成了。我有一个托管公司，我在一个月前注册了
但在我做任何事情之前我问他们Access和ASP.NET
是否适用于他们的服务器，他们说是的，所以我买进了。现在他们说我的应用程序不能使用MSaccess在他们的服务器上工作，我只能使用SQL或asp 3.0。他们说微软正试图将Ms /> Access作为桌面应用程序。数据库完成了，应用程序几乎完成了。我为这个申请付了很多钱。这里有什么选择？
将Access数据库转换为SQL有多难？这对ASP.NET部分有什么影响？
转换为asp 3.0有多难？
我也被告知XML可行。什么都不知道。
其他主人怎么样？
还有其他选择吗？
我不能相信这个。
任何非常感谢帮助和见解。
Cory
Hi,
I have an Access database and am having an ASP.NEt application written for
it. It is almost complete. I have a hosting company that I signed up with
a month ago but before I did anything I asked them if Access and ASP.NET
would work on their servers, they said yes so I bought in. Now they are
saying my application wont work on their servers using MSaccess and I can
only use SQL or asp 3.0. They are saying Microsoft is trying to keep Ms
Access as a desktop application. The database is done, and the app is
almost done. I have paid alot of money for this application. What are my
options here?
How hard is it to convert an Access Database to SQL? What ramifications
does this have on the ASP.NET part?
How hard is it to convert to asp 3.0?
I was also told XML would work. DOnt know anything about it.
What about other hosts?
Any other options?
I just cant believe this.
Any help and insight would be greatly appreciated.
Cory
将Access数据结构转换为SQL Server结构可能难以实现，具体取决于表的设计和构建方式。有这样的工具可以使用
工具，但是如果要进入MS SQL Server，我通常会使用数据转换
服务。
从我所听到的，ASP 3.0提供的性能比ASP.net差得多。
不确定两者之间的转换，你可能需要问一下
$一个ASP组中的b $ b ...我只是涉足ASP.NET
XML是一种使用格式化的平台之间传输数据的方法$ / b $ b基于文本的流。您的数据提供者（即您的数据库）会向您发送一份XML文档，并且您的应用程序将把这个XML
文档转换/转换/使用read。提供商发送的数据。
有很多主机支持Access数据库... Google
应该返回一个好的列表。但是，您的ISP服务在他们的视图中并不完全不正确。大多数人发现，除非您的网站经历了非常低的流量，否则您的Access数据库很快就无法完成任务。我的ISP
最近停止支持Access dbs，原因很简单，因为他们有b / b
出现拥堵，性能问题（服务器捆绑了
Jet /访问请求）以及来自其用户丢失/损坏的数据的投诉。
数据库。如果我的网站对我的业务至关重要，而且我无法承担
从我的备份中恢复所花费的时间，那么我当然会考虑
走SQL路线...
-
Scott McDaniel
CS计算机软件
Visual Basic - Access - Sql Server - ASP
" cory" <无*** @ here.com>在消息中写道
news：rkMKb.86812
Converting an Access data structure to a SQL Server structure can be
difficult, depending on how the tables were designed and built. There are
tools available to do this, but I generally use the Data Transformation
Service if going to MS SQL Server.
From what I''ve heard, ASP 3.0 provides much poorer performance than ASP.net.
NOt sure about coverting between the two, you''ll probably need to ask that
in an ASP group ... I''ve merely dabbled in ASP.NET
XML is a method to transfer data between platforms using formatted
text-based streams. Your data provider (i.e. your database) would send you
an XML document, and your application would take/convert/use that XML
document to "read" the data sent by the provider.
There are quite a few hosts that will support Access databases ... Google
should return a good list. However, your ISP service is not entirely
incorrect in their views. Most find that, unless your web site experiences
very low traffic, your Access db will quickly not be up to the task. My ISP
recently stopped supporting Access dbs simply because of the problems they
were having with congestion, performance issues (server tied up with
Jet/Access requests) and complaints from their users of lost/corrupted
databases. If my site were critical to my business, and I couldn''t afford to
lose the time spent in restoring from my backup, then I''d certainly consider
going the SQL route ...
--
Scott McDaniel
CS Computer Software
Visual Basic - Access - Sql Server - ASP
"cory" <no***@here.com> wrote in message
news:rkMKb.86812
6b2.26807@edtnps84 ...
6b2.26807@edtnps84...
我有一个Access数据库，我正在为它编写ASP.NEt应用程序。它几乎完成了。我有一个托管公司，我在一个月前注册了
但在我做任何事情之前我问过他们Access和ASP.NET
是否可以在他们的服务器上工作，他们说是的，所以我买进了。现在他们说我的应用程序不能使用MSaccess在他们的服务器上工作，我只能使用SQL或asp 3.0。他们说微软正试图将Ms /> Access作为桌面应用程序。数据库完成了，应用程序几乎完成了。我为这个申请付了很多钱。这里有什么选择？
将Access数据库转换为SQL有多难？这对ASP.NET部分有什么影响？
转换为asp 3.0有多难？
我也被告知XML可行。什么都不知道。
其他主人怎么样？
还有其他选择吗？
我不能相信这个。
任何非常感谢帮助和见解。
Cory
Hi,
I have an Access database and am having an ASP.NEt application written for
it. It is almost complete. I have a hosting company that I signed up with a month ago but before I did anything I asked them if Access and ASP.NET
would work on their servers, they said yes so I bought in. Now they are
saying my application wont work on their servers using MSaccess and I can
only use SQL or asp 3.0. They are saying Microsoft is trying to keep Ms
Access as a desktop application. The database is done, and the app is
almost done. I have paid alot of money for this application. What are my
options here?
How hard is it to convert an Access Database to SQL? What ramifications
does this have on the ASP.NET part?
How hard is it to convert to asp 3.0?
I was also told XML would work. DOnt know anything about it.
What about other hosts?
Any other options?
I just cant believe this.
Any help and insight would be greatly appreciated.
Cory
这篇关于将Access数据库转换为SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
