Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > General .NET
| Search | Today's Posts | Mark Forums Read
General .NET For general discussion of MICROSOFT .NET topics that don't fall within any of the other .NET forum subcategories or .NET language forums.  If your question is specific to a language (C# or Visual Basic) or type of application (Windows Forms or ASP.Net) try an applicable forum category. ** PLEASE BE SPECIFIC WITH YOUR QUESTION ** When posting here, provide details regarding the Microsoft .NET language you are using and/or what type of application (Windows/Web Forms, etc) you are working in, if applicable to the question. This will help others answer the question without having to ask.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the General .NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 4th, 2004, 07:50 AM
Authorized User
 
Join Date: Aug 2004
Location: , , .
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Default Save database schema to XML file

Can anyone tell me if and/or how it is possible to save the schema of a database to an xml file, meaning the structure and not the records themselves.

Any help would be greatly appreciated.

Thanks.

Brett Kelly

 
Old November 4th, 2004, 04:42 PM
Friend of Wrox
 
Join Date: Jul 2004
Location: Tehran, , Iran.
Posts: 623
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hello,
you can simply produce your xml and it's schema,(the schema saves in a XSD file not XML)
Code:
objDataSet.WriteXml("C:\\...\\file.xml");//your XMLFile
objDataSet.WriteXmlSchema("C:\\...\\schema.xsd");//your Schema
if you encounter some errors about access control you should change the permissions and roles of your user where you make your result files.

--------------------------------------------
Mehdi.:)
 
Old September 16th, 2006, 04:27 AM
Registered User
 
Join Date: Sep 2006
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hello,

I am looking for the similar requirement....

I have 2 Hosting servers (say HostSvr1 and HostSvr2), on which i have installed sql servers 2000 and 2005 as follows...

HostSvr1 has Sql Server 2000 installed in which i have database (DB1).

HostSvr2 has Sql Server 2005 installed in which i have no databases.

Note:- both the HostSvrs are in the same domain (say MyDomain.Net)

Now, what i want is, to some how copy DB1 into Sql Server 2005.

is there some solution to do so.....

either by vbscript, javascript, visual basic, or c# code.

If there is some solution or hint/tips please reply to me with that....


Regards
Sharad Sjarma (KAPS)





Similar Threads
Thread Thread Starter Forum Replies Last Post
save word formfields into an xml file manjugv Word VBA 0 May 1st, 2006 04:44 PM
Can't save XMLDoc to a xml file using JScript induriprakash Javascript 2 May 13th, 2005 02:44 PM
How to save XML file using JScript/DOM in IE induriprakash XML 2 April 26th, 2005 07:37 AM
ADO.NET writing XML file by schema using datasets inspirito C# 0 February 1st, 2005 11:35 AM
How to get File type before save to database monika_jain_99 J2EE 0 July 9th, 2003 07:12 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.