Can I insert values into identity and timestamp columns

• tojamismis

  Valued Member

  Points: 51

  More actions

  July 28, 2004 at 12:03 pm

  #180978

  Hey all...

  I am in the process of porting an Oracle 8i database to SQL Server 2000. 

  I have a series of fields that are the data the record is inserted or a surrogate key.  In Oracle we had to use sequences and before triggers, but I want to use SQL server's Identity and timestamp columns to simplify this.

  My concern is that when I load the data from the Oracle server that I will get errors if I try to insert the existing surrogate keys and date fields into my identity and timestamp fields on the new SQL Server.  Is my strategy do-able?

  Thanks!

• tojamismis

  Valued Member

  Points: 51

  More actions

  July 28, 2004 at 12:53 pm

  #516652

  Hey... I answered my own question.  Thanks!