SAP’s Advanced SQL Migration tool greatly simplifies migration of custom applications to SAP, removing as much as 90% of complexities. Version 3 has just been released.
SAP Advanced SQL Migration supports the following source DBMS types:
• Oracle; versions 9, 10, 11
• Microsoft SQL Server; version 2000s – 2012
• IBM DB2 UDB for LUW; version 9.x (NB: PL/SQL-compatible extensions are not actively migrated, although some aspects may be converted correctly)
• Teradata, version 14 or later Note: Teradata can only be migrated to SAP Hana
For all of these source DBMS types, later (or earlier) versions than listed above have not been actively tested. The migration tool may however still work for such versions, or work partially.
Currently, the following target DBMS types and -versions are supported:
- • SAP Hana 2 SP03 Rev31 (or later) – generating Hana SQL/SQLScript syntax
- • SAP ASE version 16 SP03 (or later) – generating ASE T-SQL syntax
- • SAP IQ version 16.1 (or later) – generating Watcom SQL syntax
- • SAP SQL Anywhere version 17 – generating Watcom SQL syntax
Find out more about Frequently Asked Questions.
This excellent tool is available for use only by SAP and its partners. Get in touch to explore how it could help your migration project.
ASE Platform Edition now includes IQ Multiplex at no extra cost.
This is just one of the many otherwise chargeable options that come as standard with ASE Platform Edition.
In SAP Replication Server releases prior to 16.0 SP03 PL04, the replication involving multiple databases was resource intensive and complex. With automatic memory management enhanced in 16.0 SP03 PL04, SAP Replication Server supports you to replicate multiple databases (certificated with 20) in parallel with the simpler configuration steps and lower total cost of ownership (TCO). Thus, with this feature enabled, SAP Replication Server performs much better when you manage multiple pairs of databases in the HADR and non-HADR environments.
Find out more
SAP are running a series of SAP ASE seminars looking at the 4 key strategic thrusts of development : XOLTP, Cloud & Virtualization, Data Center Operations (Security, Availability, etc.) and integration with SAP HANA.
SAP ASE 16 Feature Overview and Roadmap: May 16, 1500 HRS BST
Accelerate your ASE based data-driven insights to near real-time with HANA: June 21, 1500 HRS BST
ASE Cloud Overview including Subscription Model Support: July 11, 1500 HRS BST
More info and to book
SAP Adaptive Server Enterprise 16.0 SP03 is now available for SAP Business Suite and other SAP Applications. This release brings you an In-Memory Row-Store, a new Secure Store, MVCC, 3-note High Availability + DR and much more. More info.
SAP have launched a comprehensive guide to setting up ASE on AWS.
SAP has launched extreme transactional processing capabilities on AWS marketplace with new hourly (on demand) pricing for SAP ASE. SAP ASE public cloud edition is the Enterprise Edition plus advanced options including: Security, Encryption, Compression, Partitioning and Workload Optimisation.
We are currently testing out the new service – watch this space for our reviews.
The SAP® Advanced SQL Migration tool has been developed to meet one one of the key challenges of database application migration, SQL code Conversion. SAP® Advanced SQL Migration tool automatically converts SQL queries, stored procedures, and database schema to reduce the effort, complexity and risk of migrating your custom applications to SAP database platforms. More
Although it is not available for direct use by customers, it is available through SAP partners such as J2. Get in touch to find out how it could be used to help your conversion.
A great new way to get automatic SAP data management updates – subscribe to the SAP WhatsApp Data Management Channel
SAP are running a series of webcasts to introduce updates to SAP ASE and Replication Server.
Click here for more information,to register or to listen to webcasts already broadcast.
Find out everything you need to know about the latest release of Replication Server on the SAP Help Portal.
Save the date! Techselect 2017 will take place 17 October at the America Square Conference Centre, London.
According to Gartner, SAP is a market share leader in the combined market categories supporting enterprise information management — data integration, data quality, and master data management.
Gartner: SAP is database leader
A five-year ROI of 251%. Reductions in unplanned downtime of 95%. Yearly revenue increases of $2.46 million. According to IDC, these are just some of the benefits achieved by organizations running SAP Adaptive Server Enterprise – the database for transaction processing in the digital economy. Read the white paper.