Upgrade script from Access to MSSQL

 

I have made a .asp-script that imports all data from WWF-v.8 access tables to MS-SQL WWF-v.8 tables. But I am not able to import the correct ID(used for primary key) for all tables (eg. author_id from the tblAuthor table). MSSQL refuses to let me use the imported value, and insists on priming a new value for these fields. This means that all relations between tables goes out the window.

Anyone knows how to overwrite the Ident column of the MSSQL-tables?

 

 

Heres an exampe of my code:

 

 Do While Not NewsTableInn.EOF
  NewsTableUt.AddNew
  'NewstableUt.Fields("Cat_ID")               = NewstableInn.Fields("Cat_ID")   <----- This line causes error
  NewstableUt.Fields("Cat_Name")                = NewstableInn.Fields("Cat_Name")
  NewstableUt.Fields("Cat_Order")                 = NewstableInn.Fields("Cat_Order")
  NewsTableUt.Update
  NewsTableInn.MoveNext
 Loop

 

 

If I get this to work, I can post the final script here if someone is interrested.

 

regards,

Bjørn Holm

I don't really need any better performance, as this is a one time job only, and this simple script works fine except for the mentioned problem.

Doesn't anyone know how to overwrite the autoincremented value from the IDENT column in a MSSQL table?

 

Thank you.