Sfrgttk

Do you waste sorcery points if you try to apply metamagic to a spell from a scroll but fail to cast it?

Confusion over Hunter with Crossbow Expert and Giant Killer

Why didn’t Eve recognize the little cockroach as a living organism?

Why is the sun approximated as a black body at ~ 5800 K?

Sound waves in different octaves

How to I force windows to use a specific version of SQLCMD?

Possible Eco thriller, man invents a device to remove rain from glass

How do I fix the group tension caused by my character stealing and possibly killing without provocation?

Make a border of symbols in Gimp

Deciphering cause of death?

Overlapping circles covering polygon

How to get directions in deep space?

ContourPlot — How do I color by contour curvature?

Would this string work as string?

El Dorado Word Puzzle II: Videogame Edition

Why does a 97 / 92 key piano exist by Bösendorfer?

What should be the ideal length of sentences in a blog post for ease of reading?

Proving a complicated language is not a CFL

Purpose of creating non root user

What happens if I try to grapple mirror image?

Pre-Employment Background Check With Consent For Future Checks

Can I say "fingers" when referring to toes?

Why does the Persian emissary display a string of crowned skulls?

Check if object is null and return null

Escape from Alcatraz: SqlAnywhere to MSSQL

Migrating from Oracle to MySQL using WorkBench Migration ToolSqlAnywhere 12- service started but stoppedHow to get list of enabled/disabled features of SQLAnywhereSQLAnywhere: Failure on creation of procedureSQLAnywhere: Switch to choose between WATCOM and T-SQL?SQLAnywhere: Cursor getting closed after executing a DDL statementSQLAnywhere: Rename Foreign Key or Primary KeySQLAnywhere: How to configure length of message output to console/client when using isqlSQLAnywhere: How to determine which path delimiter is used on database?SQLAnywhere: How to import empty columns (date)

1

Is there a migration tool that actually works for SAP SqlAnywhere 17 to MSSQL (any recent version)?

Searching for "sqlanywhere mssql migration" yields a variety of hits including SQL Server Migration Assistance (SSMA) but all of the tools I have tried — various free and some trials of commercial offerings — all failed to handle the following test (assume T is a real table with columns A and B):

SELECT A, B + 'X' AS B1 FROM T GROUP BY B1

SqlAnywhere permits this but on MSSQL the symbol B1 is not in scope in the GROUP BY clause, and the query must be transformed as follows:

SELECT * FROM (SELECT A, B + 'X' AS B1 FROM T) AS T1 GROUP BY B1

I wasn't even able to test SSMA. It is available for a range of platforms including Sybase ASE but is not compatible with the database formerly known as Sybase SqlAnywhere and now titled SAP SqlAnywhere. I've tried this, and it is not interested in using my SqlAnywhere ODBC drivers.

If there isn't an out of the box migration tool then is there anything that can transform syntax? In some ways this would be even more helpful than a migration tool because our applications are riddled with queries that exhibit this particular incompatibility. I seriously considered writing a transformation myself but quickly realised that SQL syntax is hideously complex and idiosyncratic.

sql-server migration syntax sybase-sql-anywhere

share|improve this question

edited 1 min ago

Peter Wone

asked 19 hours ago

Peter WonePeter Wone

1564

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This will likely be closed as it's a shopping list question, however, I suggest you reach out to Microsoft Directly in this case. If you have an MSDN license, you should be able to take advantage of their Concierge Chat and see if they have any similar tools available. They may not, but that'll likely be your best bet.
  
  – John Eisbrener
  8 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  As it happens I think I do have what passes for an MSDN licence in these days of docs.microsoft.com -- a Visual Studio subscription, so I'll give that a whirl. But if questions like this aren't permitted how are people expected to deal with this kind of situation? This isn't I'm too lazy to run a search for "SqlAnywhere mssql migration tool", land on the SSMA site, read it and weep, then download it and try anyway.
  
  – Peter Wone
  29 mins ago
  

  
  
  
  

add a comment | 

1

Is there a migration tool that actually works for SAP SqlAnywhere 17 to MSSQL (any recent version)?

Searching for "sqlanywhere mssql migration" yields a variety of hits including SQL Server Migration Assistance (SSMA) but all of the tools I have tried — various free and some trials of commercial offerings — all failed to handle the following test (assume T is a real table with columns A and B):

SELECT A, B + 'X' AS B1 FROM T GROUP BY B1

SqlAnywhere permits this but on MSSQL the symbol B1 is not in scope in the GROUP BY clause, and the query must be transformed as follows:

SELECT * FROM (SELECT A, B + 'X' AS B1 FROM T) AS T1 GROUP BY B1

I wasn't even able to test SSMA. It is available for a range of platforms including Sybase ASE but is not compatible with the database formerly known as Sybase SqlAnywhere and now titled SAP SqlAnywhere. I've tried this, and it is not interested in using my SqlAnywhere ODBC drivers.

If there isn't an out of the box migration tool then is there anything that can transform syntax? In some ways this would be even more helpful than a migration tool because our applications are riddled with queries that exhibit this particular incompatibility. I seriously considered writing a transformation myself but quickly realised that SQL syntax is hideously complex and idiosyncratic.

sql-server migration syntax sybase-sql-anywhere

share|improve this question

edited 1 min ago

Peter Wone

asked 19 hours ago

Peter WonePeter Wone

1564

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This will likely be closed as it's a shopping list question, however, I suggest you reach out to Microsoft Directly in this case. If you have an MSDN license, you should be able to take advantage of their Concierge Chat and see if they have any similar tools available. They may not, but that'll likely be your best bet.
  
  – John Eisbrener
  8 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  As it happens I think I do have what passes for an MSDN licence in these days of docs.microsoft.com -- a Visual Studio subscription, so I'll give that a whirl. But if questions like this aren't permitted how are people expected to deal with this kind of situation? This isn't I'm too lazy to run a search for "SqlAnywhere mssql migration tool", land on the SSMA site, read it and weep, then download it and try anyway.
  
  – Peter Wone
  29 mins ago
  

  
  
  
  

add a comment | 

Is there a migration tool that actually works for SAP SqlAnywhere 17 to MSSQL (any recent version)?

Searching for "sqlanywhere mssql migration" yields a variety of hits including SQL Server Migration Assistance (SSMA) but all of the tools I have tried — various free and some trials of commercial offerings — all failed to handle the following test (assume T is a real table with columns A and B):

SELECT A, B + 'X' AS B1 FROM T GROUP BY B1

SqlAnywhere permits this but on MSSQL the symbol B1 is not in scope in the GROUP BY clause, and the query must be transformed as follows:

SELECT * FROM (SELECT A, B + 'X' AS B1 FROM T) AS T1 GROUP BY B1

I wasn't even able to test SSMA. It is available for a range of platforms including Sybase ASE but is not compatible with the database formerly known as Sybase SqlAnywhere and now titled SAP SqlAnywhere. I've tried this, and it is not interested in using my SqlAnywhere ODBC drivers.

If there isn't an out of the box migration tool then is there anything that can transform syntax? In some ways this would be even more helpful than a migration tool because our applications are riddled with queries that exhibit this particular incompatibility. I seriously considered writing a transformation myself but quickly realised that SQL syntax is hideously complex and idiosyncratic.

sql-server migration syntax sybase-sql-anywhere

share|improve this question

edited 1 min ago

Peter Wone

asked 19 hours ago

Peter WonePeter Wone

1564

SELECT A, B + 'X' AS B1 FROM T GROUP BY B1

SELECT * FROM (SELECT A, B + 'X' AS B1 FROM T) AS T1 GROUP BY B1

share|improve this question

edited 1 min ago

Peter Wone

asked 19 hours ago

Peter WonePeter Wone

1564

share|improve this question

edited 1 min ago

Peter Wone

asked 19 hours ago

Peter WonePeter Wone

1564

asked 19 hours ago

Peter WonePeter Wone

1564

asked 19 hours ago

Peter WonePeter Wone

1564