Using the MAP Toolkit to discover Oracle, MySQL, and Sybase

Ola Amigos

Mais uma super dica passada pelo Symon Perriman – Microsoft

 Polegar para cima

Additional Resources:

Download the latest version of the MAP Toolkit from here! The latest version is the MAP Toolkit 6.5 that was released in December 2011.

The steps to discover Oracle, MySQL, or Sybase on UNIX/Linux machines…

1. After launching the MAP Toolkit, you are prompted to create a new database. Enter a name for the database and click Ok.


2. On the Data Collection page, click the “Go” button next to the “Perform an Inventory” step to launch the Inventory Wizard. Click Next to continue.

3. On the Inventory Scenario dialog of the Inventory Wizard, select Linux/UNIX computers option. This options will discover Oracle, MySQL, and Sybase on Linux and UNIX machines. If you would like to obtain more details about Oracle, MySQL, and Sybase, select the “MySQL, Oracle, Sybase” option. Note: If you want to obtain more details option, you need to installed the Oracle client on the machine where the MAP Toolkit is running from.


4. On the Discovery Methods dialog of the Inventory Wizard, select how you would like to discover the Linux/Unix machines. Generally to discover, Linux/Unix you will select scan an IP range or manually specify a list of machines. I will select “Manually enter computer names and credentials.”


5. On the All Computer Credentials dialog, click on the Create button.


6. On the Account Entry dialog, enter the credentials to connect to the machines and then click “Save”.


7. On the All Computers Credentials dialog, click Next to continue after all of the required credentials are added.


8. On the Enter Computers Manually dialog, click Create to display the “Specify Computers and Credentials” dialog.


9. On the Specify Computers and Credentials dialog, enter the machines to inventory, choose “Use All Computers credentials list” option and then click “Save”


10. On the Enter Computers dialog, click Next to continue when all of the computers are been added.


11. On the Connection Properties” dialog enter the TCP Port that MAP Toolkit should connect to and then click Next to continue.


12. On the Summary dialog, click Next to start the inventory process.


After the inventory process has completed, you can review the results with the MAP Toolkit console and through the available reports.

View results in the MAP Toolkit

To view the results in the MAP Toolkit, click on the Database | Oracle node in the left navigation. The results will display as shown below.


View reports

1. After you select the summary results, click on the Generate report/proposal link. When you select this option, the SqlMigrationDiscovery and SQLMigrationProposal reports will be generate.


2. To view the generated reports, click on View | Saved Reports and Proposals.



Sobre Julio Vaz

I'm a results-driven IT professional on consulting for integration projects with extensive experience in the engineering, administration and support. Direct experience with customer relationships, complex problem troubleshooting, implementation, optimization, technology advisor and training deliveries. Always interested in professional growth as well as high-quality service delivery. Specialties: Office 365. Windows Intune. Windows Azure. Microsoft Windows Server and Active Directory Microsoft Exchange Server 2000/2003/2007/2010, 2013 Windows Virtualization: Hyper-V Windows server 2008, 2008 R2, 2012, 2012 R2. Microsoft Isa Server 2000, Isa Server 2004, Isa Server 2006. Microsoft Forefront TMG 2010. Microsoft Project Server 2007/2010, 2013 Microsoft SharePoint 2007/2010, 2013 Documentation of the computing environment and services. Elaboration of technical procedures. Elaboration of proposals and projects. Management and training of support staff. Implementation and maintenance of security and backup policies. Implementation, administration and migration from Microsoft . Windows NT, Windows 2000 Server, Windows Server 2003 R2, Windows Server 2008 R2, Windows Server 2012 R2 Implementation and migration from Microsoft Office Communications Server 2007 Implementation and migration from Microsoft Lync Server 2010, 2013. Implementation and migration from Microsoft Exchange Server 2000, 2003 and 2007, 2010, 2013. Implementation and migration from Microsoft Isa Server 2000, 2004 and 2006, Forefront TMG Implementation Microsoft System Center 2012 R2 - SCCM, SCOM, DPM. Migration of servers and domains
Esse post foi publicado em Dicas. Bookmark o link permanente.

Deixe um comentário

Preencha os seus dados abaixo ou clique em um ícone para log in:

Logotipo do

Você está comentando utilizando sua conta Sair / Alterar )

Imagem do Twitter

Você está comentando utilizando sua conta Twitter. Sair / Alterar )

Foto do Facebook

Você está comentando utilizando sua conta Facebook. Sair / Alterar )

Foto do Google+

Você está comentando utilizando sua conta Google+. Sair / Alterar )

Conectando a %s