RE: Hello!
07-18-2020, 11:31 PM (This post was last modified: 07-18-2020, 11:31 PM by Bob Schroeck.)
07-18-2020, 11:31 PM (This post was last modified: 07-18-2020, 11:31 PM by Bob Schroeck.)
And what breakage occurred was mainly my fault, not Labster's.
And while there may have been a better way to do things, I used cursors because I was stepping through one thread at a time, recreating it in the new database and then moving its posts over one at a time, in order. One reason I did it that way is it let me control exactly what I was moving when and gave me some "undo" ability. (I gave the T-SQL copies of the tables a "moved" bit column that let me track exactly what I'd ported over and what I hadn't -- and I wrote the scripts such that I could say, basically, "move 5 threads from General Chatter".) The messy part was that my T-SQL scripts wrote MySQL scripts that I then copy/pasted over to my ISP's phpMyAdmin control panel, since they didn't permit me to do direct uploads.
Yeah, a lot of the stuff I did, I did because the tools I had wouldn't let me do it in an easier way.
And while there may have been a better way to do things, I used cursors because I was stepping through one thread at a time, recreating it in the new database and then moving its posts over one at a time, in order. One reason I did it that way is it let me control exactly what I was moving when and gave me some "undo" ability. (I gave the T-SQL copies of the tables a "moved" bit column that let me track exactly what I'd ported over and what I hadn't -- and I wrote the scripts such that I could say, basically, "move 5 threads from General Chatter".) The messy part was that my T-SQL scripts wrote MySQL scripts that I then copy/pasted over to my ISP's phpMyAdmin control panel, since they didn't permit me to do direct uploads.
Yeah, a lot of the stuff I did, I did because the tools I had wouldn't let me do it in an easier way.
-- Bob
I have been Roland, Beowulf, Achilles, Gilgamesh, Clark Kent, Mary Sue, DJ Croft, Skysaber. I have been
called a hundred names and will be called a thousand more before the sun grows dim and cold....
I have been Roland, Beowulf, Achilles, Gilgamesh, Clark Kent, Mary Sue, DJ Croft, Skysaber. I have been
called a hundred names and will be called a thousand more before the sun grows dim and cold....