| 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 (x86)/MySQL/MySQL Workbench 6.1 CE/modules/ |
Upload File : |
,2Sc f @ s d d l Z d d l Z d d l m Z d d l Z d d l m Z d d l m Z e d d d d d d
Z d d e
f d
d e
f d d e
f d d e
f d d e
f d d e f d d e
f d d e
f d d e
f d d e
f d d e
f d d e f d d e
f d d e f d d e
f d d e f d d e
f d d e
f d d e
f d! d" e
f d# d" e
f d$ d" e
f d% d e
f d& d e
f d' d e
f d( d) e
f d* d" e
f d+ d, e
f d- d e f d. d/ e
f d0 d/ e f d1 d2 e f d3 d2 e
f d4 d/ e
f d5 d/ e
f d6 d7 e
f d8 d9 e
f d: d; e
f d< d= e
f d> d? e
f d@ dA e
f dB dC e
f dD dE e
f dF dG e
f dH dI e
f dJ dK e
f dL dM e
f dN dO e
f dP dQ e
f dR dS e
f dT dU e
f dV dW e
f dX dY e
f dZ d[ e
f d\ d] e
f d^ d_ e
f d` da e
f db dc e
f dd de e
f df dg e
f dh di e
f dj dk e
f dl dm e
f dn do e
f dp dq e
f dr ds e
f dt du e
f dv dw e
f dx dy e
f dz d{ e
f d| d} e
f d~ d e
f d d e
f d d e
f d d e
f d d e
f d d e
f d d e
f d d e
f d d e
f d d e
f d d e
f d d e
f d d e
f d d e
f d d e
f d d e
f d d e
f d d e
f d d e
f d d e
f d d e
f d d e
f d d e
f d d e
f d d e
f d d e
f d d e
f d d e
f d d e
f gd Z d a
d e f d YZ e Z e j e j d Z e j e j e j e j j d Z e j e j j e j j e j j d Z e j e j j e j j e j j e j j d Z e j e j j e j j e j j e j j d Z e j e j e j j e j j e j j d Z e j e j j e j j e j j e j j d Z! e j e j j" e j j e j j# e j j d Z$ e j e j j% e j j e j j& e j j d Z' e j e j j( e j j e j j) e j j d Z* e j e j j e j j e j j d Z+ e j e j, e j j- f e j j d Z. d S( iN( t DefineModule( t GenericMigration( t find_object_with_namet namet DbMssqlMigrationt authors Oracle Corp.t versions 1.0t SQL_Latin1_General_Cp437_BINt utf8_general_cit SQL_Latin1_General_Cp437_CS_ASt SQL_Latin1_General_Cp437_CI_ASt# SQL_Latin1_General_Pref_CP437_CI_ASt SQL_Latin1_General_Cp437_CI_AIt SQL_Latin1_General_Cp850_BINt utf8_bint SQL_Latin1_General_Cp850_CS_ASt SQL_Latin1_General_Cp850_CI_ASt# SQL_Latin1_General_Pref_CP850_CI_ASt SQL_Latin1_General_Cp850_CI_AIt SQL_1Xcompat_CP850_CI_ASt Latin1_General_BINt
latin1_bint SQL_Latin1_General_Cp1_CS_ASt SQL_Latin1_General_Cp1_CI_ASt! SQL_Latin1_General_Pref_CP1_CI_ASt SQL_Latin1_General_Cp1_CI_AIt SQL_AltDiction_Cp850_CS_ASt SQL_AltDiction_Pref_CP850_CI_ASt SQL_AltDiction_Cp850_CI_AIt! SQL_Scandinavian_Pref_Cp850_CI_ASt utf8_swedish_cit SQL_Scandinavian_Cp850_CS_ASt SQL_Scandinavian_Cp850_CI_ASt SQL_AltDiction_Cp850_CI_ASt Latin1_General_CS_ASt Latin1_General_CI_ASt Danish_Norwegian_CS_ASt utf8_danish_cit Finnish_Swedish_CS_ASt Icelandic_CS_ASt utf8_icelandic_cit
Hungarian_BINt SQL_Latin1_General_Cp1250_CS_ASt cp1250_general_cit SQL_Latin1_General_Cp1250_CI_ASt SQL_Czech_Cp1250_CS_ASt cp1250_czech_cst SQL_Czech_Cp1250_CI_ASt SQL_Hungarian_Cp1250_CS_ASt SQL_Hungarian_Cp1250_CI_ASt SQL_Polish_Cp1250_CS_ASt sql_polish_cp1250_cs_ast SQL_Polish_Cp1250_CI_ASt sql_polish_cp1250_ci_ast SQL_Romanian_Cp1250_CS_ASt sql_romanian_cp1250_cs_ast SQL_Romanian_Cp1250_CI_ASt sql_romanian_cp1250_ci_ast SQL_Croatian_Cp1250_CS_ASt sql_croatian_cp1250_cs_ast SQL_Croatian_Cp1250_CI_ASt sql_croatian_cp1250_ci_ast SQL_Slovak_Cp1250_CS_ASt sql_slovak_cp1250_cs_ast SQL_Slovak_Cp1250_CI_ASt sql_slovak_cp1250_ci_ast SQL_Slovenian_Cp1250_CS_ASt sql_slovenian_cp1250_cs_ast SQL_Slovenian_Cp1250_CI_ASt sql_slovenian_cp1250_ci_ast Cyrillic_General_BINt cyrillic_general_bint SQL_Latin1_General_Cp1251_CS_ASt sql_latin1_general_cp1251_cs_ast SQL_Latin1_General_Cp1251_CI_ASt sql_latin1_general_cp1251_ci_ast SQL_Ukrainian_Cp1251_CS_ASt sql_ukrainian_cp1251_cs_ast SQL_Ukrainian_Cp1251_CI_ASt sql_ukrainian_cp1251_ci_ast Greek_BINt greek_bint SQL_Latin1_General_Cp1253_CS_ASt sql_latin1_general_cp1253_cs_ast SQL_Latin1_General_Cp1253_CI_ASt sql_latin1_general_cp1253_ci_ast SQL_MixDiction_Cp1253_CS_ASt sql_mixdiction_cp1253_cs_ast SQL_AltDiction_Cp1253_CS_ASt sql_altdiction_cp1253_cs_ast SQL_Latin1_General_Cp1253_CI_AIt sql_latin1_general_cp1253_ci_ait Turkish_BINt turkish_bint SQL_Latin1_General_Cp1254_CS_ASt sql_latin1_general_cp1254_cs_ast SQL_Latin1_General_Cp1254_CI_ASt sql_latin1_general_cp1254_ci_ast
Hebrew_BINt
hebrew_bint SQL_Latin1_General_Cp1255_CS_ASt sql_latin1_general_cp1255_cs_ast SQL_Latin1_General_Cp1255_CI_ASt sql_latin1_general_cp1255_ci_ast
Arabic_BINt
arabic_bint SQL_Latin1_General_Cp1256_CS_ASt sql_latin1_general_cp1256_cs_ast SQL_Latin1_General_Cp1256_CI_ASt sql_latin1_general_cp1256_ci_ast SQL_Latin1_General_Cp1257_CS_ASt sql_latin1_general_cp1257_cs_ast SQL_Latin1_General_Cp1257_CI_ASt sql_latin1_general_cp1257_ci_ast SQL_Estonian_Cp1257_CS_ASt sql_estonian_cp1257_cs_ast SQL_Estonian_Cp1257_CI_ASt sql_estonian_cp1257_ci_ast SQL_Latvian_Cp1257_CS_ASt sql_latvian_cp1257_cs_ast SQL_Latvian_Cp1257_CI_ASt sql_latvian_cp1257_ci_ast SQL_Lithuanian_Cp1257_CS_ASt sql_lithuanian_cp1257_cs_ast SQL_Lithuanian_Cp1257_CI_ASt sql_lithuanian_cp1257_ci_ast SQL_Danish_Pref_Cp1_CI_ASt sql_danish_pref_cp1_ci_ast SQL_SwedishPhone_Pref_Cp1_CI_ASt sql_swedishphone_pref_cp1_ci_ast SQL_SwedishStd_Pref_Cp1_CI_ASt sql_swedishstd_pref_cp1_ci_ast SQL_Icelandic_Pref_Cp1_CI_ASt sql_icelandic_pref_cp1_ci_ast Japanese_BINt japanese_bint Japanese_CI_ASt japanese_ci_ast Korean_Wansung_BINt korean_wansung_bint Korean_Wansung_CI_ASt korean_wansung_ci_ast Chinese_Taiwan_Stroke_BINt chinese_taiwan_stroke_bint Chinese_Taiwan_Stroke_CI_ASt chinese_taiwan_stroke_ci_ast Chinese_PRC_BINt chinese_prc_bint Chinese_PRC_CI_ASt chinese_prc_ci_ast Japanese_CS_ASt japanese_cs_ast Korean_Wansung_CS_ASt korean_wansung_cs_ast Chinese_Taiwan_Stroke_CS_ASt chinese_taiwan_stroke_cs_ast Chinese_PRC_CS_ASt chinese_prc_cs_ast Thai_BINt thai_bint
Thai_CI_ASt
thai_ci_ast
Thai_CS_ASt
thai_cs_ast SQL_EBCDIC037_CP1_CS_ASt sql_ebcdic037_cp1_cs_ast SQL_EBCDIC273_CP1_CS_ASt sql_ebcdic273_cp1_cs_ast SQL_EBCDIC277_CP1_CS_ASt sql_ebcdic277_cp1_cs_ast SQL_EBCDIC278_CP1_CS_ASt sql_ebcdic278_cp1_cs_ast SQL_EBCDIC280_CP1_CS_ASt sql_ebcdic280_cp1_cs_ast SQL_EBCDIC284_CP1_CS_ASt sql_ebcdic284_cp1_cs_ast SQL_EBCDIC285_CP1_CS_ASt sql_ebcdic285_cp1_cs_ast SQL_EBCDIC297_CP1_CS_ASt sql_ebcdic297_cp1_cs_asi t MSSQLMigrationc B sS e Z e d Z d Z d Z d Z d Z d Z d Z d Z
RS( c C sC t j d t j } | } d } | j d r? | j d s] | j d rm | j d rm | d d !} n | r | j | r | j t j d d } d
| | f } n t | d k r t
d 7a
| } | d t t
} | d
| | f 7} n | r?| r?t j
j } d | _ | | _ | j j | n | S( Ns
^[^/\\.]+$t t "t [t ]i is /\.t ___u Schema and table names cannot contain "/", "\", ".", or characters that are not permitted in file names. The identifier [%s] was changed to `%s`. i@ i> u. Identifier `%s` is too long, truncated to `%s`( t ret compilet Ut
startswitht endswitht matcht translatet stringt maketranst lent truncated_identifier_serialt strt grtt classest GrtLogEntryt entryTypeR t entriest append( t selft
mssql_namet logt dots_allowedt mysql_valid_regext
mysql_namet log_messaget original_mysql_namet entry( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mssql_migration_grt.pyt migrateIdentifier s*
c C sU t t | j | | | } | j | | j j | j j | | \ | _ | _ | S( N( t superR t migrateTableToMySQLt migrateCharsetCollationt ownert defaultCharacterSetNamet defaultCollationName( R t statet sourceTablet targetSchemat targetTable( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mssql_migration_grt.pyR s 3c C s | } | j r | j j } | d k r? | d k r d } q n_ | d k r | j d k r d } t | j j d | _ | j d | | d | | f q n | r | j d r | | k r y t | Wq d } | j d
| | d | q Xq n | S(
Nt TIMESTAMPs getdate()t CURRENT_TIMESTAMPt DATETIMEt
SMALLDATETIMEi s= Default value is %s, so type was changed from %s to TIMESTAMPt 'R i s! Default value %s is not supported( s DATETIMER ( t
simpleTypeR t defaultValueR t
targetCatalogt simpleDatatypest addMigrationLogEntryR t float( R R t
default_valuet
source_columnt
target_columnt target_default_valuet source_datatype( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mssql_migration_grt.pyt migrateColumnDefaultValue s( "c C s | j } t d | j D } | j } | r` | j r` | j j } | j j | j j n | r| j j } d } | dC k r | j
d k r d } q1d | j
k o d k n r d } q1| j j d k r d
n d } nI| dD k r d } n4| dE k r:d | j
k o#d k n r1d } q1d
} n| dF k rX| } d | _
n| d k r| } d | _
d | j k r1| j j d q1n| d k rd } d | _
d | j k r| j j d n | j d | | d | | | j
f n3| d k rBd } d | _
| j d | | d | | | j
f n| dG k r| j d k rd } | j
d k r{d } n0 | j
d k rd } n | j
d k rd } n d | _
q1d } nq| d k rd } n\| d k r| j
d k r1d! } d | _
q1n,| dH k r8d } | j j | _
| j j | _ n| dI k r| j
d k r\d' } q1d | j
k ovd k n r| d$ k rd( } q| } q1d | j
k od) k n rd* } q1d' } ng| dJ k rd+ } d | _
nI| dK k r | j rd% n d& } n%| d1 k r*d1 } d | _
n| d2 k rHd2 } d | _
n | d3 k r|d } d4 | _
| j d | | d5 n | d6 k rd
} | j d | | d7 n | dL k rd8 } nu | d: k rd } d; | _
| j d4 | | d< nA | d= k r+d
} | j d4 | | d | | | j
f n | } | j | rP| | | _ nJ t j d> d? | | f | j d@ | | dA | j | j j | f t St S| j d@ | | dB | j | j j | j f t St S(M Nc s s$ | ] } | j j | f Vq d S( N( R t upper( t .0t datatype( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mssql_migration_grt.pys <genexpr> s R t VARCHARt NVARCHARit LONGTEXTi i i t TEXTt NTEXTt CHARt NCHARt BIGINTt INTt SMALLINTt TINYINTt UNSIGNEDt UNIQUEIDENTIFIERi@ t UNIQUEs, Source column type %s was migrated to %s(%s)t SYSNAMEi t DECIMALt NUMERICi t MEDIUMINTi
t REALt FLOATi t DOUBLEt MONEYt
SMALLMONEYt IMAGEt BINARYt VARBINARYt LONGBLOBt TINYBLOBi t
MEDIUMBLOBR R t DATETIME2t DATETIMEOFFSETR t
ROWVERSIONt DATEt TIMEt BITi s1 Source column type BIT was migrated to TINYINT(1)t XMLs+ Source column type XML was migrated to TEXTt GEOMETRYt GEOGRAPHYt HIERARCHYIDi s; Source column type HIERARCHYID was migrated to VARCHAR(255)t SQL_VARIANTs MSSQL migrateTableColumnsToMySQLs# Can't find datatype %s for type %s
i s< Could not migrate column "%s" in "%s": Unknown datatype "%s"s2 Could not migrate type of column "%s" in "%s" (%s)( s VARCHARs NVARCHAR( R R ( R s NCHAR( s BIGINTs INTs SMALLINT( R R ( R R
( R s BINARYs VARBINARY( s DATETIMEs
SMALLDATETIMER R ( s TIMESTAMPR ( R R ( R t dictR R t userTypet
actualTypet flagst extendR R t lengthR t majorNumbert precisionR R t scalet numericPrecisiont numericScalet isNotNullt has_keyR t log_warningR t Falset Truet formattedRawType( R R R R R t mysql_simpleTypest source_typeR t target_datatype( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mssql_migration_grt.pyt migrateDatatypeForColumn s !
c
C s; x4| j D])} x | j D]} x | j D]} d% } d% } | j | } | rf t j | | } n | r* | r* | j j j } | d& k r | d k r| j
d k s | j
d k r d } q d | j
} qn.| d' k r | d k rd } qn
| d( k r%| d
k rd | j
} qn | d
k r:d } n | d k rOd } n | d) k r| j d k rd | d k rd n | } qnx | d k rd } nc | d* k rd } nN | d k rd } n9 | d k rd } n$ | d+ k r| j rd, n d" } n | r+d# | | j
j d$ | j <q+q* q* Wq Wq
W| S(- s]
Create datatype cast expression for target column based on source datatype.
R R i is CAST(? as NVARCHAR(MAX))s CAST(? as NVARCHAR(%d))R R s CAST(? as NTEXT)R R s CAST(? as NCHAR(%d))R s CAST(? as VARCHAR(64))R s CAST(? as VARCHAR(128))R R i s
CAST(? as %s)R R R s CAST(? as NVARCHAR(max))R R s ?.STAsText()R s CAST(? as VARCHAR(max))R R R R R
s %s as ?s columnTypeCastExpression:%sN( s VARCHARs NVARCHAR( s TEXTs NTEXT( s CHARs NCHAR( s DECIMALs NUMERIC( s GEOMETRYs GEOGRAPHY( s TIMESTAMPs
ROWVERSIONs CAST(? as BINARY)( t schematat tablest columnst Nonet lookupSourceObjectR t getColumnDataTypeR R R R! R$ R' R t
customData(
R R t target_catalogR R R t type_cast_expressionR R R/ ( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mssql_migration_grt.pyt migrateUpdateForChangesV sR " -c C s. | r$ | j d | | d | d S| | f S( Ni s( Collation %s migrated to utf8_general_ciR R ( R R ( R ( R R t charsett collationt
source_objectt
target_object( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mssql_migration_grt.pyR s
c C sX t j | | | | } | rT | j rT | j j } | d k rQ | j | _ qQ qT n | S( NR R R R ( s INTs TINYINTs SMALLINTs BIGINT( R t migrateTableColumnToMySQLR R t identityt
autoIncrement( R R R R R R ( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mssql_migration_grt.pyR? s c C s t j | | | | } | S( N( R t migrateTableForeignKeyToMySQL( R R t source_fkR t target_fk( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mssql_migration_grt.pyRB s ( t __name__t
__module__R* R R R R0 R: R R? RB ( ( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mssql_migration_grt.pyR s 5 c C s d S( Nt Mssql( ( ( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mssql_migration_grt.pyt getTargetDBMSName s c C s t j | | S( N( t instanceR ( R R ( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mssql_migration_grt.pyR s c C s t j | | S( N( RI t migrateCatalog( R t
sourceCatalog( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mssql_migration_grt.pyRJ s c C s t j | | | S( N( RI t
migrateSchema( R t sourceSchemaR ( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mssql_migration_grt.pyRL s c C s t j | | | S( N( RI R ( R R t
target_schema( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mssql_migration_grt.pyR s c C s t j | | | S( N( RI t migrateTableToMySQL2ndPass( R R R ( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mssql_migration_grt.pyRO s c C s t j | | | S( N( RI RB ( R RC R ( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mssql_migration_grt.pyRB s c C s t j | | | S( N( RI t migrateTriggerToMySQL( R t source_triggert target_table( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mssql_migration_grt.pyRP s c C s t j | | | S( N( RI t migrateViewToMySQL( R t source_viewRN ( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mssql_migration_grt.pyRS s c C s t j | | | S( N( RI t migrateRoutineToMySQL( R t source_routineRN ( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mssql_migration_grt.pyRU s c C s t j | | S( N( RI R: ( R R8 ( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mssql_migration_grt.pyR: s c C s" t j t j t j j j } | S( N( R t Listt OBJECTR t db_migration_MigrationParametert __grtclassname__( R t list( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mssql_migration_grt.pyt getMigrationOptions s (/ R R t wbR R t db_generic_migration_grtR t workbench.utilsR t
ModuleInfoR* R+ t MSSQL_COLLATION_MAPR R RI t exportt STRINGRH R t GrtLogObjectR t
db_Catalogt db_migration_MigrationRJ t db_SchemaRL t db_TableR R RO t db_mysql_ForeignKeyt
db_ForeignKeyRB t db_mysql_Triggert
db_TriggerRP t
db_mysql_Viewt db_ViewRS t db_mysql_Routinet
db_RoutineRU R: t LISTRY R\ ( ( ( sU C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\db_mssql_migration_grt.pyt <module> s ( *099699990