Please excuse me if this has been answered elsewhere.  I've searched through the support forum several times without finding an answer, so I thought I would give this a try...

I am running the 7.9 Access version of the forum, and I'm trying to upgrade/upsize it to the (7.9) SQL version.  I've gone through the Access upsizing wizard, letting it create a new db, then running the sql setup asp.  I've also tried importing the data from SQL Import wizard to pull the data from the Access db.

No matter which way I go, I end up with the same problem:
From the main forum screen, all of the forums are there, the topic and post counts are correct, but all topics show to have been last updated by Forum Administrator.  Once you click on a forum, all of the topics are there, but only the "views" column is populated.  The "replies" count and "Topic Starter" are blank.
If you click on a topic, up at the top it gives the message 
"Topic: There are no posts in the database relating to this topic".

All of the members/passwords are still present and working.  I can delete the forums and re-create them, and then I can post new topics under them that work just fine.  I would just like to retain all of the posts, if possible.

I tried doing the compact/repair function on the db before the migration; it seemed to make no noticeable difference.

Any help would be appreciated very much.

There was an article that I missed:

http://forums.webwiz.net/forum_posts.asp?TID=6395&KW=migration - http://forums.webwiz.net/forum_posts.asp?TID=63 95&KW=migration

The sequence of events that Lazaro took, combined with the the tblAuthor increment modification suggested by Otti seemed to work for me.

In summary, import the Author, Guests, and Groups tables.  Then run the msSQL_server_setup.asp script, ignoring the errors.  Then import the remaining tables.
The only problem that I had was that the DateTimeFormat table did not come across the first time.  I got similar error messages as shown in the screen captures of Otti's post about "Violation of Primary Key Constraint...Cannot insert duplicate key in object..." 
I ran the DTS import again on only the DateTimeFormat table and had the import wizard clear the table, and everything appears to be fine.

You know, I don't usually make a habit of having conversations with myself on forums, but I thought I would post another piece of info I have found since my board has been running with a MSSQL backend.

I know this has been posted in a couple of different places elsewhere in the forum, but it's related to my upgrade process and results, so I figured I would put consolidate it here anyway.

The errors looked something like this (this would happen after a new user would post -- after they posted, the following error would occur at the top of the post list, and the ability to post in the thread was taken away as the posting form at the bottom wasn't visible anymore):

"Microsoft VBScript runtime error '800a005e'

Invalid use of Null: 'CDate'

/Forum/forum_posts.asp, line 669  "

When using the DTS to bring data from Access into SQL, there are a couple of tables whose properties will have to be updated.  I didn't find this out until new members tried to register and post.  Most of my problems were in the tblAuthor table.
In design mode for this table, change the following attributes:

Author_ID: Identity "Yes", Identity Seed "1", Identity Increment "1",
Join_Date and No_Posts, remove the check for 'allow null'
No_Posts needs a default value of "0".
Join_Date needs to have a default value of "(getdate())"
Join_Date, DOB, and Last_Visit had to have data types changed from "smalldate" to "datetime".

All of this might not be necessary, and there are at least 2 other tables that need to have attribs updated, but this seemed to cure the problems I was having with new users.  The way I got the correct default values was to build a blank install of the forum and compare tables side by side in Enterprise manager.

Feel free to correct me if it's needed.
Just hope this helps somebody that was having the same problems with "upgrading" that I did.