Access 2000 to SQL 2000

M

Matt

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
 
D

David Conger [MSFT]

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. **
 
M

Matt

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!
 
T

Todos Menos [MSFT]

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
 
M

Matt

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...
 
D

David Conger [MSFT]

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. **
 
T

Tony Toews [MVP]

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
 
T

Tony Toews

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
 
Top