Access migration to SQL Server

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am deciding which database i should use for my application. One of the
factors that i will use is how easy/difficult it is to migrate from access to
SQL Server / SQL Express Edition.

I'd appreciate any views on this and any links to relevant websites.

Thanks in advance,
Macca
 
Hi,


If you just link tables to a back end MS SQL Server database, the
modifications are minimized, but you may end up with a slower solution (but
more robust). Which modification exactly? depends on what you use: if you
used SEEK on recordsets, you may have to use FindFirst on dynaset instead.
If you use Crosstabs, then you will also have to change these, as well as
any VBA function calls in your existing SQL that has to be modified.


If you really want all the benefit of MS SQL Server, you are probably due to
rewrite the whole application and even re-engineer how the application
works. If your goal is to get a more robust system, that is probably right,
but if it is mainly to get speed, a faster application, I would boldly claim
you may be trying to migrate for a really wrong reason... your re-written
application would be also as slow, if not worse, than the actual one, if you
don't change the way of how it works. And to change the way of how your
application works, you can do it staying with Jet: split your application
(front end, back end), minimize the use of forms and recordsets without any
"criteria"; minimize lengthy list behind combo box and list boxes; etc.



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top