Database migration assessment report
Source database: ADIDAS.dbo.Prueba@localhost\SQLEXPRESS\localhost\SQLEXPRESS:1433
Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 13:48:23
Copyright (C) 2019 Microsoft Corporation
Express Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 19041: )
Case sensitivity: OFF
Executive summary
We completed the analysis of your Microsoft SQL Server source database and estimate that 100% of the
database storage objects and 84% of database code objects can be converted automatically or with minimal
changes if you select Amazon RDS for MySQL as your migration target. Database storage objects include
schemas, tables, table constraints, indexes, types, table types, sequences, synonyms and xml schema collections.
Database code objects include triggers, views, procedures, scalar functions, inline functions, table-valued
functions and database triggers. Based on the source code syntax analysis, we estimate 97% (based on # lines of
code) of your code can be converted to Amazon RDS for MySQL automatically. To complete the migration, we
recommend 996 conversion action(s) ranging from simple tasks to medium-complexity actions to complex
conversion actions.
Migration guidance for database objects that could not be converted automatically can be found here
Database objects with conversion actions for Amazon RDS for
MySQL
Of the total 292 database storage object(s) and 374 database code object(s) in the source database, we identifed
292 (100%) database storage object(s) and 314 (84%) database code object(s) that can be converted to Amazon
RDS for MySQL automatically or with minimal changes.
The target database version is less than MySQL 8.0 (8.0). The converted code might not work properly.
60 (16%) database code object(s) require 73 complex user action(s) to complete the conversion.
Figure: Conversion statistics for database storage objects
Schema
1
(1: 1/0/0/0)
Table
100% 146
(146: 146/0/0/0)
Constraint
100% 142
(142: 142/0/0/0)
Index
67% 33% 3
(3: 2/1/0/0)
0 10 100 1000
Objects automatically converted Objects with simple actions
Objects with medium-complexity actions Objects with complex actions
AWS Schema Conversion Tool Version 1.0.642 Page 1 of 7
11/10/2020 1:01PM
Database migration assessment report
Source database: ADIDAS.dbo.Prueba@localhost\SQLEXPRESS\localhost\SQLEXPRESS:1433
Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 13:48:23
Copyright (C) 2019 Microsoft Corporation
Express Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 19041: )
Case sensitivity: OFF
Figure: Conversion statistics for database code objects
Procedure
56% 27% 9% 7% 365
(365: 205/100/33/27)
Scalar function
71% 29% 7
(7: 5/2/0/0)
Table-valued function
100% 2
(2: 0/2/0/0)
0 10 100 1000
Objects automatically converted Objects with simple actions
Objects with medium-complexity actions Objects with complex actions
Detailed recommendations for Amazon RDS for MySQL migrations
If you migrate your Microsoft SQL Server database to Amazon RDS for MySQL, we recommend the following
actions.
Storage object actions
Index Changes
Not all indexs can be converted automatically. You'll need to address these issues manually.
Issue 682: MySQL doesn't support the INCLUDE option in indexes
Recommended action: Perform a manual conversion.
Issue code: 682 | Number of occurrences: 8 | Estimated complexity: Simple
Databases.ADIDAS.Schemas.dbo.Tables.Facturas.Indexes.ix_Facturas2.Columns.DatFactura
Databases.ADIDAS.Schemas.dbo.Tables.Facturas.Indexes.ix_Facturas2.Columns.DatRegistro
Databases.ADIDAS.Schemas.dbo.Tables.Facturas.Indexes.ix_Facturas2.Columns.IntFacturaId
Databases.ADIDAS.Schemas.dbo.Tables.Facturas.Indexes.ix_Facturas2.Columns.MonSubTotal
Databases.ADIDAS.Schemas.dbo.Tables.Facturas.Indexes.ix_Facturas2.Columns.MonTotal
+3 more
Code object actions
Procedure Changes
Not all procedures can be converted automatically. You'll need to address these issues manually.
Issue 659: The scope table-variables and temporary tables is different. You must apply
AWS Schema Conversion Tool Version 1.0.642 Page 2 of 7
11/10/2020 1:01PM
Database migration assessment report
Source database: ADIDAS.dbo.Prueba@localhost\SQLEXPRESS\localhost\SQLEXPRESS:1433
Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 13:48:23
Copyright (C) 2019 Microsoft Corporation
Express Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 19041: )
Case sensitivity: OFF
manual conversion, if you are using recursion
Recommended action: Please review generated code and modify it if necessary.
Issue code: 659 | Number of occurrences: 13 | Estimated complexity: Simple
Documentation references: https://dev.mysql.com/doc/refman/5.7/en/data-types.html
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_InsertaReglas: 334:398
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_InsertaReglas: 1419:1480
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_PremiaFacturas: 477:506
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_PremiaFacturas: 1608:1646
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_PremiaFacturasMasivas: 432:461
+8 more
Issue 663: Unable to resolve objects
Recommended action: Verify if unresolved object is present in the database. If it isn't, check the object name or
add the object. If the object is present, transform the code manually.
Issue code: 663 | Number of occurrences: 573 | Estimated complexity: Simple
Databases.ADIDAS.Schemas.dbo.Procedures.AbonoRedencionSocio_TX: 936:940
Databases.ADIDAS.Schemas.dbo.Procedures.AbonoRedencionSocio_TX: 948:952
Databases.ADIDAS.Schemas.dbo.Procedures.AbonoRedencionSocio_TX: 968:981
Databases.ADIDAS.Schemas.dbo.Procedures.AbonoRedencionSocio_TX: 989:993
Databases.ADIDAS.Schemas.dbo.Procedures.AbonoRedencionSocio_TX: 1001:1009
+568 more
Issue 672: Automatic conversion of dynamic statements is not supported
Recommended action: Perform a manual conversion.
Issue code: 672 | Number of occurrences: 58 | Estimated complexity: Simple
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_BuscaSocios: 4411:4429
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_BuscaSociosPaginacion: 5328:5346
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_BuscaUsuario: 2031:2046
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_ConsultaUsuario: 2358:2373
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_EdodeCuentaDetSocio: 3791:3809
+53 more
Issue 673: Unable to convert statements
Recommended action: Perform a manual conversion.
Issue code: 673 | Number of occurrences: 21 | Estimated complexity: Simple
Databases.ADIDAS.Schemas.dbo.Procedures.AbonoRedencionSocio_TX: 834:851
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_ConsultaEdodeCuenta: 386:403
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_InsertaComentarios: 450:465
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_RptFacturas: 120:135
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_TraeCapacitacionesJCI: 696:711
+16 more
Issue 675: These keywords are reserved for future extensions to specify ascending or
AWS Schema Conversion Tool Version 1.0.642 Page 3 of 7
11/10/2020 1:01PM
Database migration assessment report
Source database: ADIDAS.dbo.Prueba@localhost\SQLEXPRESS\localhost\SQLEXPRESS:1433
Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 13:48:23
Copyright (C) 2019 Microsoft Corporation
Express Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 19041: )
Case sensitivity: OFF
descending index-value storage. Currently, these keywords are parsed but ignored. Index
values are always stored in ascending order
Recommended action: Use indexes without this option.
Issue code: 675 | Number of occurrences: 2 | Estimated complexity: Simple
Documentation references: http://dev.mysql.com/doc/refman/5.7/en/create-index.html
Databases.ADIDAS.Schemas.dbo.Procedures.sp_upgraddiagrams: 394:405
Databases.ADIDAS.Schemas.dbo.Procedures.sp_upgraddiagrams: 413:416
Issue 696: MySQL doesn't support an Identity column with seed and increment
Recommended action: Perform a manual conversion.
Issue code: 696 | Number of occurrences: 1 | Estimated complexity: Simple
Databases.ADIDAS.Schemas.dbo.Procedures.SetCargaMasivaFile: 832:844
Issue 697: MySQL doesn't support an Identity column outside a primary key
Recommended action: Perform a manual conversion.
Issue code: 697 | Number of occurrences: 4 | Estimated complexity: Simple
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_TraeRankingCacs_Tx: 671:678
Databases.ADIDAS.Schemas.dbo.Procedures.ConsultaProductosPremiacion_Tx: 1860:1867
Databases.ADIDAS.Schemas.dbo.Procedures.ConsultaProductosPremiacion_Tx: 2724:2731
Databases.ADIDAS.Schemas.dbo.Procedures.SetCargaMasivaFile: 832:844
Issue 733: MySQL doesn't support the PRINT procedure
Recommended action: Try using INSERT in the log table. To do this, you must add code into ..PRINT.
Issue code: 733 | Number of occurrences: 16 | Estimated complexity: Simple
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_BuscaSocios: 4394:4408
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_BuscaSociosPaginacion: 5311:5325
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_BuscaUsuario: 2012:2026
Databases.ADIDAS.Schemas.dbo.Procedures.ConsultaProductosPremiacion_Tx: 7527:7540
Databases.ADIDAS.Schemas.dbo.Procedures.GetSociosConCanjes: 6097:6111
+11 more
Issue 774: Unable to perform an automated migration of the arithmetic operations with
mixed types of operands
Recommended action: Make cast operands to the expected type.
Issue code: 774 | Number of occurrences: 22 | Estimated complexity: Simple
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_InsertaReglas: 525:545
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_InsertaReglas: 568:585
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_RptFacturas: 1440:1460
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_RptFacturas: 1466:1483
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_RptSociosRegistrados: 4229:4249
+17 more
AWS Schema Conversion Tool Version 1.0.642 Page 4 of 7
11/10/2020 1:01PM
Database migration assessment report
Source database: ADIDAS.dbo.Prueba@localhost\SQLEXPRESS\localhost\SQLEXPRESS:1433
Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 13:48:23
Copyright (C) 2019 Microsoft Corporation
Express Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 19041: )
Case sensitivity: OFF
Issue 810: MySQL doesn't support the SET NOCOUNT
Recommended action: If need try another way to send message back to the client application.
Issue code: 810 | Number of occurrences: 32 | Estimated complexity: Simple
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_Acceso_tx: 823:832
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_Acceso_txStore: 781:790
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_AddMensajesApoyo: 506:515
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_ConsutaCargaAvancesRNK: 409:418
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_Facturas_E: 490:499
+27 more
Issue 823: MySQL doesn't support table hints in DML statements
Recommended action: Use MySQL methods of performance tuning.
Issue code: 823 | Number of occurrences: 158 | Estimated complexity: Simple
Databases.ADIDAS.Schemas.dbo.Procedures.ActualizaProducto_tx: 681:692
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_Acceso_tx: 930:941
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_Acceso_tx: 1055:1066
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_Acceso_tx: 1861:1872
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_Acceso_tx: 1897:1908
+153 more
Issue 905: MySQL doesn't support the PIVOT clause for the SELECT statement
Recommended action: You can use a stored procedure to prepare data, and then return the data with a VIEW.
Issue code: 905 | Number of occurrences: 8 | Estimated complexity: Simple
Documentation references: https://dev.mysql.com/doc/refman/5.7/en/create-view.html
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_RptSociosRegistrados: 2782:2868
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_RptSociosRegistrados: 3121:3176
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_RptSociosRegistradosGrid: 2088:2174
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_RptSociosRegistradosGrid: 2427:2482
Databases.ADIDAS.Schemas.dbo.Procedures.ReporteFacturacionActualizado150: 1421:1577
+3 more
Issue 731: MySQL doesn't support this construction. A manual conversion is required
Recommended action: Try converting the WITH(query) expression to a subquery and use it in a SELECT query.
Issue code: 731 | Number of occurrences: 1 | Estimated complexity: Complex
Databases.ADIDAS.Schemas.dbo.Procedures.RPT_Intranet_Weekly: 1369:1700
Issue 780: This syntactic element conversion is not supported yet
Recommended action: Perform a manual conversion.
Issue code: 780 | Number of occurrences: 2 | Estimated complexity: Complex
Databases.ADIDAS.Schemas.dbo.Procedures.SetCargaMasivaFile: 157:365
Databases.ADIDAS.Schemas.dbo.Procedures.cargaZonasEstablecimiento: 446:664
AWS Schema Conversion Tool Version 1.0.642 Page 5 of 7
11/10/2020 1:01PM
Database migration assessment report
Source database: ADIDAS.dbo.Prueba@localhost\SQLEXPRESS\localhost\SQLEXPRESS:1433
Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 13:48:23
Copyright (C) 2019 Microsoft Corporation
Express Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 19041: )
Case sensitivity: OFF
Issue 811: Unable to convert functions
Recommended action: Create a user-defined function.
Issue code: 811 | Number of occurrences: 19 | Estimated complexity: Complex
Databases.ADIDAS.Schemas.dbo.Procedures.AbonoRedencionSocio_TX: 1236:1276
Databases.ADIDAS.Schemas.dbo.Procedures.AbonoRedencionSocio_TX: 1471:1512
Databases.ADIDAS.Schemas.dbo.Procedures.AbonoRedencionSocio_TX: 2292:2330
Databases.ADIDAS.Schemas.dbo.Procedures.AbonoRedencionSocio_TX: 2526:2623
Databases.ADIDAS.Schemas.dbo.Procedures.AbonoRedencionSocio_TX: 2584:2622
+14 more
Issue 904: Unable to convert system objects
Recommended action: Perform a manual conversion.
Issue code: 904 | Number of occurrences: 6 | Estimated complexity: Complex
Databases.ADIDAS.Schemas.dbo.Procedures.B2B_CreaCuentaSocio: 406:493
Databases.ADIDAS.Schemas.dbo.Procedures.CreaCuentaSocio_A: 931:1020
Databases.ADIDAS.Schemas.dbo.Procedures.RPT_sp_unallocated_space: 1069:1080
Databases.ADIDAS.Schemas.dbo.Procedures.RPT_sp_unallocated_space: 1505:1518
Databases.ADIDAS.Schemas.dbo.Procedures.RPT_sp_unallocated_space: 1527:1546
+1 more
Issue 9996: Internal Converter error occurred
Recommended action: Please submit report to developers.
Issue code: 9996 | Number of occurrences: 45 | Estimated complexity: Complex
Databases.ADIDAS.Schemas.dbo.Procedures.AbonoRedencionSocio_TX: 830:5287
Databases.ADIDAS.Schemas.dbo.Procedures.AbonoRedencionSocio_TX: 4938:4963
Databases.ADIDAS.Schemas.dbo.Procedures.AbonoRedencionSocio_TX: 5086:5113
Databases.ADIDAS.Schemas.dbo.Procedures.AbonoRedencionSocio_TX: 5218:5234
Databases.ADIDAS.Schemas.dbo.Procedures.AbonoRedencionSocio_TX: 5238:5259
+40 more
Scalar function Changes
Not all scalar functions can be converted automatically. You'll need to address these issues manually.
Issue 823: MySQL doesn't support table hints in DML statements
Recommended action: Use MySQL methods of performance tuning.
Issue code: 823 | Number of occurrences: 3 | Estimated complexity: Simple
Databases.ADIDAS.Schemas.dbo.SQL scalar functions.GetTerritorios: 1159:1170
Databases.ADIDAS.Schemas.dbo.SQL scalar functions.TraeProductosCanjeados: 700:712
Databases.ADIDAS.Schemas.dbo.SQL scalar functions.TraeProductosCanjeados: 798:809
Table-valued function Changes
AWS Schema Conversion Tool Version 1.0.642 Page 6 of 7
11/10/2020 1:01PM
Database migration assessment report
Source database: ADIDAS.dbo.Prueba@localhost\SQLEXPRESS\localhost\SQLEXPRESS:1433
Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 13:48:23
Copyright (C) 2019 Microsoft Corporation
Express Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 19041: )
Case sensitivity: OFF
Not all table-valued functions can be converted automatically. You'll need to address these issues manually.
Issue 696: MySQL doesn't support an Identity column with seed and increment
Recommended action: Perform a manual conversion.
Issue code: 696 | Number of occurrences: 2 | Estimated complexity: Simple
Databases.ADIDAS.Schemas.dbo.SQL table-valued functions.B2B_split_to_table_Canje: 473:486
Databases.ADIDAS.Schemas.dbo.SQL table-valued functions.split_to_table: 509:522
Issue 697: MySQL doesn't support an Identity column outside a primary key
Recommended action: Perform a manual conversion.
Issue code: 697 | Number of occurrences: 2 | Estimated complexity: Simple
Databases.ADIDAS.Schemas.dbo.SQL table-valued functions.B2B_split_to_table_Canje: 473:486
Databases.ADIDAS.Schemas.dbo.SQL table-valued functions.split_to_table: 509:522
AWS Schema Conversion Tool Version 1.0.642 Page 7 of 7
11/10/2020 1:01PM
