Migration from MS Access to SQL Server express 2008 database

I have a schema of database in access, I wanted to copy it to SQL Server express 2008, I created a new folder and performed import from access, I got all th tables on the SQL server but without any relationships, is it possible to import them somehow?
tlangentAsked:
Who is Participating?
 
RiteshShahCommented:
0
 
RiteshShahCommented:
when you import your table with data from access to SQL Server, it will copy table not relation.
0
 
RiteshShahCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.