Posted by NickName on 06/22/06 21:49

Thanks, good to know, last time (probably a little over half a year
ago) when I tried this approach of using Access Upgrade Wizard, it did
not convert relationships, keys etc.
Too bad, I can't use this approach at this point because the server
machine does not have Access installed and I can't do that without a
license etc. etc. While using the SQL Server import facility is an
option. I wrote a script to automatically create a PK for each user
table (good thing the current Access db has a good patent for PKs), but
this is a very desirable option though for one thing the relationships
are not there, not too sure it would be easy to automatically create
FKs.

MGFoster wrote:
> NickName wrote:
> > This question probably has been asked many a time. And yet I feel it
> > is still relevant for one thing a search on this NG does not produce a
> > desirable answer.
> > It is kind of disappointing that MS would not be able to transfer ER
> > relationship from an Access db to a SQL Server 7/2000-based one, the
> > upgraded db/imported tables sitting on the SQL Server would not have
> > PKs, say, you have 100 user tables, you have to first recreate PKs for
> > each of them then set up relationship between/among them, quite time
> > consuming. Do you have a better way?
>
> Use the MS Access Upsizing wizard (Tools > Database Utilities > Upsizing
> wizard). It will convert all relationships, PKs, FKs and indexes from
> the Access DB to the SQL DB.
> --
> MGFoster:::mgf00 <at> earthlink <decimal-point> net
> Oakland, CA (USA)

[Back to original message]