Convert Oracle to SQL

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • thupham
    New Member
    • Oct 2007
    • 28
    #1

    Convert Oracle to SQL

    Hi all,

    For converting Oracle to SQL, I convert a table and all index in that table, but in SQL, if we have 4 columns, we can only create maximum 3 indexes, in Oracle is not, if we have 4 columns, we can create maximum 4 indexes. I use SSMA tool, to convert table and all index, but it lost 1 index and I write an create index statement and meet bug have content: In SQL we can only create maximum 3 indexes. So can you help me to solve that problem. How can I create 4 indexes with 4 columns in SQL..

    Thanks
    Tags: None
    • amitpatel66
      Recognized Expert Top Contributor
      • Mar 2007
      • 2358
      #2
      Originally posted by thupham
      Hi all,

      For converting Oracle to SQL, I convert a table and all index in that table, but in SQL, if we have 4 columns, we can only create maximum 3 indexes, in Oracle is not, if we have 4 columns, we can create maximum 4 indexes. I use SSMA tool, to convert table and all index, but it lost 1 index and I write an create index statement and meet bug have content: In SQL we can only create maximum 3 indexes. So can you help me to solve that problem. How can I create 4 indexes with 4 columns in SQL..

      Thanks
      Try creating one index on more than one column

        Comment

        Previous template Next
        Working...