I obey MortiOli's script's documentation, delete that two records, and compact database, all table record's ID counts from 1.
I try to delete the first two records, now even when I login, it shows a blank forum.
So I restore the db.
My environment: w2k server / SQL 7.0 / charset=big5
Here's my migration effort:
Four days ago, I have install a brand new WWF over blank SQL7.0 database and works OK. (during installation select SQL server 2000)
The MortiOli's script works for access db, so I use SQL to export my snitz forum's db to an access .mdb file, and use this .mdb file, install a new WWF over it. And it works well.
Then testing and running for three days, all data transferred to WWF.
So I use SQL server to import the .mdb , make a new SQL db, and install a new WWF over this new SQL db. At first I choose "New installation",but it will make a new db, So I start over again, select "upgrade from WWF 9.x" and then finish the process without error messages.
Sine MortiOli's script runs with access db, my original and final db is SQL, this is the only way I know to transfer the data.
SQL db-->access db-->MortiOli's -->access new db-->SQL db-->WWF install over existing SQL db
I think this procedure should have somthing wrong.......
