Em Andamento

Import Wiktionary XML Dump Into SQL Server 2005 DB

I wanted to know if someone could help me with a script that I can run to load the most recent and freely available complete Wikitionary dump (could be several files) into a SQL Server DB.

Essentially I would like to make a data clone of the Wiktionary dumps. The set of files is updated periodically by Wikimedia and the script needs to be able to work on a schedule (I can set the server to execute a page at an interval, e.g. X days, or you can include a job in a SQL Server DB).

Here are some sample files (there are more up to date files on the [url removed, login to view] site but they have the same format)

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

The first step would be extracting the bz2 file (I do not know how to do that on a Windows machine) and then reading the XML file into a DB.

Deliverables will be a script and a set of instructions that are a recreatable process to import the Wiktionary dumps in a SQL Server 2005 DB.

Write the documentation from the standpoint of a user with Windows XP Professional, MS Access 2003, and SQL Server 2005 installed on their computer and an available Windows server with SQL Server 2005.

Please include links to additional free software that the user must download to decompress the bz2 dump on a Windows machine and the steps involved in that (e.g. open command prompt and enter this command to decompress file [url removed, login to view]).

1) Complete step-by-step instructions on how to download a Wiktionary dump in bz2 format, decompress that file, and import the resulting XML file into a SQL Server 2005 database.

2) Instructions/documentation must be delivered in Word format along with a fully-functional SQL Server 2005 database file containing the content of Wiktionary dump.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables).

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

Habilidades: .NET, Processamento de dados, Visual Basic, XML

Ver mais: wiktionary dump, wiktionary xml, wiktionary xml dump, dump wiktionary, wiktionary sql, wiktionary database dump, wiktionary dumps, wiktionary sql dump, wiktionary dump file, wiktionary database download, sql server 2005 import xml, download wiktionary database, download wiktionary dump, wiktionary dump download, wiktionary web service, import xml sql server 2005, download wiktionary, wiktionary xml sql, download wiktionary dumps, download wiktionary database xml, database dump wiktionary, wikitionary dump, wiktionary sqlbz2, wiktionary database, wiktionary xml dump access database

Acerca do Empregador:
( 0 comentários ) Austin, United States

ID do Projeto: #123621

Premiar a:

vip

Dear Sir/Madam, I have all required knowledge and experience to achieve success of this project with best quality and professionalism. Please see my profile. Please see my detailed offer in PMB. Best Regards. Yu Mais

$100 USD em 5 dias
(33 Avaliações)
6.2

10 freelancers estão ofertando em média $77 para este trabalho

www6STECHcom

Hi, We would like to introduce ourselves as a company of professionals who are driven by the philosophy of customer satisfaction through QUALITY and INNOVATION. We specialize in web-related technologies and Mais

$30 USD in 10 dias
(14 Comentários)
5.5
indradj

Hi, I can make a fully automated data import tool for this! Please see PM for details.

$100 USD in 5 dias
(14 Comentários)
5.0
vickey181

we are from new delhi(india).we have 3-5 years experience of web development with different lanuages and platforms like .NET and PHP [url removed, login to view] good exp.. of XML and SOAP .pls gone through the profile attached and please Mais

$100 USD in 5 dias
(1 Comentário)
2.8
rawatanil

Detail of bid The budget provided for the project is just approx. Finaly it will be decided after knowing the actual requirement of the project. Give us an opportunity, we will provide you the best solution. Mais

$70 USD in 25 dias
(0 Comentários)
0.0
bijender3333

The budget provided for the project is just approx. Finaly it will be decided after knowing the actual requirement of the project. Give us an opportunity, we will provide you the best solution. Our employees come Mais

$70 USD in 20 dias
(0 Comentários)
0.0
vijender123

The budget provided for the project is just approx. Finaly it will be decided after knowing the actual requirement of the project. Give us an opportunity, we will provide you the best solution. Our employees come Mais

$70 USD in 25 dias
(0 Comentários)
0.0
mohsincse

i am a new comer for outsourcing work .i am able to do this kind of work .So ,i want to get chance from you. you will get your work [url removed, login to view] you

$80 USD in 15 dias
(0 Comentários)
0.0
Accurate

I am a sql dba dealing with such uploads on a daily basis.

$60 USD in 3 dias
(0 Comentários)
0.0
gkotpalliwar

Hi there, I actually worked on this similar project for my company recently and its working perfectly, all the zipping and unzipping, dumping xml data into sql server, I can be definately handy for you. Give it a try.

$90 USD in 7 dias
(0 Comentários)
0.0