Find Jobs
Hire Freelancers

Database integration URGENT

$30-250 USD

Cancelled
Posted over 15 years ago

$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 ([login to view URL]) 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 proposals
Remote project
Active 16 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
4 freelancers are bidding on average $156 USD for this job
User Avatar
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
4.9 (78 reviews)
7.6
7.6
User Avatar
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
5.0 (282 reviews)
7.1
7.1
User Avatar
Hi, I have gone over your RFP,Please Read My PMB for vital information regarding the bid
$225 USD in 2 days
4.2 (9 reviews)
4.1
4.1
User Avatar
Please see PM for details.
$100 USD in 2 days
4.9 (4 reviews)
3.8
3.8

About the client

Flag of CANADA
DDO, Canada
5.0
53
Member since Dec 7, 2007

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.