Database migration assessment report
Source database:
Eadpi.dbo.root@sqlserver2012ee.c1sleazgkfyg.eu-west-1.rds.amazonaws.com\sqlserver2012ee.c1sleazgk
fyg.eu-west-1.rds.amazonaws.com:1433
Microsoft SQL Server 2012 (SP4-GDR) (KB4532098) - 11.0.7493.4 (X64) Dec 24 2019 19:33:24
Copyright (c) Microsoft Corporation
Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 <X64> (Build 14393: ) (Hypervisor)
Case sensitivity: OFF
Warning
We found that your source database may be configured not in correct way or you have not enough privileges for
reading all necessary metadata. Please check your configuration and run report again. For more details please
review help documentation.
List of Action Items to review:
1. Unable to resolve objects - 141 occurrences
Executive summary
We completed the analysis of your Microsoft SQL Server source database and estimate that 100% of the
database storage objects and 44% of database code objects can be converted automatically or with minimal
changes if you select Amazon RDS for PostgreSQL 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 77% (based on # lines of
code) of your code can be converted to Amazon RDS for PostgreSQL automatically. To complete the migration,
we recommend 355 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
PostgreSQL
Of the total 27 database storage object(s) and 32 database code object(s) in the source database, we identifed
27 (100%) database storage object(s) and 14 (44%) database code object(s) that can be converted to Amazon
RDS for PostgreSQL automatically or with minimal changes.
18 (56%) database code object(s) require 27 complex user action(s) to complete the conversion.
Figure: Conversion statistics for database storage objects
Schema
1
(1: 1/0/0/0)
Table
100% 11
(11: 11/0/0/0)
Constraint
100% 10
(10: 10/0/0/0)
Index
60% 40% 5
(5: 3/2/0/0)
0 10 100
Objects automatically converted Objects with simple actions
Objects with medium-complexity actions Objects with complex actions
AWS Schema Conversion Tool Version 1.0.644 Page 1 of 7
02/19/2021 5:26AM
Database migration assessment report
Source database:
Eadpi.dbo.root@sqlserver2012ee.c1sleazgkfyg.eu-west-1.rds.amazonaws.com\sqlserver2012ee.c1sleazgk
fyg.eu-west-1.rds.amazonaws.com:1433
Microsoft SQL Server 2012 (SP4-GDR) (KB4532098) - 11.0.7493.4 (X64) Dec 24 2019 19:33:24
Copyright (c) Microsoft Corporation
Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 <X64> (Build 14393: ) (Hypervisor)
Case sensitivity: OFF
Figure: Conversion statistics for database code objects
Procedure
19% 26% 55% 31
(31: 6/8/0/17)
Table-valued function
1
(1: 0/0/0/1)
0 10 100
Objects automatically converted Objects with simple actions
Objects with medium-complexity actions Objects with complex actions
Detailed recommendations for Amazon RDS for PostgreSQL migrations
If you migrate your Microsoft SQL Server database to Amazon RDS for PostgreSQL, 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 7681: PostgreSQL doesn't support clustered indexes
Recommended action: Use non-clustered indexes.
Issue code: 7681 | Number of occurrences: 2 | Estimated complexity: Simple
Databases.Eadpi.Schemas.dbo.Tables.MasterData_Conditions.Indexes.IX_MasterData_Conditions
Databases.Eadpi.Schemas.dbo.Tables.MasterData_ShipToParty.Indexes.IX_MasterData_ShipToParty
Code object actions
Procedure Changes
Not all procedures can be converted automatically. You'll need to address these issues manually.
Issue 7646: Automatic conversion of collation is not supported
Recommended action: You must use the COLLATION settings that were assigned when the database was
created.
Issue code: 7646 | Number of occurrences: 18 | Estimated complexity: Simple
AWS Schema Conversion Tool Version 1.0.644 Page 2 of 7
02/19/2021 5:26AM
Database migration assessment report
Source database:
Eadpi.dbo.root@sqlserver2012ee.c1sleazgkfyg.eu-west-1.rds.amazonaws.com\sqlserver2012ee.c1sleazgk
fyg.eu-west-1.rds.amazonaws.com:1433
Microsoft SQL Server 2012 (SP4-GDR) (KB4532098) - 11.0.7493.4 (X64) Dec 24 2019 19:33:24
Copyright (c) Microsoft Corporation
Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 <X64> (Build 14393: ) (Hypervisor)
Case sensitivity: OFF
Databases.Eadpi.Schemas.dbo.Procedures.GET_MasterData_FA_SpecialCases_Warning
Databases.Eadpi.Schemas.dbo.Procedures.GET_MasterData_FA_SpecialCases_Warning
Databases.Eadpi.Schemas.dbo.Procedures.GET_MasterData_FA_SpecialCases_Warning
Databases.Eadpi.Schemas.dbo.Procedures.GET_MasterData_FA_SpecialCases_Warning
Databases.Eadpi.Schemas.dbo.Procedures.GET_MasterData_FA_SpecialCases_Warning
+13 more
Issue 7663: 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: 7663 | Number of occurrences: 117 | Estimated complexity: Simple
Databases.Eadpi.Schemas.dbo.Procedures.GET_MasterData_FA_SpecialCases_Warning
Databases.Eadpi.Schemas.dbo.Procedures.GET_MasterData_FA_SpecialCases_Warning
Databases.Eadpi.Schemas.dbo.Procedures.GET_MasterData_FA_SpecialCases_Warning
Databases.Eadpi.Schemas.dbo.Procedures.GET_MasterData_FA_SpecialCases_Warning
Databases.Eadpi.Schemas.dbo.Procedures.GET_MasterData_FA_SpecialCases_Warning
+112 more
Issue 7674: Unable to convert statement
Recommended action: Perform a manual conversion.
Issue code: 7674 | Number of occurrences: 14 | Estimated complexity: Simple
Databases.Eadpi.Schemas.dbo.Procedures.DELETE_MasterData_FA_SpecialCases
Databases.Eadpi.Schemas.dbo.Procedures.GET_Max_LocalReferenceNumber
Databases.Eadpi.Schemas.dbo.Procedures.INSERT_DeliveryCollection
Databases.Eadpi.Schemas.dbo.Procedures.INSERT_DeliveryCollection_CF
Databases.Eadpi.Schemas.dbo.Procedures.INSERT_DeliveryConditions
+9 more
Issue 7795: PostgreSQL in operations with strings is case-sensitive. Check the result of the
conversion
Recommended action: Check the string comparison.
Issue code: 7795 | Number of occurrences: 46 | Estimated complexity: Simple
Databases.Eadpi.Schemas.dbo.Procedures.DELETE_MasterData_FA_SpecialCases
Databases.Eadpi.Schemas.dbo.Procedures.GET_MasterData_FA_SpecialCases_Warning
Databases.Eadpi.Schemas.dbo.Procedures.GET_MasterData_FA_SpecialCases_Warning
Databases.Eadpi.Schemas.dbo.Procedures.GET_MasterData_FA_SpecialCases_Warning
Databases.Eadpi.Schemas.dbo.Procedures.GET_MasterData_FA_SpecialCases_Warning
+41 more
Issue 7807: Unable to convert a transaction management command
Recommended action: Perform a manual conversion.
Issue code: 7807 | Number of occurrences: 31 | Estimated complexity: Simple
AWS Schema Conversion Tool Version 1.0.644 Page 3 of 7
02/19/2021 5:26AM
Database migration assessment report
Source database:
Eadpi.dbo.root@sqlserver2012ee.c1sleazgkfyg.eu-west-1.rds.amazonaws.com\sqlserver2012ee.c1sleazgk
fyg.eu-west-1.rds.amazonaws.com:1433
Microsoft SQL Server 2012 (SP4-GDR) (KB4532098) - 11.0.7493.4 (X64) Dec 24 2019 19:33:24
Copyright (c) Microsoft Corporation
Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 <X64> (Build 14393: ) (Hypervisor)
Case sensitivity: OFF
Databases.Eadpi.Schemas.dbo.Procedures.DELETE_MasterData_FA_SpecialCases
Databases.Eadpi.Schemas.dbo.Procedures.DELETE_MasterData_FA_SpecialCases
Databases.Eadpi.Schemas.dbo.Procedures.GET_Max_LocalReferenceNumber
Databases.Eadpi.Schemas.dbo.Procedures.INSERT_DeliveryCollection
Databases.Eadpi.Schemas.dbo.Procedures.INSERT_DeliveryCollection
+26 more
Issue 7810: PostgreSQL doesn't support the SET NOCOUNT
Recommended action: If need try another way to send message back to the client application.
Issue code: 7810 | Number of occurrences: 15 | Estimated complexity: Simple
Databases.Eadpi.Schemas.dbo.Procedures.DELETE_MasterData_FA_SpecialCases
Databases.Eadpi.Schemas.dbo.Procedures.GET_Max_LocalReferenceNumber
Databases.Eadpi.Schemas.dbo.Procedures.GET_OD_EADPI_vs_SAP
Databases.Eadpi.Schemas.dbo.Procedures.INSERT_DeliveryCollection
Databases.Eadpi.Schemas.dbo.Procedures.INSERT_DeliveryCollection_CF
+10 more
Issue 7823: PostgreSQL doesn't support table hints in DML statements
Recommended action: Use PostgreSQL methods of performance tuning.
Issue code: 7823 | Number of occurrences: 10 | Estimated complexity: Simple
Databases.Eadpi.Schemas.dbo.Procedures.GET_MasterData_FA_SpecialCases_Warning
Databases.Eadpi.Schemas.dbo.Procedures.GET_MasterData_FA_SpecialCases_Warning
Databases.Eadpi.Schemas.dbo.Procedures.GET_OD_List
Databases.Eadpi.Schemas.dbo.Procedures.INSERT_DeliveryCollection
Databases.Eadpi.Schemas.dbo.Procedures.INSERT_DeliveryCollection
+5 more
Issue 7834: Check conversion @@rowcount function
Recommended action: Please review generated code and modify it if necessary.
Issue code: 7834 | Number of occurrences: 8 | Estimated complexity: Simple
Databases.Eadpi.Schemas.dbo.Procedures.DELETE_MasterData_FA_SpecialCases
Databases.Eadpi.Schemas.dbo.Procedures.INSERT_MasterData_FA_SpecialCases
Databases.Eadpi.Schemas.dbo.Procedures.UPDATE_Delivery_Header_LocalReferenceNumber
Databases.Eadpi.Schemas.dbo.Procedures.UPDATE_MasterData_FA_SpecialCases
Databases.Eadpi.Schemas.dbo.Procedures.UPDATE_MasterData_ShipToParty
+3 more
Issue 7922: PostgreSQL and MS SQL Server handle errors differently, so check result of
code conversion
Recommended action: Please review generated code and modify it if necessary.
Issue code: 7922 | Number of occurrences: 20 | Estimated complexity: Simple
Databases.Eadpi.Schemas.dbo.Procedures.DELETE_MasterData_FA_SpecialCases
AWS Schema Conversion Tool Version 1.0.644 Page 4 of 7
02/19/2021 5:26AM
Database migration assessment report
Source database:
Eadpi.dbo.root@sqlserver2012ee.c1sleazgkfyg.eu-west-1.rds.amazonaws.com\sqlserver2012ee.c1sleazgk
fyg.eu-west-1.rds.amazonaws.com:1433
Microsoft SQL Server 2012 (SP4-GDR) (KB4532098) - 11.0.7493.4 (X64) Dec 24 2019 19:33:24
Copyright (c) Microsoft Corporation
Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 <X64> (Build 14393: ) (Hypervisor)
Case sensitivity: OFF
Databases.Eadpi.Schemas.dbo.Procedures.GET_Max_LocalReferenceNumber
Databases.Eadpi.Schemas.dbo.Procedures.GET_OD_EADPI_vs_SAP
Databases.Eadpi.Schemas.dbo.Procedures.GET_OD_XML_TO_WEB_SAVED
Databases.Eadpi.Schemas.dbo.Procedures.INSERT_DeliveryCollection
+15 more
Issue 7808: Unparsed SQL
Recommended action: Perform a manual conversion.
Issue code: 7808 | Number of occurrences: 2 | Estimated complexity: Complex
Databases.Eadpi.Schemas.dbo.Procedures.GET_OD_XML
Databases.Eadpi.Schemas.dbo.Procedures.GET_OD_XML_TO_WEB
Issue 7811: Unable to convert functions
Recommended action: Create a user-defined function.
Issue code: 7811 | Number of occurrences: 19 | Estimated complexity: Complex
Databases.Eadpi.Schemas.dbo.Procedures.DELETE_MasterData_FA_SpecialCases
Databases.Eadpi.Schemas.dbo.Procedures.INSERT_DeliveryCollection
Databases.Eadpi.Schemas.dbo.Procedures.INSERT_DeliveryCollection
Databases.Eadpi.Schemas.dbo.Procedures.INSERT_DeliveryCollection_CF
Databases.Eadpi.Schemas.dbo.Procedures.INSERT_DeliveryCollection_CF
+14 more
Issue 9996: Internal Converter error occurred
Recommended action: Please submit report to developers.
Issue code: 9996 | Number of occurrences: 6 | Estimated complexity: Complex
Databases.Eadpi.Schemas.dbo.Procedures.GET_MasterData_FA_SpecialCases_Warning
Databases.Eadpi.Schemas.dbo.Procedures.GET_OD_EADPI_vs_SAP
Databases.Eadpi.Schemas.dbo.Procedures.INSERT_DeliveryCollection
Databases.Eadpi.Schemas.dbo.Procedures.INSERT_DeliveryCollection_CF
Databases.Eadpi.Schemas.dbo.Procedures.UPDATE_DeliveryItems
+1 more
Table-valued function Changes
Not all table-valued functions can be converted automatically. You'll need to address these issues manually.
Issue 7646: Automatic conversion of collation is not supported
Recommended action: You must use the COLLATION settings that were assigned when the database was
created.
Issue code: 7646 | Number of occurrences: 10 | Estimated complexity: Simple
Databases.Eadpi.Schemas.dbo.SQL table-valued functions.fnOutboundDeliveryItems
Databases.Eadpi.Schemas.dbo.SQL table-valued functions.fnOutboundDeliveryItems
AWS Schema Conversion Tool Version 1.0.644 Page 5 of 7
02/19/2021 5:26AM
Database migration assessment report
Source database:
Eadpi.dbo.root@sqlserver2012ee.c1sleazgkfyg.eu-west-1.rds.amazonaws.com\sqlserver2012ee.c1sleazgk
fyg.eu-west-1.rds.amazonaws.com:1433
Microsoft SQL Server 2012 (SP4-GDR) (KB4532098) - 11.0.7493.4 (X64) Dec 24 2019 19:33:24
Copyright (c) Microsoft Corporation
Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 <X64> (Build 14393: ) (Hypervisor)
Case sensitivity: OFF
Databases.Eadpi.Schemas.dbo.SQL table-valued functions.fnOutboundDeliveryItems
Databases.Eadpi.Schemas.dbo.SQL table-valued functions.fnOutboundDeliveryItems
Databases.Eadpi.Schemas.dbo.SQL table-valued functions.fnOutboundDeliveryItems
+5 more
Issue 7659: The scope table-variables and temporary tables is different. You must apply
manual conversion, if you are using recursion
Recommended action: Perform a manual conversion.
Issue code: 7659 | Number of occurrences: 1 | Estimated complexity: Simple
Databases.Eadpi.Schemas.dbo.SQL table-valued functions.fnOutboundDeliveryItems
Issue 7663: 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: 7663 | Number of occurrences: 24 | Estimated complexity: Simple
Databases.Eadpi.Schemas.dbo.SQL table-valued functions.fnOutboundDeliveryItems
Databases.Eadpi.Schemas.dbo.SQL table-valued functions.fnOutboundDeliveryItems
Databases.Eadpi.Schemas.dbo.SQL table-valued functions.fnOutboundDeliveryItems
Databases.Eadpi.Schemas.dbo.SQL table-valued functions.fnOutboundDeliveryItems
Databases.Eadpi.Schemas.dbo.SQL table-valued functions.fnOutboundDeliveryItems
+19 more
Issue 7774: 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: 7774 | Number of occurrences: 4 | Estimated complexity: Simple
Databases.Eadpi.Schemas.dbo.SQL table-valued functions.fnOutboundDeliveryItems
Databases.Eadpi.Schemas.dbo.SQL table-valued functions.fnOutboundDeliveryItems
Databases.Eadpi.Schemas.dbo.SQL table-valued functions.fnOutboundDeliveryItems
Databases.Eadpi.Schemas.dbo.SQL table-valued functions.fnOutboundDeliveryItems
Issue 7795: PostgreSQL in operations with strings is case-sensitive. Check the result of the
conversion
Recommended action: Check the string comparison.
Issue code: 7795 | Number of occurrences: 8 | Estimated complexity: Simple
Databases.Eadpi.Schemas.dbo.SQL table-valued functions.fnOutboundDeliveryItems
Databases.Eadpi.Schemas.dbo.SQL table-valued functions.fnOutboundDeliveryItems
Databases.Eadpi.Schemas.dbo.SQL table-valued functions.fnOutboundDeliveryItems
Databases.Eadpi.Schemas.dbo.SQL table-valued functions.fnOutboundDeliveryItems
Databases.Eadpi.Schemas.dbo.SQL table-valued functions.fnOutboundDeliveryItems
+3 more
AWS Schema Conversion Tool Version 1.0.644 Page 6 of 7
02/19/2021 5:26AM
Database migration assessment report
Source database:
Eadpi.dbo.root@sqlserver2012ee.c1sleazgkfyg.eu-west-1.rds.amazonaws.com\sqlserver2012ee.c1sleazgk
fyg.eu-west-1.rds.amazonaws.com:1433
Microsoft SQL Server 2012 (SP4-GDR) (KB4532098) - 11.0.7493.4 (X64) Dec 24 2019 19:33:24
Copyright (c) Microsoft Corporation
Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 <X64> (Build 14393: ) (Hypervisor)
Case sensitivity: OFF
AWS Schema Conversion Tool Version 1.0.644 Page 7 of 7
02/19/2021 5:26AM
