MS Access data conversion - msaccess to mssql server automatic query conversion

Author

msaccess to mssql server automatic query conversion

Anabella

2005-07-19, 3:24 am

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]

2005-07-23, 11:23 am

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

"Anabella" <x@x.com> wrote in message news:dbi7n9$5td$1@ss
405.t-com.hr...
> 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
>
>

Sponsored Links