converts queries from access2002 to sql sarver

[Van T. Dinh]

Lots of Access Queries should work fine in T-SQL unless you use functions
(Access / VBA inbuilt or custom functions) or Parameter Queries.

I am not aware of any tools to convert these Queries to T-SQL.

 

[Van T. Dinh]

Sorry, I don't know of any as I wrote previously.

You can tell me when you find one ... <smile>

 

[monther]

hello :
Is there a tool that converts the queries form access2002 to sql sarver?
monther

 

[monther]

Thanks for replying;
Unfortunety , I have used a lot of access(MDX) functions like iif ,
choose,....
I want a tool that converts any query contains access(MDX) code to T-SQL.
It will be powerful to help me in finding this tool
Monther

 

[Joe Fallon]

Have you tried the Upsizing wizard?
It does some of this.
Not perfectly, but better than nothing.