We have a web content management database with over 10-15 tables that need to have their primary keys changed, according to a new numbering scheme. Some tables have relationship primary/foreign key relation, and all need to change accordingly. There's not more than 1k records, and some have between 5-50 records.
This database is used to store the content of a website, but we also need to create the database for a similar website. This means you need to understand the meaning and relationship of the tables, and insert new data based on the content of the other website.
We prefer if you have skype so that we can share screen and discuss the database. We would provide you with SQL schema and data. In the end you may be expected to provide the SQL insert statements so we can test it out. Final bid will be discussed after evaluating data experience and time needed to complete task.
16 freelance ont fait une offre moyenne de 84 $ pour ce travail
I have done research MySQL Database, and understand Primary Key, Foreign Key, Stored, Trigger. My skype nick: hieukaka8, please chat with me 2 hours later.