| 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 : |
2zXc 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 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 Versiont 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( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 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( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyR s 3c C s | } | j r| j j } | d k r? | d k r d } q nh | d
k r | j d k r d } t | j j d | _ d | _ | j d | | d | | f q n | r| j d r| | k ry t | Wqd
} | j d | | d | qXqn | S( Nt TIMESTAMPs getdate()t CURRENT_TIMESTAMPt DATETIMEt
SMALLDATETIMEii 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 lengtht addMigrationLogEntryR t float( R R t
default_valuet
source_columnt
target_columnt target_default_valuet source_datatype( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 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(t j | j
} | j j } t
j d d | j | | j f d } | dE k r | j d d d r d | _ n | dF k rJ| j d k rd } qd | j k od
k n r)d
} q| j
j d k rAd n d
} nn| dG k r_d } nY| dH k rd | j k od
k n rd } qd } n | dI k r| } d | _ n| d k r| } d | _ d | j k r| j j d qn| d k r`d
} d | _ d | j k r7| j j d n | j d | | d | | | j f nX| d k rd
} d | _ | j d | | d | | | j f n| dJ k r"| j d k rd } | j d k rd } n0 | j d k rd } n | j d k r
d } n d | _ qd } n| d! k r7d" } n| d" k rg| j d# k rd$ } d | _ qnQ| dK k rd } | j j | _ | j j | _ n | d' k rd( } n | d) k r| j d k rd( } n| dL k r6d* } d | _ | j d d. d/ r| d+ k r| j d k r'| j n d. | _ qn| dM k rZ| j rQd2 n d) } n^| d3 k rxd3 } d | _ n@| d4 k rd4 } d | _ | j d d. d/ r| j d k r| j n d. | _ qn | d5 k rd } d6 | _ | j d | | d7 n | d8 k r.d } | j d | | d9 n | dN k rCd: } nu | d< k rwd
} d= | _ | j d6 | | d> nA | d? k rd } | j d6 | | d | | | j f n | } | j | r| | | _ nM t
j d d@ dA | | f | j dB | | dC | j | j j | f t St S| j dB | | dD | j | j j | j f t St S(O Nc s s$ | ] } | j j | f Vq d S( N( R t upper( t .0t datatype( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pys <genexpr> s t Migrations4 Migrating source column '%s' - type: %s, length: %s
R t NCHARt NVARCHARi i t utf8mb4t VARCHARit LONGTEXTi t TEXTt NTEXTt CHARt 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 LONGBLOBt VARBINARYR R t DATETIME2t DATETIMEOFFSETi i R t
ROWVERSIONt BINARYt 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 NCHARs NVARCHAR( s VARCHARs NVARCHAR( s TEXTR ( s CHARs NCHAR( s BIGINTs INTs SMALLINT( s DECIMALs NUMERIC( R
R ( s DATETIMEs
SMALLDATETIMER R ( s TIMESTAMPR ( R R ( R t dictR R t userTypet
actualTypet flagst extendR t fromgrtR R R R t
log_debug3R t# is_supported_mysql_version_at_leastt characterSetNamet majorNumbert precisionR R t scalet numericPrecisiont numericScalet isNotNullt has_keyt log_warningR t Falset Truet formattedRawType(
R R R R R t mysql_simpleTypest source_typet target_versionR t target_datatype( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyt migrateDatatypeForColumn s #! ! !' '
c
C s, x%| 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 | } qni | d k rd } nT | d+ k rd } n? | d k rd } n* | d k rd } n | d, k rd# } 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 CONVERT(VARBINARY(MAX), ?, 0)s %s as ?s columnTypeCastExpression:%sN( s VARCHARs NVARCHAR( s TEXTs NTEXT( s CHARs NCHAR( s DECIMALs NUMERIC( s GEOMETRYs GEOGRAPHY( s BINARYs VARBINARYs TIMESTAMPs
ROWVERSION( t schematat tablest columnst Nonet lookupSourceObjectR t getColumnDataTypeR R R R R) R t
customData(
R R t target_catalogR R R t type_cast_expressionR R R5 ( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyt migrateUpdateForChangesX 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( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 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 ( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyRE s c C s t j | | | | } | S( N( R t migrateTableForeignKeyToMySQL( R R t source_fkR t target_fk( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyRH s ( t __name__t
__module__R/ R R R R6 R@ R RE RH ( ( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyR s 5 c C s d S( Nt Mssql( ( ( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyt getTargetDBMSName s c C s t j | | S( N( t instanceR ( R R ( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyR s c C s t j | | S( N( RO t migrateCatalog( R t
sourceCatalog( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyRP s c C s t j | | | S( N( RO t
migrateSchema( R t sourceSchemaR ( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyRR s c C s t j | | | S( N( RO R ( R R t
target_schema( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyR s c C s t j | | | S( N( RO t migrateTableToMySQL2ndPass( R R R ( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyRU s c C s t j | | | S( N( RO RH ( R RI R ( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyRH s c C s t j | | | S( N( RO t migrateTriggerToMySQL( R t source_triggert target_table( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyRV s c C s t j | | | S( N( RO t migrateViewToMySQL( R t source_viewRT ( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyRY s c C s t j | | | S( N( RO t migrateRoutineToMySQL( R t source_routineRT ( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyR[ s c C s t j | | S( N( RO R@ ( R R> ( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 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( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyt getMigrationOptions s (0 R R t wbR R t db_generic_migration_grtR t workbench.utilsR R t
ModuleInfoR/ R0 t MSSQL_COLLATION_MAPR R RO t exportt STRINGRN R t GrtLogObjectR t
db_Catalogt db_migration_MigrationRP t db_SchemaRR t db_TableR R RU t db_mysql_ForeignKeyt
db_ForeignKeyRH t db_mysql_Triggert
db_TriggerRV t
db_mysql_Viewt db_ViewRY t db_mysql_Routinet
db_RoutineR[ R@ t LISTR_ Rb ( ( ( sO C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyt <module> s * *099699990