| Server IP : 180.180.241.3 / Your IP : 216.73.216.252 Web Server : Microsoft-IIS/7.5 System : Windows NT NETWORK-NHRC 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586 User : IUSR ( 0) PHP Version : 5.3.28 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/Program Files/MySQL/MySQL Workbench 6.3 CE/modules/ |
Upload File : |
ó
2z”Xc @ sX d d l Z d d l Z d d l m Z d d l m Z d Z d e f d „ ƒ YZ d S( iÿÿÿÿN( t
WizardPage( t MiniTemplatesx
------------------------------------------------------------------------------------
MySQL Workbench Migration Wizard Report
Date: {{date}}
Source: {{sourceRdbmsName}} {{sourceRdbmsVersion}}
Target: {{targetRdbmsName}} {{targetRdbmsVersion}}
------------------------------------------------------------------------------------
I. Migration
1. Summary
Number of migrated schemas: {{#catalog.schemata}}
[[catalog.schemata]]
{{:#}}. {{name}}
Source Schema: {{sourceName}}
- Tables: {{#tables}}
- Triggers: {{#triggers}}
- Views: {{#views}}
- Stored Procedures: {{#procedures}}
- Functions: {{#functions}}
[[/catalog.schemata]]
2. Migration Issues
[[migrationLog]] - {{refObject.name}}
[[entries]][[?name]]{{entryType}} {{name}}[[/name]][[/entries]]
[[/migrationLog]]
3. Object Creation Issues
[[creationLog]] - {{refObject.name}}
[[entries]][[?name]]{{entryType}} {{name}}[[/name]][[/entries]]
[[/creationLog]]
4. Migration Details
[[catalog.schemata]][[tables]]
4.{{:#}}. [[?name]]Table {{owner.name}}.{{name}} ({{sourceName}})
[[?comment]]{{comment}}[[/comment]]
Columns:
[[columns]][[?name]] - {{name}} {{formattedRawType}} {{flags}} {{defaultValue}} [[?comment]]#{{comment}}[[/comment]]
[[!name]]column not migrated
[[/name]][[/columns]]
Foreign Keys:
[[foreignKeys]] - {{name}} ([[columns]]{{name}}[[/columns]]) ON {{referencedTable.name}} ([[referencedColumns]]{{name}}[[/referencedColumns]])
[[/foreignKeys]]
Indices:
[[indices]] - {{name}} ([[columns]]{{referencedColumn.name}}[[?if|columnLength > 0]]({{columnLength}})[[/if]][[?needsep]], [[/needsep]][[/columns]])
[[/indices]][[!name]]4.{{:#}} Table {{sourceName}} was not migrated
[[/name]]
[[/tables]][[/catalog.schemata]]
II. Data Copy
[[dataTransferLog]] - {{logObject.name}}
[[entries]] [[?name]]{{entryType}} {{name}}[[/name]] [[/entries]]
[[/dataTransferLog]]
t FinalReportViewc B s> e Z d „ Z d „ Z d „ Z d „ Z d „ Z d „ Z RS( c C sk t j | | d ƒ | j j | d d ƒ t j t j ƒ | _ | j j | j t
t
ƒ | j j d ƒ d S( Ns Migration Reportt Reportt Finish(
R t __init__t maint add_wizard_paget mformst
newTextBoxt VerticalScrollBart _reportt contentt addt Truet next_buttont set_text( t selfR ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_summary.pyR d s
c C sx | rd | j ƒ d | j j j j j ƒ k rQ | j j d ƒ | j j t ƒ qd | j j t
ƒ n t j | | ƒ d S( Nt GenerateBulkCopyScripts* Open folder that contains generated script(
t generate_migration_reportR t plant statet dataBulkTransferParamst keyst advanced_buttonR t showR t FalseR t page_activated( R t advancing( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_summary.pyR o s
c s
| j j j } | j } | j } d „ ‰ ‡ f d † ‰ ‡ ‡ f d † ‰ ‡ ‡ ‡ f d † } d „ } d „ } d d l } i | j ƒ d 6| j j j j
d 6d
| j j | j j
| j j f d 6| j j j j
d 6d
| j j | j j
| j j f d
6| j j d 6| j j d 6g | j D]' } t | j ƒ d k r$| | ƒ ^ q$d 6g | j D]' } t | j ƒ d k r\| | ƒ ^ q\d 6g | j D]' } t | j ƒ d k r”| | ƒ ^ q”d 6i | j d 6| j d 6g | j D] } | | | ƒ ^ qãd 6d 6}
|
S( Nc S s. x' | j D] } | j | k r
| j Sq
Wd S( N( t migrationLogt logObjectt refObjectt None( t objectR t log( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_summary.pyt find_migrated_object s c
s g } x- | j D]" } | j | k r | j } Pq q Wg } x- | j D]" } | j | k rF | j } PqF qF Wi g | D]? } i d d d g t t | j d ƒ d ƒ d 6| j d 6^ qv d 6g | D]? } i d d d g t t | j d ƒ d ƒ d 6| j d 6^ qà d 6} | rÿxê | j D]Ü } t | | ƒ } t
| ƒ t t t
t f k r\| | | <q t
| ƒ t j k rÏ| j d t j t j f k r¦d
j | ƒ | | <qøg | D] } ˆ | | ƒ ^ q| | <q t | t j ƒ rî| | | <q | | | <q Wn | S( Nt notet warningt errori i t typet messaget migrationMessagest createMessagess , ( R R t entriest creationLogt maxt mint entryTypet namet __grtmembers__t getattrR' t intt floatt strt unicodet grtt Listt __contenttype__t STRINGt INTt joint
isinstancet Object(
R! R t
logEntriesR" t
createEntriest et ot membert vt x( t reportize_object( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_summary.pyRF … s4 MP
)
c sÏ ˆ | | ƒ } ˆ | | ƒ } | j i | j d 6| r\ g | j D] } ˆ | | ƒ ^ qA n g d 6| rŽ g | j D] } ˆ | | ƒ ^ qs n g d 6| rÀ g | j D] } ˆ | | ƒ ^ q¥ n g d 6ƒ | S( Nt
sourceNamet columnst foreignKeyst indices( t updateR0 RH RI RJ ( t tableR t migratedt objt columnt fkt index( R# RF ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_summary.pyt reportize_table¤ s
226c s% ˆ | | ƒ } ˆ | | ƒ } | j i | j d 6g | j D] } ˆ | | ƒ ^ q; d 6g | j D]% } | j D] } ˆ | | ƒ ^ qn qa d 6g | j D] } ˆ | | ƒ ^ q— d 6g | j D]$ } | j d k r½ ˆ | | ƒ ^ q½ d 6g | j D]$ } | j d k rò ˆ | | ƒ ^ qò d 6ƒ | S( NRG t tablest triggerst viewst FUNCTIONt functionst PROCEDUREt
procedures( RK R0 RS RT RU t routinest routineType( t schemaR t tschemat schema_dataRL t triggert viewt funct sp( R# RF RR ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_summary.pyt reportize_schema¯ s
&6&59c S s‹ i i | j j d 6d 6i | j r/ | j j n d d 6d 6g | j D]? } i d d d g t t | j d ƒ d ƒ d
6| j d 6^ qD d 6S( NR0 R t R R$ R% R& i i R/ R+ ( R R0 R R+ R- R. R/ ( R" RA ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_summary.pyt
reportize_log¼ s #c S se i i | j d 6d 6g | j D]? } i d d d g t t | j d ƒ d ƒ d 6| j d 6^ q d 6S(
NR0 R Rd R% R& i i R/ R+ ( R0 R+ R- R. R/ ( R" RA ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_summary.pyt reportize_transfer_logà s iÿÿÿÿt datet sourceRdbmsNames %s.%s.%st sourceRdbmsVersiont targetRdbmsNamet targetRdbmsVersiont sourceServert targetServeri R, R i t dataTransferLogRG R0 t schematat catalog( R R R t
sourceCatalogt
targetCatalogt timet ctimet sourceConnectiont drivert ownert captiont sourceDBVersiont majorNumbert minorNumbert
releaseNumbert targetConnectiont targetDBVersiont hostIdentifierR, t lenR+ R Rn R0 Ro ( R R t source_catalogt target_catalogRc Re Rf Rs RB R\ t report_data( ( R# RF RR sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_summary.pyt generate_report_dataz s4
&&
888
-c C s | j j ƒ d S( N( R t close( R ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_summary.pyt go_nextß s c C sY | j ƒ } y t t ƒ j | ƒ } Wn t k
rD } d | } n X| j j | ƒ d S( Ns Error generating report: %s( R„ R t
text_templatet rendert ExceptionR t set_value( R Rƒ t reportt exc( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_summary.pyR ã s c C s$ t j j | j j j j d ƒ d S( NR ( R t Utilitiest reveal_fileR R R R ( R ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_summary.pyt go_advancedí s ( t __name__t
__module__R R R„ R† R R ( ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_summary.pyR c s e
( R R7 t workbench.uiR t workbench.templateR R‡ R ( ( ( sJ C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_summary.pyt <module> s
J