Exporting MS Access to SQL Server

hi,
how can export an Access Data bank to sql Server with all definition (the
relationship between the tables)You can use the Access Upsizing wizard (available on MS web site). But most
people prefer to use DTS and do things manually..THe upsizing wizard makes
some assumptions which must be manually handled anyway..Look at DTS with
Access as a data source.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Zaid" <Zaid@.discussions.microsoft.com> wrote in message
news:6D71D63A-FE51-4066-9171-60DC7A1A7A11@.microsoft.com...
> hi,
> how can export an Access Data bank to sql Server with all definition (the
> relationship between the tables)
>

export to sql 2005

when i export data on sql 2000 to sql 2005, i lost all the primary key
setting and relationship.
how can preserve what database structure on the sql 2000 when i move to
sql 2005?HandersonVA (handersonva@.hotmail.com) writes:

Quote:

Originally Posted by

when i export data on sql 2000 to sql 2005, i lost all the primary key
setting and relationship.
how can preserve what database structure on the sql 2000 when i move to
sql 2005?

The safest way is simply to backup the database and restore it on SQL2005.

Next best way is to build a database from the scripts you have under
version control.

Else, well, you can script, and then move data. More chances for things
to go wrong. The Copy Database Wizard in Management Studio packages this,
but unfortunately it's buggy.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx