Migrating from Oracle Database to SQL Server provides a feature
rich environment at lower cost. Migrating from one technology platform to
another is not always an easy task. Microsoft provides a free SQL Server
Migration Assistant (SSMA) for Oracle that makes the process easier.
The first step in any migration is to determine how to
migrate from the Oracle tablespace environment to SQL Server file groups.
Another consideration is how to map Oracle schemas to SQL Server databases.
SSMA tool allows you to make these mapping.
Learn how to step through an Oracle to SQL Server
migration by reading this white paper. This 167-page white paper will help you
understand the issues associated with a migration, and help you plan your
migration. If you are contemplating making the move to SQL Server from Oracle,
then you owe it to yourself to read this paper to make sure you understand all
the migration issues.