Database integration URGENT

Cancelled Posted Sep 16, 2008 Paid on delivery
Cancelled Paid on delivery

Ok guys I built a website but am having issues integrating the database.. I need someone to come up with a way to create a script to do a DB move. Please view below what the tech said... Only bid on this if you are capable to do this and in less then 2 days.

Technician Quote:

You wouldn't have to do that manually,

your coder would take that pattern and split out all the data using a

regular expression and create new INSERT sql statements that are

compatible with the phpBB3 users' database table structure.

The reason I gave you just a sample is because once your coder creates

a script to auto-translate all the data into phpBB3-compatible user

data, we will need to run the script he writes on the most recent

database when I am ready to migrate the site and deploy it. At that

time, I will lock down my current site ([url removed, login to view]) so that new

users cannot register. Then I will run the script on the locked-down

database, transfer the new site files to the root public_html folder,

and re-open the site (thus I lose no users). That's why your coder

just needs a sample to produce a script that properly moves over a

single user account. If it can properly move over one, then he can

just write a script to repeatedly move over any N number of accounts

which I will then run on the full database once I lock down the site.

Make sense?

But nevertheless, attached is a file containing the SQL data for the

nuke_stories table (all our news) and the nuke_users (all our users).

That's all that your coder needs to migrate over. Note that all images

in the news articles will be broken until we migrate the site, so

that's not a big deal. As long as the articles are displaying properly

otherwise.

But again, all this data is already outdated during the time I've

written this e-mail, so make sure he isn't writing a manual script.

Make sure he's writing something that can easily be ran on an update

SQL dump when we are ready to do the real migration.

PHP

Project ID: #315776

About the project

4 proposals Remote project Active Nov 9, 2008

4 freelancers are bidding on average $156 for this job

rockerstech

I HAVE MORE THEN 5 YEARS EXPERIENCE..I PROFESSIONAL DATABASE ADMINISTRATOR ....CHECK MY CV AND PROJECT....I WILL CHARGE LESS IF WORK IS SMALL BUT I NEED TO SEEE.

$180 USD in 2 days
(78 Reviews)
7.6
dboyzhang

Migrate user/news data from your old site to phpbb3? Please send me the sample your tech attached then I can check. Looking forward to your response. Bo

$120 USD in 2 days
(282 Reviews)
7.1
cyberdocuments

Hi, I have gone over your RFP,Please Read My PMB for vital information regarding the bid

$225 USD in 2 days
(9 Reviews)
4.1
Blackgato

Please see PM for details.

$100 USD in 2 days
(4 Reviews)
3.8