http://arcdog.com/architects/p....ailuse33/activity/95
Migrating MSSQL to Oracle 1. Pre-Migration Assessment Evaluate the Database Schema and Size: Review the schema, relationships, data types, and triggers in your MSSQL database. Note differences in data types, constraints, and stored procedures. Identify Compatibility Issues: MSSQL and Oracle differ in SQL syntax, functions, and database objects. Make a list of features in MSSQL that might not translate directly to Oracle. Prepare for Downtime: Large databases or complex migrations might require downtime. Ensure proper planning for m