This is a 2 part job
I have database which has a table for businesses.
A table for locations, each location having and ID.
In the business table, instead of recording the location name for city, state and country, the location ID is stored.
You need to
1. make a copy of the business table
2. Do a find and replace of the location ids, with the location names
The same database has a table for articles, and a table for images.
The images table, link the images to the article by the article id.
I need you to
i. Make a copy of the article table.
ii. Add a new column "new iamges"
iii. run a script that will bring in the image names, from the image table that corresponds to the correct article id and populate the "new Images" column with the corrrect image name.
Its a BIG database (1 gig) so you will need to download a zip file of the database, work on it locally and reload it.
Hello, sir! We would like to take over your task. We have over five years of experience in managing databases. We promise professionalism and the shortest execution time.
16 freelancers are bidding on average $103 for this job
I have 4 years experience with Web development and database management, I am ready to start righ now so let's get it done right away and I mean RIGHT AWAY !! Looking forward to hear from you soon - GOD Bless You.