Convert MS Access(*,mdb) to SQL Server Database

Hi

I need to convert on existing Access database to SQL Server database. If I convert though sql DataTransformation, it taking only data from the Acccess Database not all the constraints like Primary Key, Default Value, Relations .........

Any one can give the solution to this

-->nRk

DTS and SSIS are both about moving data, they are not migration tools themselves, so they do not care about structural elements.

There seem to be plenty of guides and such like online-

http://www.microsoft.com/sql/solutions/ssm/access/accessmigration.mspx

http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part2/c0561.mspx?mfr=true

http://www.mssqlcity.com/FAQ/General/MigFromAcc.htm