Skip Headers
Oracle® Database SQL Developer Supplementary Information for Microsoft SQL Server Migrations
Release 1.2

Part Number E10379-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

Beta Draft

1 Overview

This chapter introduces Oracle SQL Developer (SQL Developer). It contains the following sections:

1.1 Introduction

SQL Developer is a tool that simplifies the process of migrating data and applications from a Microsoft SQL Server environment to an Oracle database. SQL Developer allows you to quickly and easily migrate an entire application system, that is the database schema including triggers and stored procedures, in an integrated, visual environment.

Note:

Microsoft SQL Server is used in this document to refer to Microsoft SQL Server 6.5, Microsoft SQL Server 7.0, and Microsoft SQL Server 2000 unless otherwise stated.

1.2 Product Description

SQL Developer allows you to migrate a Microsoft SQL Server database to an Oracle database. SQL Developer employs an intuitive and informative user interface to simplify the migration process.

SQL Developer uses a repository to store migration information. This allows you to query the initial state of the application before migration. By initially loading the components of the application system that can be migrated into a repository, you can work independently of the production application.

Furthermore, SQL Developer saves useful dependency information about the components you are converting. For example, SQL Developer keeps a record of all the tables accessed by a stored procedure. You can then use this information to understand the impact of modifying a given table.

1.3 Features

SQL Developer Release 1.2 includes core features and Microsoft SQL Server migration specific features. SQL Developer allows you to:

1.4 Glossary

The following terms are used to describe SQL Developer:

Dependency is used to define a relationship between two migration entities. For example, a database view is dependent upon the table it references.

Destination Database is the Oracle database to which SQL Developer migrates the data dictionary of the source database.

Migration Component is part of an application system that can be migrated to an Oracle database. Examples of migration components are tables and stored procedures.

Migration Entity is an instance of a migration component. The table EMP would be a migration entity belonging to the table MIGRATION COMPONENT.

Migration Repository is the area in an Oracle database used to store the persistent information necessary for SQL Developer to migrate a source database.

Navigator Pane is the part of the SQL Developer User Interface that contains the tree views representing the Source Model and the Oracle Model.

Oracle Model is a a series of Oracle tables that is created from the information in the Source Model. It is a visual representation of how the source database looks when generated in an Oracle environment.

Properties Pane is the part of the SQL Developer User Interface that displays the properties of a migration entity that has been selected in one of the tree views in the Navigator Pane.

Progress Window is the part of the SQL Developer User Interface that contains informational, error, or warning messages describing the progress of the migration process.

Software Development Kit (SDK) is a set of well-defined application programming interfaces (APIs) that provide services that a software developer can use.

Source Database is the database containing the data dictionary of the application system being migrated by SQL Developer. The source database is a database other than Oracle, for example, Microsoft SQL Server.

Source Model is a replica of the data dictionary of the source database. It is stored in the Oracle SQL Developer Repository and is loaded by SQL Developer with the contents of the data dictionary of the source database.