Problems consolidating databases
The Migration Wizard uses the same Oracle database connection required to run the scripts as it does to move the data.There are hundreds of databases in many Oracle environments, supporting different applications and running on a variety of server platforms.In general, Olsen said, the less complicated your systems are, the less time and money you'll end up spending to maintain, support and repair them."Let's keep this environment simple," he advised listeners."But virtualization is not the consolidation strategy." With dedicated databases, a server will run a specific set of databases under a shared OS, Olsen said.
The captured model contains data types, naming schemes etc.This step is used to capture a snapshot of the current state of your third-party database and is necessary to provide SQL Developer with a "point in time" view of your database.Once this step is complete, the Migration wizard works on the meta-data stored in its repository, instead of issuing queries against your live database.Benefits of Consolidating Databases: Reduce Costs with Hardware and Software Consolidation and Improve Reliability, Scalability, and Peformance with Oracle.Oracle SQL Developer is a free and fully supported product that provides tools and utilities to migrate from Microsoft SQL Server to Oracle.