Results 1 to 2 of 2

Thread: Migration from Oracle 10g to SQL Server 2005

  1. 06-13-2008, 01:28 AM #1
    sachin.s.joshi
    sachin.s.joshi is offline Registered User
    Join Date
    Jun 2008
    Posts
    1

    Exclamation Migration from Oracle 10g to SQL Server 2005

    Migration of following features from Oracle 10g to SQl Server 2005

    1 Partitioning.
    2 Materialized views.
    3 Triggers. Some of the triggers came while we ported the code.
    4 Schedulers.
    5 Database links from Oracle to Oracle and Oracle to MSSQL server.
    6 Usage of synonyms
    7 Usage of sequences
    8 Introduction of CLOB data type.
    9 Introduction of global temporary table.


    Please help.
    Reply With Quote Reply With Quote
  2. 06-13-2008, 08:20 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Sql2k5 has all of them except sequences, may need some workaround. Check them in sql2k5 books online and Microsoft's 'SQL Server Migration Assistant for ORacle'.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules