Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
 Posted - 2005-10-03 : 14:39:05
|
| Hello All -Is there a easy way to replicate a MS Access SQL Query on a MS SQL 2000 Query ? Any tools out there that could help a developer on that ?Do we need to Re-write all the query on MS SQL again ?---Thanks!Igor. |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-10-04 : 05:11:51
|
| If you follow the ANSI standards in writing queries, MOST will run with no change.A list of differences in the products from a coding point of view should be available via Google. |
 |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2005-10-12 : 11:11:30
|
| I know, I'm taking an access db developed by someone, I doesn't really follow the ANSI standards as I would do and I'm not a access expert, so... I'm screwed...---Thanks!Igor. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-10-12 : 12:03:38
|
| Remember that Access and SQL Server are like apples and oranges. While both contain a database engine, Access is a desktop application that provides forms, macros, reports, and vb. A query in an Access MDB has full access to VBA functions, objects on forms and reports, JET-specific functions (IIF), can prompt for parameters, and other thigns that are specific to a client application with a user interface. SQL Server, of course, is a server application and doesn't have these things built in.So, for in any given Access query, you need to analyze it to see what objects and properties and behavoirs it depends on that the Access client app provides.In addition, remember that Access queries generated by the UI designer often contain no formatting, crazy use of parenthesis everywhere, random join-types (RIGHT OUTER JOINS end up everywhere) and other oddities. |
|
|
|
PETE314
Starting Member
37 Posts |
Posted - 2005-11-03 : 11:39:20
|
| When you say an MS Access SQL Query.......are you speaking of a pass through query? I mean as far as regular queries, what everyone has been saying concerning the Jet Engine vs the SQL Server holds true. But if these are pass thru queries then the Server is already doing the work and it should be an easy matter of making the conversion as the pass thru query is already written in Transact SQL. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-11-04 : 04:30:42
|
| >>Do we need to Re-write all the query on MS SQL again ?Yes, if you used IIF or nz functions in AccessMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
|
|
Access X MS SQL SQL