migration from accesss to SQL serv

Thanks huwnet, but I can't find it.

But I was able to fix it. I will post what I've done, so the people having this error in the future, will have two opportunitys of finding it:

• Use DTS to migrate the tables tblAuthor, tblGroups, tblGuests
• Run the msSQL_server_setup.asp script -it will return some errors, doesn't seem to matter-
• Use DTS to migrate all tables now -except the tables of the first step-

I don't now if it is a clean solution, but all seems to work fine.

Thank you very much for you hel Borg and huwnet

Lazaro wrote: Thanks huwnet, but I can't find it. But I was able to fix it. I will post what I've done, so the people having this error in the future, will have two opportunitys of finding it: Use DTS to migrate the tables tblAuthor, tblGroups, tblGuests Run the msSQL_server_setup.asp script -it will return some errors, doesn't seem to matter- Use DTS to migrate all tables now -except the tables of the first step- I don't now if it is a clean solution, but all seems to work fine. Thank you very much for you hel Borg and huwnet

I did exactly as you described in your steps I had few errors when running ms_sql setup as you told but during step 3 all tables went well except 2 tables and I got the errors below:

did you get the same problem?? and does it effects the forum or do I miss functionality or performance??

thnx for you suggestion

It is true I had some tables not enabled identity insert I did that by all tables but by step 3 it still gave the smae errors by the two tables.

ain step 2 I get these errors:

Error Creating the Table tblAuthor (it may already exsist)

Error Creating the Table tblGroup (it may already exsist)

Error Creating the Table tblGuestName (it may already exsist)

Error Creating the Relationship between the tblAuthor and tblGroup tables (it may already exsist)

Error Creating the Relationship between the tblBuddyList and tblAuthor tables (it may already exsist)

Error Creating the Relationship between the tblEmailNotify and tblAuthor tables (it may already exsist)

Error Creating the Relationship between the tblPMMessage and tblAuthor tables (it may already exsist)

Error Creating the Relationship between the tblThread, tblTopic and tblAuthor tables (it may already exsist)

Error entering default values in the Table tblGroup

Error entering default values in the Table tblAuthor

SQL Server database is set up, but with Error!

I solved two of the errors above:

insert registration: error solved
by editing the table design thru enterprise manager. you have to make the column author_id in table author to integer with auto increment = 1

delete error solved
I just uploaded the file delete_post.asp again and it worked. that is strange though because the old file worked fine with the access version !!!

I still have the error of DB statistics (I uploaded the file again but doesn't work)

new error New user
A new registered user gets problems while try to do these things:
- view the profile
- send pm or read pm that new user send
- post new message
and more problems

all those problems seems occurs because of default values in table author like join_date = now() and it should be getdate() for ms-sql
same thing with column no of posts etc...
I fixed the problem with new registration by editing table desing my self,  is there an better way to convert the table author into ms-sql?? instead of having to edit all columns manually??  are there other tables that will need editing??

thanks in advance