Đã hoàn thành

Normalize two databases

I have two fairly large databases. The first one has three tables. The second one has about 15 tables. They need to be imported to MySQL. That is the first task.

The second task is to create a set of actions or scripts that will allow me to -fairly automatically- upload new versions of the DB's or updated files with new records (structure of these 2 databases will always be the same)

DB1 is a people database. It has 3 main tables which are births, marriages and deaths.

So a query will give you a persons name, last_name1, last_name2, ID number (primary key), date of birth, place of birth, marital status, date of death if applicable.

This one will not be replaced with a new database, but rather will be updaded weekly with update files. We need a script for those updates (that will tell us who was born, who turned 18, who got married, divorced, remarried, etc and of course, who died)

DB2 is an assets Data Base. This one is more complex.

This one has:

1. Persons

2. Corporations

3. Real Estate

4. Vehicles

5. Liens

and several other tables. I am not interested in ALL the tables, but rather in some of them. While in the process of normalizing this DB we will deprecate some tables.

This one does not get updated. It gets replaced with new versions of the DB (same tables, same fields, same structure, new data) about once per month to once every three months.

Both have records already in them, and extensive documentation. Both have a few million records each.

We can discuss more details live.

Kĩ năng: MySQL, Kiến trúc phần mềm

Xem nhiều hơn: real estate bulk upload software data feed upload, real estate data extraction, php mysql real estate data, bot gather data real estate, data encoder job home base, online real estate listing data entry, install data fill pages real estate website, scraping real estate data, real estate sample data

Về Bên Thuê:
( 79 nhận xét ) San Jos, Costa Rica

ID dự án: #8232739

Được trao cho:

altafunic

My skill is Database Management and Development, MYSql, SQL Server, Oracle, PHP, HTML,CSS, Web Development and other programming language. I'm very interested in your job post involving these skills. I am available Thêm

$50 USD trong 10 ngày
(0 Đánh Giá)
0.0

23 freelancer đang chào giá trung bình $568 cho công việc này

coolguyinus2004

You said you want to import these database into MYSQL then what format you have it as of now? DB1 needs updation. DB2 needs replacement of datas. I can do it with PHP/MYSQL coding on a domain with cpanel backend. If Thêm

$833 USD trong 10 ngày
(197 Nhận xét)
7.2
seekdeveloper

Hi, I have read your post and understood your requirement. I have great experience in handling /PHP/MySQL/HTML5/jQuery/Wordpress/Magento/Joomla/Drupal/AngularJS/node.js/CSS3/Java/Python/Django/Javascript/iOS/Andr Thêm

$1030 USD trong 10 ngày
(36 Nhận xét)
7.6
vishalavi29

Hi, We have read the details and we will normalise the DB as per the requirements. We have a development team of 7 years of experience and we are experts. Looking forward Albert B

$773 USD trong 10 ngày
(22 Nhận xét)
6.7
alyaspk

Dear Employer, I am ready to work on your required task and can assure 100% satisfaction. You can read reviews/details about my past work on my profile http://www.freelancer.com/u/alyaspk.html Looking forward to Thêm

$526 USD trong 10 ngày
(37 Nhận xét)
6.3
scriptphp87

Hello, I'm a professional programmer for web programming with php language to build the system website, Besides, I'm also expert in MySQL , HTML,HTML5,CSS, JS I'm always top in Vietnam freelancer [login to view URL] Thêm

$526 USD trong 10 ngày
(87 Nhận xét)
7.1
lavizsolutions

Hi, it seems to be challenging task, I am having a good exp in database , have worked on big database, need to see the table live so that do normalization. Please check and provide me some more details. 1. [login to view URL] Thêm

$1000 USD trong 20 ngày
(9 Nhận xét)
5.7
snpe

Hi, I have 20+ years' databases experience. I would solve your issue using Linux script (if you are on Linux) and/or Java. See my github profile: [login to view URL] BTW What databases contains original Thêm

$750 USD trong 10 ngày
(15 Nhận xét)
5.3
smartwinz

HI Greetings!! I am very interested in your job! because right now I am looking for long term full time job with good buyer, which will be trust me. If you are looking for an Energetic Web [login to view URL] , I am Thêm

$555 USD trong 7 ngày
(13 Nhận xét)
5.1
webiglobe

Dear Sir, I am really interested to work on this project . I have very good experience of doing this sort of job, I can start the work now and can assure the best service from my end. I am waiting here to discuss Thêm

$670 USD trong 15 ngày
(20 Nhận xét)
4.7
luminous15

Hello There I think I can help you out in order to achieve the requirements. However the title says "Normalize db" but I found only scripts to be written to add data or update data. Would like to discuss the require Thêm

$488 USD trong 30 ngày
(17 Nhận xét)
4.7
binarycodersvw

Hi.I am a Visual Basic .NET programmer with 10 years experience(I know you hear things like these a lot but I can show proof). This is an automated robot placed bid but I have read the description of your project and I Thêm

$740 USD trong 10 ngày
(17 Nhận xét)
4.4
graphicain

We are a team of website development. We are expert in MYSQL PHP MY ADMIN as well as all type of open source development. Please see some of our previous works below. [login to view URL] [login to view URL] Thêm

$684 USD trong 7 ngày
(12 Nhận xét)
4.5
JiHC

A proposal has not yet been provided

$626 USD trong 10 ngày
(3 Nhận xét)
3.7
Baraiya

Hello I am .Net Software Developer working on Web & Desktop applications (C# expert developer) Languages , i can on : C#.Net, VB.Net, Android, Java, C, C++, PHP, Java script, JQuery, Ajax, HTML etc... Database Thêm

$723 USD trong 10 ngày
(5 Nhận xét)
3.1
rajeevc2k2

I have already done one complex project here for migration from CRATE to MySql database successfully and accurately. Accuracy is key when we deal with data. I am confident to handle this project with efficiency. Moreov Thêm

$450 USD trong 10 ngày
(2 Nhận xét)
3.2
amitt800

Greeting! I will do it. I am having 7+ years experience in Core PHP with OOP/Procedures, CakePHP, CodeIgniter, MySql, MSSQL, MSAccess, CSV, Excel, XML, JS, AJAX, jQuery, JSON, XSLT, HTML, HTML5, Websites speedup task, Thêm

$250 USD trong 10 ngày
(5 Nhận xét)
2.7
TheGDs

Hi, I am a consultant with a govt organization data center. I am highly expert in SQL, MySQL, MS SQL and Oracle databases. The organization has billion records in the MS SQL database, and I supervise then write s Thêm

$500 USD trong 7 ngày
(1 Nhận xét)
2.0
florinbacu

Propunerea nu a fost încă furnizată

$388 USD trong 6 ngày
(2 Nhận xét)
1.9
SoftEngineer

A proposal has not yet been provided

$526 USD trong 10 ngày
(1 Nhận xét)
1.3
vinaysinghh

i am oracle dba and having more then 5 yrs of experience in oracle . I can do this task easily. i have good expericen in scripting also

$333 USD trong 10 ngày
(1 Nhận xét)
0.8