how to import relationships of access database to sql server 2000?

[Sarmx]

Dear Friends,

I have an MS Access (2002) Database with rather complex
relationships between the tables, when i try to import
the whole database to Sql Server 2000, it will not bring
the relationships, is there a way to do that, so that i
dont have to create those relationships in sql server
manualy.

i sure would appreciate any help in this regard

kind regards

Sarmx

 

[mrdenny]

I don't believe that there is a way to do this through the SQL tools. The Access upsizing wizard might be able to do this for you.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com