Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Migration from MS Access to SQL Server express 2008 database

Posted on 2009-05-04
3
261 Views
Last Modified: 2012-05-06
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?
0
Comment
Question by:tlangent
  • 3
3 Comments
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24294133
when you import your table with data from access to SQL Server, it will copy table not relation.
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24294152
0
 
LVL 31

Accepted Solution

by:
RiteshShah earned 50 total points
ID: 24294159
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question