Migration from Oracle 10g to SQl Server 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Migration from Oracle 10g to SQl Server 2005

Migration from Oracle 10g to SQl Server 2005

Rate Topic

Display Mode

Topic Options

Author

Message

sachin.s.joshi

Posted Thursday, June 12, 2008 11:31 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 5:56 AM
Points: 5, Visits: 34

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.

Post #516424

Wilfred van Dijk

Posted Friday, June 13, 2008 5:53 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, March 06, 2013 12:56 AM
Points: 898, Visits: 1,045

WOW

, that's a big opportunity!

To my opinion, I don't think a forum is a good location for such a big migration. Most of the items you describe are available in MSSQL, but some operate totally different (for example partitioning). So without the knowledge of your Oracle database and environment, it's almost impossible to help you.

Hire some specialists to do the job, instead of waiting for the final answer (which is 42)

Wilfred
The best things in life are the simple things

Post #516591

« Prev Topic | Next Topic »

Permissions