|
|
Posted by MGFoster on 06/22/06 18:11
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)
Navigation:
[Reply to this message]
|