2

I am using SSMA for migration from Oracle to SQL Server 2012. I want to migrate primary keys from Oracle as identity and primary key on SQL Server 2012. SSMA wants me to map every single primary key on source db with corresponding sequence but I have over 200 tables so is there a shortcut for this operation? I don't care about sequence values. Is there a way to say SSMA "Generate new sequence for every primary key and map them to identity(1,1)" ?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
bahadir
  • 709
  • 1
  • 11
  • 28

1 Answers1

0

It looks like that newer versions of SSMA are not using SQL Server identity columns by default. But looking into the migration guide from Oracle to SQL Server 2012 section "Migrating Oracle Sequences" I suspect that changing Tools > Project Settings > General > Conversion > Sequence Conversion to "Using column identity" should suffice.

PS: I didn't try it on newer SSMA versions, judging based on the guide only.

IgorK
  • 886
  • 9
  • 26