Project:
We would like to do a MySQL database import from two different sites.
The two databases are both php MySql. However, they do not have the same database structures. Therefore, most likely, it is going to be a manual import.
The web have categories, members, leads (buy/sell) etc…that need to be imported to the new dB.
We have looked and compared the two databases our selves and found the following notes about the import:
1- The two databases table names and columns are different.
2- Due to the complexity of the two dB structure, some data might not have priority to be transferred (we will discus this at that time).
3- We will help you throughout the import with any thing we can to speed up the process.
4- Some data in the old database resides in one table that needs to be extracted and reinserted to the new database in multiple tables or column.
HERE ARE THE TWO WE KNOW ABOUT:
A- The BUY and SELL leads are residing in one column in the old database. The BUY need to be extracted and inserted into its own table in the new dB. The same with the SELL leads, they need to be inserted in their own table in the new dB.
B- The images column from the old dB has to be extracted from a table and reinserted in its own table in the new dB.
5- We would like you to take a careful look at the two databases and give us a time table for the import.
6- It is important to make a thorough check on the web site front end and admin section after the import.
You have bided on this before for $300, Do you want to take this job.
Nasser