You want to get rid of MS Jet and
BDE?
You would find yourself rewriting some vital parts and hundreds of minor segments of your project.
Changing to
SQL Svr 2005 is changing to a new
DBMS that supports CLR Code.
Since you cannot write stored procedures or triggers for
SQL Svr 2005 within D2005, it won't be a wise choice.
So before changing half of your project... why not start over on a new technology, like .Net?
Using VisualStudio 2005 & SQLSvr 2005 you can create Database projects -> writing and debugging Database Code within the same
IDE and language of your Application. (would be C#
)