msaccess to mssql server automatic query conversion

[Anabella]

Hi all,

is there any tool which is capable to convert query initially written for
msaccess database to query for mssql server.
I have tons of queries which contains iif, trim and similar functions which
should be converted to case, ltrim(rtrim(, etc. etc.
Does anyone know for tool which could do that automatically?

Thanks in advance,

Anabella

 

[Arvin Meyer [MVP]]

I doubt that there is such a tool, but this one might be good enough:

http://www.ssw.com.au/ssw/UpsizingPRO/

Try to get a demo to check several of your queries first, just to make sure
that it will work for you.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access