need to update information in our exisiting data base from information available on the web.
exisiting database appox. 9110
outside databases; 6-7,000 about 1/3 of these will be new listings most will be comparing our contact information with that on the internet.
The database is a MS SQL Server Ver. 9.00.2047.00, Product Level: SP1, Edition: Standard Edition. The database has 94 tables total.
We need to update our: contact_tbl table (and any related table, if necessary) by:
1)Cleaning up duplicate entries from the contact_tbl table.
2)Comparing existing contact entries with another third party database vendor that will provide additional contacts to the contact_tbl table then:
a. Make sure the contacts being imported from this other DB don’t make duplicate entries.
b. If a contact already exists inside the contact_tbl table (or related tables, if necessary), then update their information with the vendor database.
The number of contacts being imported from the verdor DB is less than 10K
The source we are going to use for the import are these two websites:
Both have over 6000 gallery listings
One of the websites has been changed:
Instead of Artinfor.com it will be artinfo.com
To access the information we need follow these steps.
1) go to: http://www.artnet.com/net/galleries/gallery_home.aspx
2) Click on the "ALL" links for "Fine Art Galleries", "Design Galleries", "Decorative Art & Antiques Galleries"
We need all those galleries listings in our database.
1) Go to: http://www.artinfo.com/galleryguide/
2) Click on each of the areas on the world map: "North America", "Europe", "Middle East", "Asia", "Australia", "Africa" and "South America".
We need all the galleries there too.
We will let know more details on how to access our database so you can perform the import (with no duplicates and any existing entry should be updated with the info on these two websites)
31 freelancers are bidding on average $95 for this job
Dear Sir, I am a 11 yrs experience Data Manager having vast experience in multiple databases (MS SQL,Access & Oracle), Pls get the opportunity to work for you.
I will need the database schema Tables Datatypes Constraints (DDL) will be OK I will do it using JDBC-ODBC for you. Writing check conditions as mentioned ...
Hi I am new to this forum. I have experience in MS SQL. From the first instance what i feel is this work can be completed within 5 days even if it has dependencies on multiple tables.