Skip to content
Oracle Database Migration Tool
PLSQL PLpgSQL TSQL JavaScript Shell SQLPL Other
Branch: master
Clone or download
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
jpg Public Release Apr 10, 2019
moat369 Public Release Apr 10, 2019
sql Moved Feature Usage Statistics to 1G. Jul 11, 2019
LICENSE.md Public Release Apr 10, 2019
README.md Public Release Apr 10, 2019
mig360.sh Public Release Apr 10, 2019
mig360.sql Public Release Apr 10, 2019

README.md

mig360

MIG360 is a tool to advise Database migrations.

  1. Unzip mig360.zip, navigate to the root mig360 directory, and connect as SYS, DBA, or any User with Data Dictionary access:

    $ unzip mig360.zip $ cd mig360 $ sqlplus / as sysdba

  2. Execute mig360.sql.

    SQL> @mig360.sql

Usage:

@mig360

@mig360 T N

@mig360 T N 1-4

@mig360 T Y 8

1st parameter: (T)uning pack, (D)iagnostic pack, (N)one 2nd parameter: Y/N - run or not run eSCP 3rd parameter: sections (optional) - default all sections 4th parameter: Type of migration (To be implemented)

  1. Unzip output MIG360___YYYYMMDD_HH24MI.zip into a directory on your PC

  2. Review main html file 00001_mig360__index.html

Notes

  1. As mig360 can run for a long time, in some systems it's recommend to execute it unattended:

    $ nohup sqlplus / as sysdba @mig360.sql T Y &

  2. If you need to execute MIG360 against all databases in the host, use mig360.sh:

    $ unzip mig360.zip $ cd mig360 $ sh mig360.sh T Y

  3. If you need to execute only a portion of MIG360 (i.e. a column, section or range) use these commands. Notice first parameter can be set to one section (i.e. 3b), one column (i.e. 3), a range of sections (i.e. 5c-6b) or range of columns (i.e. 5-7):

    SQL> @mig360.sql T N 8

    note: valid column range for first parameter is 1 to 9.

Versions

  • v01 (2019-04-10) by Alex Zaballa
You can’t perform that action at this time.