first off hi again.
Now i dont know where to start this one script or let alone how to execute it. This is what i would like to learn how to do.
I would like to output the current DB structure then take that and update another db with the same structure without harming the data.
Sounds simple yes?
But there is more. I would like to output in a certain way that when i run the script for another DB that it changes what the field is and the default value.
For example on S1 (server1) i have a field that i changed from TEXT to Varchar (32). So on S2 i need to check to see if the field exist and make sure it has the proper layout. meaning i need to change TEXT to Varchar (32). Also if i add fields to the table i need to check to see if exist. If not then create.
Please help me. I have been racking my brain thinking of how to do this. Or can i even do this?