将基于窗口的应用程序中的数据导入到Web服务器 [英] Importind data from window based application to the web server

问题描述

大家好，
我制作了一个基于窗口的应用程序，该应用程序具有很多控件和计算功能，并且运行良好.我使用MS Access数据库作为后端，但问题是我想将所有数据从系统存储到基于Web的网站上sql服务器.
谁能帮我解决这个问题.是否可以将数据从窗口导入到基于Web的服务器....

请帮助....

Hello All,
I have made a window based application that have lot of controls and calculation and it is working fine.I am using MS Access Database as a back-end.But the problem is that I want to store all the data from system to the web based sql server.
May anybody help me to sort this problem.Is it possible to import data from window to web based server.......

please help....

推荐答案

问题尚不清楚；您也没有指定要选择的目标数据库.如果这是Microsoft SQL Server，则更容易.解决方案之一是:

http://support.microsoft.com/kb/237980 [ http://msdn.microsoft.com/en-us/library/ms140052.aspx [ ^ ].

如果您还需要其他功能，请使用Google进行数据库转换.

从理论上讲，这不是一个大问题.借助.NET，您可以使用ADO.NET.从一个数据库读取数据并填充另一个数据库.在一般情况下，这很难做到，因为要进行全自动处理，您需要具有数据库架构，并且检索架构的方法也不是通用的.但是，对于Access，这不是问题.请参阅:
http://social.msdn.microsoft.com/Forums/ar/vbgeneral/thread/5ccc3aac-3525-4241-902a-3d03a9169ae0 [ http://msdn.microsoft.com/en-us/library/kcax58fh.aspx [ ^ ].

另外，如果您的源数据库足够简单，则可以使用对架构的了解来对转换 ad-hoc 进行编程.好处是可以在转换过程中改进架构，例如规范化数据库.

—SA

The question is not clear; you also did not specify what target database you would choose. If this is Microsoft SQL server, this is easier. One of the solutions is this:

http://support.microsoft.com/kb/237980[^],
http://msdn.microsoft.com/en-us/library/ms140052.aspx[^].

If you need something else, Google for database conversion.

Theoretically speaking, this is not a big problem. With .NET, you can use ADO.NET; read data from one database and populate another one. This is pretty hard to do in the general case, because for fully automatic processing you need to have the the database schema, and the methods of retrieving of the schema are not universal. However, for Access this is not a problem. Please see:
http://social.msdn.microsoft.com/Forums/ar/vbgeneral/thread/5ccc3aac-3525-4241-902a-3d03a9169ae0[^],
http://msdn.microsoft.com/en-us/library/kcax58fh.aspx[^].

Also, if your source database is simple enough, you can program the conversion ad-hoc, using your knowledge of the schema. The benefit is the possibility to improve the schema during conversion, for example, normalize the database.

—SA

Hai shivammpi123，
通过Web服务访问Windows网站的Windows应用程序的数据很容易.但是我不了解MS ACCESS数据库.
如果Windows应用程序的Db是MS SQL SERVER，则通过简单的Web服务很容易从另一个应用程序访问数据库.
希望对您有帮助.
快乐编程:-)

Hai shivammpi123,
It''s easy to access data of a Windows Application for a WebSite through webservice.But I don''t know about MS ACCESS Database.
If the Windows App''s Db is an MS SQL SERVER it is very easy to access the Database from another Application by a Simple WebService.
Hope This Helps you.
Happy Programming:-)

这篇关于将基于窗口的应用程序中的数据导入到Web服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！