Access 2000 to SQL 2000

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

Guest

Hi Folks,
I have an Access 2000 DB that will need to be converted into SQL 2000. Is
there a simple way of just using a tool that will convert it? Or do I have to
recreate the tables than import that data from Access? If the latter is the
only way, is there a guide available that will help me make sure I set up the
same DB in SQL? Thanks!Matt
 
Access includes an Upsizing Wizard to migrate data from an Access Database
to SQL Server. With your database open, go to Tools -> Database
Utilities -> Upsizing Wizard. The Upsizing Wizard will walk you through the
process. At the end you can decide between creating an ADP or an MDB with
linked tables.

--
David Conger
Software Development Engineer in Test
Microsoft Office Access

** This posting is provided "AS IS" with no warranties, and confers no
rights. **
 
Thanks Dave! Is there a place I can read about the diff between ADP and MDB
to know which I need? Thanks again!
 
Here is a link to full details on what an ADP is:
http://office.microsoft.com/en-us/access/HP052731031033.aspx

The big difference is that an ADP will only contain tables/queries that
exist on the SQL Server. MDB's are still Access Databases, but would simply
have tables that are links to those on the SQL Server.

--
David Conger
Software Development Engineer in Test
Microsoft Office Access

** This posting is provided "AS IS" with no warranties, and confers no
rights. **
 
So basically it works this way:

ADP- Access DB original is used

MDB- Access DB is connected to a SQL DB

I will look at the link as well. Thanks Dave!
 
Matt

I would really reccomend concentracting on the SQL side and not
worrying so much about the ADP side.

I've been using ADP for years... Years and years and years. I can't
reccomend them strongly enough.

Some books that i've had that helped:
Client Server Solutions with Access 2000 (black book publisher)
Professional SQL Server Development using Access 2000 (Wrox)

And I do know that MS Press has a good book on this; but I've never
had the need to look up stuff so I haven't bought that book

Hope that helps

-Todos
 
Great Thanks Todos!

Todos Menos said:
Matt

I would really reccomend concentracting on the SQL side and not
worrying so much about the ADP side.

I've been using ADP for years... Years and years and years. I can't
reccomend them strongly enough.

Some books that i've had that helped:
Client Server Solutions with Access 2000 (black book publisher)
Professional SQL Server Development using Access 2000 (Wrox)

And I do know that MS Press has a good book on this; but I've never
had the need to look up stuff so I haven't bought that book

Hope that helps

-Todos
Click to expand...
 
Take a look at the link, there should be a lot there. ADP's aren't actually
databases, they are projects. They only contain Forms, Reports, Macros, and
Modules. They do appear to contain tables and queries, but these are
actually the SQL objects that the ADP is connecting to. Linked MDB's (or
ACCDB's in the 2007 world) are true Access database. They contain Tables,
Queries, Forms, Reports, Macros, and Modules just as your origional database
did, though for the tables you upsized, there will be "Linked Tables" which
connect to the SQL Server's Tables.

--
David Conger
Software Development Engineer in Test
Microsoft Office Access

** This posting is provided "AS IS" with no warranties, and confers no
rights. **
 
Todos Menos is not a Microsoft employee. This posting is by A a r o n
K e m p f.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
David Conger said:
Access includes an Upsizing Wizard to migrate data from an Access Database
to SQL Server. With your database open, go to Tools -> Database
Utilities -> Upsizing Wizard. The Upsizing Wizard will walk you through the
process. At the end you can decide between creating an ADP or an MDB with
linked tables.
Click to expand...

There is a new tool from the SQL Server group.
SQL Server Migration Assistant for Access (SSMA Access)
http://www.microsoft.com/sql/solutions/migration/default.mspx

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert from MS Access 2000 1
Access to SQL Server 3
SQL Server verses Sharepoint 12
Access 2000 and Access 2003 1
SQL upsize 2 databases 2
Upsizing ACC 97 to SQL 2000 1
access 1 to access 2000 5
Access 2000 File Format in Access 2003 4

Back
Top