ripper2020
01-23-2008, 06:30 PM
Hello all, sorry if the title is a little unclear. I will explain situation and any references, information, insight etc. would be greatly appreciated.
I currently maintain an ecommerce site www.affordable-solar.com
We are looking at switching shopping carts to another mysql db. I have a very general understanding of databases and mysql, but I can export, import, and do basic record adding, updating, deleting from the command prompt. My question is how is this type of database restructuring normally done? As I'm sure even similar fields may have different data types, restrictions etc. What is the easiest way to go about doing this. Creating one giant script that loads the data into the new database all at once. Doing it piece by piece? And if you do it piece by piece, how do you decide which tables to start with. Its been a while since i took my introduction to relational databases...but I still remember the concepts and i know there is an order records have to be added.
So any good introductions / references to this kind of process would be greatly appreciated. In the end we are most likely going to hire professional ecommerce / database consultant, but i would still like to have a good idea.
I currently maintain an ecommerce site www.affordable-solar.com
We are looking at switching shopping carts to another mysql db. I have a very general understanding of databases and mysql, but I can export, import, and do basic record adding, updating, deleting from the command prompt. My question is how is this type of database restructuring normally done? As I'm sure even similar fields may have different data types, restrictions etc. What is the easiest way to go about doing this. Creating one giant script that loads the data into the new database all at once. Doing it piece by piece? And if you do it piece by piece, how do you decide which tables to start with. Its been a while since i took my introduction to relational databases...but I still remember the concepts and i know there is an order records have to be added.
So any good introductions / references to this kind of process would be greatly appreciated. In the end we are most likely going to hire professional ecommerce / database consultant, but i would still like to have a good idea.