Encerrado

Database Conversion

Project involves merging multiple MySQL databases of identical structure into one large database housing all the data.

Since there are multiple foreign keys in this database, any conversion script will have to insert tables that have no foreign key dependencies first, and then import tables with dependencies, replacing the old ids for new ids.

Conversion script should be written in PHP using mysql module.

See the attached file (should save as a zip file) for a database layout.

## Deliverables

Attached is a copy of our database specification. From this document, the coder should be able to determine how to combine all the the information into one site.

Note: In the case of your conversion script, all websiteid columns should be kept to 0. Some of these tables we will ask for you to check for and remove duplicate entries. In the case of the contentgroup table, we will ask that with each imported row, you add an additional row to category_contentgroup. We will give you more details in our formal specification.

NOTE: The script should NOT assume that all these tables exist. Some of these tables are plugins that not all of our clients use. If your conversion script cannot find a table, it should gracefully handle that instead of error out.

Habilidades: Engenharia, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software

Ver mais: foreign clients, database copy script, duplicate table, mysql multiple insert, import module script file, foreign key, check table mysql script, mysql combine, mysql copy database, mysql remove table, data merging, mysql remove duplicate, save data table file, project database error, script import mysql file, data table save file, data conversion script, case management mysql, mysql script check table, formal module, data conversion php, import conversion, database clients details, database Table Structure, table specification

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

ID do Projeto: #3006096

8 freelancers estão ofertando em média $430 para este trabalho

trustedcoder

See private message.

$425 USD in 7 dias
(85 Comentários)
6.1
ccoderpirlo

See private message.

$170 USD in 7 dias
(6 Comentários)
4.3
tgkprogavi

See private message.

$212.5 USD in 7 dias
(13 Comentários)
4.1
raparapandulavw

See private message.

$153 USD in 7 dias
(16 Comentários)
3.5
noumanpak

See private message.

$170 USD in 7 dias
(9 Comentários)
3.0
flightern

See private message.

$85 USD in 7 dias
(3 Comentários)
1.6
thecloudkernel

See private message.

$2125 USD in 7 dias
(3 Comentários)
0.9
touseefcdbnet

See private message.

$102 USD in 7 dias
(2 Comentários)
0.0