Oracle Arrays Migration RRS feed

  • Question

  • Hello,

    I am migrating from Oracle 10g to SQL Server 2008. Could anyone tell me on the best way to emulate Oracle arrays ? I know there are various options like Table Valued Parameters, Temp or Permanent Tables or CollectionIndexInt (in SSMA 4.0). I know the issue with TVP is that its only read only. Is there any way I can overcome this by copying the contents of the TVP into a table ?



    Tuesday, June 15, 2010 3:59 PM