Database integration URGENT
$30-250 USD
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.
Project ID: #315776
About the project
4 freelancers are bidding on average $156 for this job
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.
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
Hi, I have gone over your RFP,Please Read My PMB for vital information regarding the bid