Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.




439 posts

Ultimate Geek


# 136270 21-Nov-2013 10:49
Send private message

Microsoft Visual Studio 2012, hi geekzone and thanks for reading this post.
Im currently studying at Ucol database design and development but im at beginner level at the moment.
I have learnt to make database and tables plus how to enter data into database, however I would like to know if someone could please help me:
I want to import a xml format database base on Endnote program and into the Microsoft Visual Studio database but i cant figured out.



thanks again and have a nice week.

Create new topic
1348 posts

Uber Geek
+1 received by user: 159


  # 938417 21-Nov-2013 11:22
Send private message

Do you mean you want to write a program to do the import or do you just want to open have the database import data from the XML file.

For the second technique, this can be done through SQL Server Management console. However, using Visual Studio is very similar.

In Visual Studio (I am using VS2012 for this example), in your solution open the SQL Server Object Explorer [Ctrl \ Ctrl S] and then connect to your SQL server, select navigate to your database and select your table (you can view the data in the table here).

From the SQL menu at the top of the screen, select transact sql editor, this will open a T-SQL console (it may prompt you to login first). You can then write T-SQL script to do the import. Something like:

DECLARE @someXML XML
SELECT @someXML = .... (I believe OPENROWSET is the command).. You can google this example to find out the exact syntax.




Software Engineer

 




439 posts

Ultimate Geek


  # 938436 21-Nov-2013 12:18
Send private message

For now im just trying to import the data from a database based EndNote xml format to my SQL database. is all the code from the Endnote Database in one file.

Later on when more confident with writing the code i will see if i can attempt to develop a software that can do that for me.




thank you so much for your reply this may be exactly the solution to my problem,

I highly appreciated that you replied to my post,


thanks again




Andrew

 
 
 
 


8033 posts

Uber Geek
+1 received by user: 390

Trusted
Subscriber

  # 938517 21-Nov-2013 16:31
Send private message

Yeah basically you read the file with OPENROWSET then either store it in table variable, temp table or table then process that table to extract the columns and rows.

http://stackoverflow.com/questions/16838627/import-xml-into-sql-server

http://www.mssqltips.com/sqlservertip/2899/importing-and-processing-data-from-xml-files-into-sql-server-tables/

1348 posts

Uber Geek
+1 received by user: 159


  # 938655 21-Nov-2013 20:57
Send private message

GamerOC: For now im just trying to import the data from a database based EndNote xml format to my SQL database. is all the code from the Endnote Database in one file.

Later on when more confident with writing the code i will see if i can attempt to develop a software that can do that for me.




thank you so much for your reply this may be exactly the solution to my problem,

I highly appreciated that you replied to my post,


thanks again




Andrew


No worries, Its good to see that you are taking the time to learn Visual Studio before writing the code.  There is a lot of good productivity to be had by learning to use ones toolset effectively and maximise its value and I come across a lot of developers who only really know how to open and save code files.





Software Engineer

 




439 posts

Ultimate Geek


  # 938714 21-Nov-2013 22:47
Send private message

Ragnor, thank you so much for the very useful links. these links are like gold to me now and just what i was looking by using OPENROWSET.


TwoSeven, thank you so much for giving me the idea to use OPENROWSET and also for your feedback in regards my approach to learning Visual Studio 2012.


I hope one day to be able to make some neat software solutions.


thanks again,



Andrew

Create new topic



Twitter »

Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:





News »

HPE to acquire supercomputing leader Cray
Posted 20-May-2019 11:07


Techweek starting around NZ today
Posted 20-May-2019 09:52


Porirua City Council first to adopt new council software solution Datascape
Posted 15-May-2019 12:00


New survey provides insight into schools' technology challenges and plans
Posted 15-May-2019 09:30


Apple Music now available on Alexa devices in Australia and New Zealand
Posted 15-May-2019 09:11


Make a stand against cyberbullying this Pink Shirt Day
Posted 14-May-2019 20:23


Samsung first TV manufacturer to launch the Apple TV App and Airplay 2
Posted 14-May-2019 20:11


Vodafone New Zealand sold
Posted 14-May-2019 07:25


Kordia boosts cloud performance with locally-hosted Microsoft Azure ExpressRoute
Posted 8-May-2019 10:25


Microsoft Azure ExpressRoute in New Zealand opens up faster, more secure internet for Kiwi businesses
Posted 8-May-2019 09:39


Vocus Communications to deliver Microsoft Azure Cloud Solutions through Azure ExpressRoute
Posted 8-May-2019 09:25


Independent NZ feature film #statusPending to premiere during WLG-X
Posted 6-May-2019 22:13


The ultimate dog photoshoot with Nokia 9 PureView #ForgottenDogsofInstagram
Posted 6-May-2019 09:41


Nokia 9 PureView available in New Zealand
Posted 6-May-2019 09:06


Motorola Solutions joins local partners to deliver advanced communications network in New Zealand
Posted 30-Apr-2019 21:50



Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.


Support Geekzone »

Our community of supporters help make Geekzone possible. Click the button below to join them.

Support Geezone on PressPatron



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.