GGerard wrote:
Hello
I have an Access 2000 application that I would like to upgrade to an
SQL server.
First of all, is this possible?
No, it is not possible to convert an Access *application* to SQL Server as one
cannot create applications with SQL Server at all. SQL Server is a data
storage/retrieval engine. It does not provide much for letting users interact
with the data.
You can move the *data* out of your Access MDB file onto a SQL Server, but you
still need an application created by some sort of application building tool in
order to be able to DO something with the data. That application or "front end"
can be created with Access. VB, dot-net, or any of a variety of other tools.
Since you already have a working Access application it would be most expedient
to stay with that.
Is it complicated to do?
At its most basic you can ceate identical tables on a SQL Server, delete the
tables from your Access app, then create ODBC links to the tables on the SQL
Server and your app should work (mostly) as is without too much design changes
being required. Whether it would be a very good app in terms of taking
advantage of the benefits of SQL Server would be largely dictated by how well
designed of a database application it was in the first place.
Access/Jet allows you to get away with some pretty bad ideas and design
strategies that might not work well at all when you move the data to a server
engine. However; if your existing Access app makes use of all "best practices"
in terms of data loading and such, then the app will likely need little work to
be "at least as good" after moving to SQL Server as it was before. Making it
better though, will likely require further modifications which of course can be
worked on "as you go".
Where can I find the information on how to do this upgrade?
These groups for one. I believe MS has a white paper on their site that
discusses "When should I move to SQL Server?". I don't know how much it
discusses the "How?" part.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com