I am just starting to tackle a monster project of magically enhancing a VB app built on Access 2000 to be able to work with SQL Server. Unfortunately, the queries have been hard-coded into VB so I am afraid I may have to manually go through the entire app modifying each query. I have read about SQL Server's builtin migration tools (and Access' Upsizing Wizard) but not sure if it applies.
Ideally, I would love to use all ansi SQL statements and have the connection object transform the SQL statement so it can be run against either one of the DBMSs.
Is this possible without having to rewriting everything?
Thanks for all input!