question

Mario Kolb avatar image
Mario Kolb asked

Tool to convert JET-SQL to T-SQL statements

Hi,

is there a tool to convert JET-SQL to T-SQL statements ? I have a webapplication with lots of statements and don´t want to spend to much time in rewriting the statements manually. Is there any tool that replaces standard functions like substr to charindex or rewrites the statements completely ?

Greetz Mario

t-sqlmicrosoft-access
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
Madhivanan avatar image
Madhivanan answered

I dont know of any tools. Have you tried searching in Google/Bing?

Hints

Access                T-SQL            
IIF                   CASE WHEN...            
MID                   SUBSTRING            
LCASE                 LOWER            
UCASE                 UPPER            
NZ                    ISNULL(col,some value            
.            
.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered
The only tool I know for doing this type of conversion is the MK-I Brain.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.