Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / SQL Server / ADP / February 2006

Tip: Looking for answers? Try searching our database.

Migrate from Access to SQL

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
SIMON GARE - 19 Feb 2006 14:38 GMT
Hi,

I have an apllication that uses Access but want to switch to SQL, is it an
easy process and are there any rescources to see.

Regards
Simon
Tom Ellison - 22 Feb 2006 18:43 GMT
Dear Simon:

Access includes Jet, a database.  It also includes the database MSDE, a
version of SQL Server.

The rest of Access is a Front End.  SQL Server does not include a Front End.
You cannot convert the Front End to SQL Server, only the data and queries.
Actually, there are things that are often implemented in an Access Front End
that can, and probably should be, moved to a SQL Server back end.

Do you intend not to have any front end at all?  Or are you planning to
convert only the data and queries to SQL Server?

There is an upsizing wizard.  I've used it, but then modified what it
produces.  There are other differences that will require changes.  There are
also usually significant opportunities to make the SQL Server back end much
better than what the wizard produces.  But that's a starting point.

I do not think of moving from Jet to MSDE to be a switch from Access, but a
switch within Access.  Perhaps that's what you want.

Tom Ellison

> Hi,
>
[quoted text clipped - 3 lines]
> Regards
> Simon
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.