MS Access SQL to T-SQL Convertor

Question

Is there a tool that will convert MS Access SQL to T-SQL?

Answer 1

For my queries, I would prefer to do them manually rather than let the tool do the translation.

I don't know a tool, but here is a decent cheatsheet

http://weblogs.sqlteam.com/jeffs/archive/2007/03/30/Quick-Access-JET-SQL-to-T-SQL-Cheatsheet.aspx

Answer 2

Just completed my first Access to SQL database conversion. Here I used:

MS SQL Server Migration Assistant for the entire table structure and data. Despite the many reports of naming conventions, all data and structures are transmitted without problems.

SSMA , , / . MS SQL Management Studio Access T-SQL, :

, Key, Status, ID, [].
IIF CASE, SQL Server 2012 .
Nz ISNULL ( Raj More, ).
, , , . , - : Round() truncate float ( , ). , Access ...

SQL Studio: Select * , where, . , *, .
, , . -, , , , .:)