By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,264 Members | 1,087 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,264 IT Pros & Developers. It's quick & easy.

Upgrading Access2000 to SQL Server

P: n/a
Hello

I have an Access 2000 application that I would like to upgrade to an SQL
server.

First of all, is this possible?

Is it complicated to do?

Where can I find the information on how to do this upgrade?

Any other comments will be appreciated
Thanks
G.Gerard
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.