Database migration assessment report
Source database: [Link]@localhost\SQLEXPRESS\localhost\SQLEXPRESS:1433
Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 [Link]
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: [Link]@localhost\SQLEXPRESS\localhost\SQLEXPRESS:1433
Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 [Link]
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
[Link].ix_Facturas2.[Link]
[Link].ix_Facturas2.[Link]
[Link].ix_Facturas2.[Link]
[Link].ix_Facturas2.[Link]
[Link].ix_Facturas2.[Link]
+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: [Link]@localhost\SQLEXPRESS\localhost\SQLEXPRESS:1433
Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 [Link]
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: [Link]
[Link].B2B_InsertaReglas: 334:398
[Link].B2B_InsertaReglas: 1419:1480
[Link].B2B_PremiaFacturas: 477:506
[Link].B2B_PremiaFacturas: 1608:1646
[Link].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
[Link].AbonoRedencionSocio_TX: 936:940
[Link].AbonoRedencionSocio_TX: 948:952
[Link].AbonoRedencionSocio_TX: 968:981
[Link].AbonoRedencionSocio_TX: 989:993
[Link].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
[Link].B2B_BuscaSocios: 4411:4429
[Link].B2B_BuscaSociosPaginacion: 5328:5346
[Link].B2B_BuscaUsuario: 2031:2046
[Link].B2B_ConsultaUsuario: 2358:2373
[Link].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
[Link].AbonoRedencionSocio_TX: 834:851
[Link].B2B_ConsultaEdodeCuenta: 386:403
[Link].B2B_InsertaComentarios: 450:465
[Link].B2B_RptFacturas: 120:135
[Link].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: [Link]@localhost\SQLEXPRESS\localhost\SQLEXPRESS:1433
Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 [Link]
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: [Link]
[Link].sp_upgraddiagrams: 394:405
[Link].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
[Link]: 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
[Link].B2B_TraeRankingCacs_Tx: 671:678
[Link].ConsultaProductosPremiacion_Tx: 1860:1867
[Link].ConsultaProductosPremiacion_Tx: 2724:2731
[Link]: 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
[Link].B2B_BuscaSocios: 4394:4408
[Link].B2B_BuscaSociosPaginacion: 5311:5325
[Link].B2B_BuscaUsuario: 2012:2026
[Link].ConsultaProductosPremiacion_Tx: 7527:7540
[Link]: 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
[Link].B2B_InsertaReglas: 525:545
[Link].B2B_InsertaReglas: 568:585
[Link].B2B_RptFacturas: 1440:1460
[Link].B2B_RptFacturas: 1466:1483
[Link].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: [Link]@localhost\SQLEXPRESS\localhost\SQLEXPRESS:1433
Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 [Link]
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
[Link].B2B_Acceso_tx: 823:832
[Link].B2B_Acceso_txStore: 781:790
[Link].B2B_AddMensajesApoyo: 506:515
[Link].B2B_ConsutaCargaAvancesRNK: 409:418
[Link].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
[Link].ActualizaProducto_tx: 681:692
[Link].B2B_Acceso_tx: 930:941
[Link].B2B_Acceso_tx: 1055:1066
[Link].B2B_Acceso_tx: 1861:1872
[Link].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: [Link]
[Link].B2B_RptSociosRegistrados: 2782:2868
[Link].B2B_RptSociosRegistrados: 3121:3176
[Link].B2B_RptSociosRegistradosGrid: 2088:2174
[Link].B2B_RptSociosRegistradosGrid: 2427:2482
[Link].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
[Link].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
[Link]: 157:365
[Link]: 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: [Link]@localhost\SQLEXPRESS\localhost\SQLEXPRESS:1433
Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 [Link]
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
[Link].AbonoRedencionSocio_TX: 1236:1276
[Link].AbonoRedencionSocio_TX: 1471:1512
[Link].AbonoRedencionSocio_TX: 2292:2330
[Link].AbonoRedencionSocio_TX: 2526:2623
[Link].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
[Link].B2B_CreaCuentaSocio: 406:493
[Link].CreaCuentaSocio_A: 931:1020
[Link].RPT_sp_unallocated_space: 1069:1080
[Link].RPT_sp_unallocated_space: 1505:1518
[Link].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
[Link].AbonoRedencionSocio_TX: 830:5287
[Link].AbonoRedencionSocio_TX: 4938:4963
[Link].AbonoRedencionSocio_TX: 5086:5113
[Link].AbonoRedencionSocio_TX: 5218:5234
[Link].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
[Link] scalar [Link]: 1159:1170
[Link] scalar [Link]: 700:712
[Link] scalar [Link]: 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: [Link]@localhost\SQLEXPRESS\localhost\SQLEXPRESS:1433
Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 [Link]
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
[Link] table-valued functions.B2B_split_to_table_Canje: 473:486
[Link] 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
[Link] table-valued functions.B2B_split_to_table_Canje: 473:486
[Link] 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
