473,325 Members | 2,785 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

Importing XML in SQL Server 2005 in .Net 2.0

Neo
Hello All,

I tried using bulkupload SQLXML, but it is very unreliable. Is there
any way we can import XML file having schema into database?

Neo

May 10 '06 #1
5 5271
Hello Neo,

N> I tried using bulkupload SQLXML, but it is very unreliable. Is there
N> any way we can import XML file having schema into database?

What exactly are you trying to do? e.g., load XML into an XML typed column
or load XML into one or more tables? Do you already have a schema?
Note: Adding to m.p.ss.xml for easier tracking.

Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/
May 10 '06 #2
Neo
Yes, I have schema. I have also created database structure from XML
Schema. XML Schema is in such a way that it is not having annotation
suitlable for SQLXML.

You mentioned about loading XML into tables, but how do I update table
into database (I assume you mean Table datastruction in ADO.net)?

Thanks
Neo

May 10 '06 #3
Hello Neo,

Okay, so let me ask this: are you simply interested in loading the XML into
the database in some batch operation or do you both load the orginal data
into SQL Server and modify stored values from XML?

If it this is a simple ETL (former) case, SSIS would be my tool of choice.
If you're looking to both load and update from XML, SSIS is still usable,
but the solution might look a little different.

If you simply putting the XML into a XML-typed column, consider using openrowset(bulk)
instead.

More details helpful. :)

Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/
May 10 '06 #4
Neo
Hello Kent,

I realized, I am having SQL Server 2000 for this problem, and not 2005
(To many projects I guess). So, SSIS won't be possible. Same goes for
XML typed column.

Is there option for bulk upload in SQL Server 2000.

Kent Tegels wrote:
Hello Neo,

Okay, so let me ask this: are you simply interested in loading the XML into
the database in some batch operation or do you both load the orginal data
into SQL Server and modify stored values from XML?

If it this is a simple ETL (former) case, SSIS would be my tool of choice.
If you're looking to both load and update from XML, SSIS is still usable,
but the solution might look a little different.

If you simply putting the XML into a XML-typed column, consider using openrowset(bulk)
instead.

More details helpful. :)

Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/


May 10 '06 #5
Hello Neo,

N> I realized, I am having SQL Server 2000 for this problem, and not
N> 2005 (To many projects I guess). So, SSIS won't be possible. Same
N> goes for XML typed column.

BCP or SQLXMLBulkLoad then. Not an easy problem to solve with those tools.

If you can use the .NET 2.0 framework, you might want to look into the SqlBulkCopy
class. That might help.

Thanks!
Kent
May 10 '06 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

29
by: Natan | last post by:
When you create and aspx page, this is generated by default: using System; using System.Collections; using System.Collections.Specialized; using System.Configuration; using System.Text; using...
11
by: panic attack | last post by:
Hello everbody, Our system is using Sql Server 2000 on Windows XP / Windows 2000 We have a text file needs to be imported into Sql Server 2000 as a table. But we are facing a problem which is,...
4
by: Goofy | last post by:
The add database ( MDF ) in Visual Studio 2005 seems to be in SQL Server 2005 format as far as I can tell. Does anyone know how I can import tables ( without having to start writing queries ) from...
0
by: mukil | last post by:
Importing DbaseIII data to sql 2005 using asp Coding platform windows server 2003 awaitinf for reply regards, mukil
3
by: Steve | last post by:
Hi; We just migrated to SqlServer 2005. When I import tables from from SqlServer database into another the identity fields get switched off from being identities. How can I prevent that...
1
by: pompair | last post by:
Hi, Could someone give a pointer how to import couple of hundred images into Sql Server 2005 Express Edition database? Is there a tool for it? Can it be done with Sql Management Studio or is...
4
by: Chloe C | last post by:
Hi I've got an Ingres database of some 200 tables which I need to import every night into SQL Server 2005 for use by Reporting Services. Most of the tables will come across unchanged (a few need...
3
by: scoots987 | last post by:
What do others do if you need to import excel files into SQL Server? My main problems are 1) zipcode formatting issues. If the column is a mix of zip and zip+4, I have problems retrieving all...
4
by: alvinstraight38 | last post by:
Hey guys, I am trying to import data from an Excel spreadsheet into my SQL database. I am running SQL 2005. I following Microsoft's instructions for creating a linked server, and it appeared...
0
by: TG | last post by:
hi! I am trying to import a text file into a table created on the fly in SQL Server 2005 since the number of columns can vary depending on what the user has checked or not. Here is the code I...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.