Re: Access 2003 database to SQL 2005

Hi there,

I know there is a tool in MS access
called Usizing Wizard to help me to do this, but can this tool convert
Access Forms, Querries and Reports to SQL as well?

The following articles may be of interest:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q325017
http://office.microsoft.com/en-us/assistance/CH062526781033.aspx

The first article references Access 2000, I believe it is still valid
in everything that it says.

Basically your entire DB structure will be transformed into a SQL
Server database and the wizard will attempt to change the queries you
have defined as described in the 2nd article (see About Upsizing > How
database objects get upsized > Queries).

Considering the SQL Server product in a stand-alone fashion it doesn't
have a concept similar to Access Forms (you have to code seperate apps
to access the DB) but you could replicate reports through the use of
SQL Server Reporting Services.

Either way, forms and objects probably won't be converted because there
is no equivalent object in SQL Server.

One this database is migrated to the SQL server, how users are going to
use this database?

How do your users access the database now? Do they open up the .mdb
file and work with Access Forms?

You could create new applications using something like VB.NET and
deploy them so that users can work with the database. However, it could
be quite time-consuming and users would have to learn something new.

In your case, you might be better off keeping Access as the front end
and using SQL Server as the backend. This is described in the articles
I gave links to before.

Hope that helps a bit, but sorry if it doesn't

.

Relevant Pages

  • Re: How do i move an SQLDatabase to another location?
    ... I went to my clients and installed SQL Server ... Express and copied my database to the same location it was in while i was ... knowing that i can bring a database with me and install ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: New to Windows CE Development - Have some questions
    ... validating against the main database, or querying the database during data ... iterate through the SQL CE table and create new entries in the ... SQL Server database that correspond. ... >>> not connected to the Enterprise. ...
    (microsoft.public.windowsce.app.development)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... MSDE to store SharePoint uses the MSSQL$SharePoint database, ... SharePoint named instance to full SQL. ... You cannot upgrade the Monitoring instance to SQL ... What I see is the SQL server group and under ...
    (microsoft.public.windows.server.sbs)
  • Re: URGENT: SQL 6.5 Server Crash
    ... > Are these database backup done by SQL Server? ... > Or file backups performed by some Windows backup software? ... were they performed while SQL Server was running? ...
    (microsoft.public.sqlserver.server)