The SAP Advanced SQL Migration tool has supported SQL dialect conversion from Microsoft SQL Server to SAP Hana since Hana support was first released, and the results are usually pretty good. However, there is a non-trivial aspects to this conversion ...
Today we released version 3.4 of the SAP Advanced SQL Migration tool. If you are a registered user .of the migration tool, you will receive this new release in the coming days.
Version 3.4 has two big new features:
Support for converting from Net...
Quite some time ago, I posted some blogs about the SAP Advanced SQL Migration tool (originally called 'Exodus'). Lots of things have happened in the mean time -- but it remained quiet on the blog front.
Well, Quiet No Longer!
In the weeks/months ah...
Below are some older (though still relevant) blog posts about the SAP Advanced SQL Migration tool (formerly named 'Exodus'). More recent blog posts are here.
Contents:
Using the SAP Advanced SQL Migration DBMS migration tool for Pre-Migration...
What makes you think 1=1 would not work in Hana? It does -- in fact, you can just as well use 2=2 or 0=0 (or 2 = 1+1 if you're adventurous). Or, as already noted, avoid the predicate completely. Since the specific Hana SQL dialect variation was not m...
In case you need to convert something more complex, like table definitions that have column defaults with built-in function calls, views (which can be arbitrarily large and complex), or SQL statements in general (incl. SQL stored procedures), then co...
I don't have a document, but I run the global technology program for the SAP Advanced SQL Migration tool, which supports migration from MSSQL Server to ASE. Unless you are an SAP Partner Edge partner, I cannot currently give you a copy of this tool. ...
To create a SQL Anywhere table in IQ, add "IN SYSTEM", e.g. CREATE TABLE mytab (a int) IN SYSTEM. This creates the table in the SQL Anywhere area of IQ which serves as a catalog for IQ. You can use many SQL Anywhere features for these tables that can...
