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

 

[Jeff Boyce]

Anabella

If you are using Access as a front-end to data (now) stored in SQL-Server,
you don't need to modify the queries to run them from Access.

If you are converting them to Pass-Through queries, or generating stored
procedures to run inside SQL-Server, you DO need to convert them.

I'm not familiar with a "converter" tool -- have you tried searching at
Google.com, or posting in the SQL-specific newsgroups?

 

[Anabella]

I don't use Access as a front-end to data.
Application is developed in Borland Delphi.
I tried to find converter tool on the NET and so far I haven't been able to
find it.
Maybe I'm just a lousy searcher :-(
Anyone who is willing to assist?

Anabella

 

[Jeff Boyce]

I was confused by the fact that you posted in an Access-related newsgroup,
with a subject line starting with "Re: msaccess to mssql".

How is it that you need to convert from Access-based SQL if you're not using
it?

Wouldn't you need to convert from whatever dialect of SQL is used in the
front-end you are using?

 

[Anabella]

No, the foundation of data layer in the application are ADODatasets.
Queries are adodataset's commandtext property.
These queries must be written in the way that database can 'understand'
them.

Anabella