Solved

Migration from MS Access to SQL Server express 2008 database

Posted on 2009-05-04
3
262 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
[X]
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
  • 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

726 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