Problems consolidating databases
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.
"Virtualization is a tool in our consolidation strategy for isolation," he said.But running all those databases separately makes an environment difficult to manage and secure, which is a good reason to develop a strategy for consolidating databases in your Oracle systems.That's according to James Olsen, a database and infrastructure solutions architect at Oracle.Virtual machines are a good choice for retaining high levels of isolation while consolidating databases on a single server, Olsen said.He noted, though, that this approach can introduce more points of management for Oracle database administrators (DBAs) and IT teams.and getting the most bang for your buck [on the use of system resources]," he said.
Database sprawl occurs when a database architecture grows unchecked.
The next step in the migration process is to translate the T-SQL objects - constraints, functions, procedures, triggers, views - to Oracle SQL objects.
Once the migration has completed, you can return the Converted Database Objects node and rerun the Migration wizard to translate some or all of the objects again.
Olsen said the ultimate goal of Oracle database consolidation is to keep costs down.
That includes both capital equipment costs and operational expenses, which he described as the "care and feeding" of database systems.
The Migration Wizard uses the same Oracle database connection required to run the scripts as it does to move the data.