move queries from mdb to SQL Server

[accessman2]

Hi,

I know how to move the tables from mdb to SQL Server.
But, how can I move all the queries from mdb file to SQL Server?

 

[tehNellie]

Depends on what the query does and how your application works, but you should be looking at moving your queries into either Stored Procedures or Views.

Test your queries first using the query analyser. At a basic level, if it works in Access, it should work in SQL Server but there are some subtle differences in SQL syntax between the two.

 

[accessman2]

Just basic Views,

I create the query (select * from tbl1 where [f0] = 'a') in the MS Access.

I want to move this query to SQL Server.

I went to Tools->Database utilizes->upsiding wizard

It only work for tables. no queries. We cannot move queries to SQL Server.