从SQL Server 2k迁移到XML [英] Migration from SQL Server 2k to XML
问题描述
我已经在asp.net（vb）中使用sql server 2k编写了一个内联网应用程序，用于支付大量的b $ b客户。现在我需要一些小客户的东西而不需要
数据库，所以我在想xml。我有一个数据库表我想将
转换为xml文件。
为了方便起见我想你的意见如何解决我的问题。
我是否需要使用一些xml的东西升级sql serv2k？或者只是在.net中编写一些代码来实现它？如果是这样，可能是一个示例代码片段
某处。
/ Kenneth
"？？？？= UTF-8乙S2VubmV0aA == = QUOT; <柯***** @ discussions.microsoft.com>写在
新闻：29 ********************************** @ microsof t .com：
我已经在asp.net（vb）中使用sql server 2k为大客户编写了一个Intranet应用程序。现在我需要一些小客户的东西，而不需要数据库，所以我在想xml。我有一个数据库表我想转换为xml文件。
为什么不看MSDE或SQL Server 2005快递？他们是小型客户的桌面数据库引擎......如果您可以使用任何数据库
服务器，您可能不需要重新编写应用程序。
否则，Microsoft Access怎么样？
-
Lucas Tam（RE********@rogers.com ）
请删除删除来自回复时的电子邮件地址。
http：//成员。 ebay.com/aboutme/coolspot18/
嗯....
我应该说过我不想要任何数据库给我的其他
客户，因为他们正在寻找一些简单的解决方案和数据库
解决方案对他们来说并不简单，因为在过去的15次流泪中，我有一些客户作为客户
我知道他们甚至不能使用资源管理器来复制
和粘贴文件。它必须很简单才能使它工作。
部署应用程序只需0.5 MB，然后有25％MB可再分发
框架他们不会理解，然后是mdac等等。对他们来说不是一个简单的解决方案。
XML将是一个简单的解决方案。
/ Kenneth
" Lucas Tam"写道：
" =？Utf-8？B？S2VubmV0aA ==？=" <柯***** @ discussions.microsoft.com>在
新闻中写道：29 ********************************** @ microsof t.com：
我已经在asp.net（vb）中使用sql server 2k为大客户编写了一个Intranet应用程序。现在我需要一些小客户的东西，而不需要数据库，所以我在想xml。我有一个数据库表我想转换为xml文件。
为什么不看MSDE或SQL Server 2005 Express？它们是面向小客户的桌面数据库引擎......如果您可以使用任何数据库服务器，则可能不需要重新编写应用程序。
否则，如何关于Microsoft Access？
-
Lucas Tam（RE********@rogers.com）
请删除删除来自回复时的电子邮件地址。
http：//成员。 ebay.com/aboutme/coolspot18/
非常简单的方法是将表格放入ADO.Net数据集中。一旦您的
数据存在，您可以使用
dsMyDataSet.WriteXML（MyFileName.xml）将其序列化为XML。这将创建一个准备用作数据源的XML文件。
。只需使用
dsMyDataSet.ReadXML（" MyFileName.xml"）加载它。
希望这会有所帮助！
Kenneth写道：
嗯....
我应该说我根本不想要任何数据库给我的其他人
客户，因为他们正在寻找一些简单的解决方案和数据库解决方案对他们来说并不简单，因为我已经把他们中的一些作为客户过去的15个眼泪，我知道他们可以'''甚至使用资源管理器来复制
和粘贴文件。它必须很简单才能使它工作。
部署应用程序只需0.5 MB，然后有25 MB的Redistributable
Framework，他们将无法理解，然后是mdac等等。对他们来说不是一个简单的解决方案。
XML将是一个简单的解决方案。
/ Kenneth
Lucas Tam写道：
" =？Utf-8？B？S2VubmV0aA ==？=" <柯***** @ discussions.microsoft.com>在
新闻中写道：29 ********************************** @ microsof t.com：
我已经在asp.net（vb）中使用sql server 2k为大客户编写了一个Intranet应用程序。现在我需要一些小客户的东西，而不需要数据库，所以我在想xml。我有一个数据库表我想转换为xml文件。
为什么不看MSDE或SQL Server 2005 Express？它们是面向小客户的桌面数据库引擎......如果您可以使用任何数据库服务器，则可能不需要重新编写应用程序。
否则，如何关于Microsoft Access？
-
Lucas Tam（RE********@rogers.com）
请删除删除来自回复时的电子邮件地址。
http：//成员。 ebay.com/aboutme/coolspot18/
Hi,
I''ve written an Intranet app in asp.net (vb) using sql server 2k for big
customers. Now I need something for small customers with no need for
databases, so I''m thinking of xml. I have one database table I''d like to have
converted to a xml file.
To make things easy I''d like your opinion on how to solve my problem.
Do I have to upgrade sql serv2k with some xml stuff? Or is it just to write
some code in .net to achieve it? And if so, maybe an example code snippet
somewhere.
/Kenneth
"=?Utf-8?B?S2VubmV0aA==?=" <Ke*****@discussions.microsoft.com> wrote in
news:29**********************************@microsof t.com:
I''ve written an Intranet app in asp.net (vb) using sql server 2k for
big customers. Now I need something for small customers with no need
for databases, so I''m thinking of xml. I have one database table I''d
like to have converted to a xml file.
Why don''t you look at MSDE or SQL Server 2005 Express? They''re desktop
database engines for small customers... if you can use either database
servers you might not need to re-write your application.
Otherwise, how about Microsoft Access?
--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/
Hmmm....
I should maybe had said that I don''t want any database at all to my other
customers, because they are looking for some simple solutions and database
solutions aren''t simple for them because I have had some of them as customers
for the past 15 tears and I know that they can''t even use Explorer to copy
and paste files. It has to be simple for them to get it working.
To deploy an app will take only 0.5 MB, then there is Redistributable
Framework on 25 MB which they will not understand, then mdac and so on. Not a
simple solution for them.
XML would be a simple solution.
/Kenneth
"Lucas Tam" wrote:
"=?Utf-8?B?S2VubmV0aA==?=" <Ke*****@discussions.microsoft.com> wrote in
news:29**********************************@microsof t.com:I''ve written an Intranet app in asp.net (vb) using sql server 2k for
big customers. Now I need something for small customers with no need
for databases, so I''m thinking of xml. I have one database table I''d
like to have converted to a xml file.
Why don''t you look at MSDE or SQL Server 2005 Express? They''re desktop
database engines for small customers... if you can use either database
servers you might not need to re-write your application.
Otherwise, how about Microsoft Access?
--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/
On really easy way would be get the tables into a ADO.Net dataset. Once your
data is there, you can serialize it to XML using
dsMyDataSet.WriteXML("MyFileName.xml"). This will create an XML file that''s
ready to be used as a datasource. Just load it using
dsMyDataSet.ReadXML("MyFileName.xml").
Hope this helps!
"Kenneth" wrote:
Hmmm....
I should maybe had said that I don''t want any database at all to my other
customers, because they are looking for some simple solutions and database
solutions aren''t simple for them because I have had some of them as customers
for the past 15 tears and I know that they can''t even use Explorer to copy
and paste files. It has to be simple for them to get it working.
To deploy an app will take only 0.5 MB, then there is Redistributable
Framework on 25 MB which they will not understand, then mdac and so on. Not a
simple solution for them.
XML would be a simple solution.
/Kenneth
"Lucas Tam" wrote:"=?Utf-8?B?S2VubmV0aA==?=" <Ke*****@discussions.microsoft.com> wrote in
news:29**********************************@microsof t.com:I''ve written an Intranet app in asp.net (vb) using sql server 2k for
big customers. Now I need something for small customers with no need
for databases, so I''m thinking of xml. I have one database table I''d
like to have converted to a xml file.
Why don''t you look at MSDE or SQL Server 2005 Express? They''re desktop
database engines for small customers... if you can use either database
servers you might not need to re-write your application.
Otherwise, how about Microsoft Access?
--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/
这篇关于从SQL Server 2k迁移到XML的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
