Solved

Access table relationships

Posted on 2016-07-28
4
74 Views
Last Modified: 2016-07-28
Hello,
I have a table in access 2013 and one of the fields in it has relationship with another table
Table1 field1 has relationship with table2 field1

 I have to import these tables to SQL server .How can i do it with import export wizard in sql server management2014  studio.


Cheers
0
Comment
Question by:RIAS
[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
4 Comments
 
LVL 6

Assisted Solution

by:Manju
Manju earned 125 total points
ID: 41733072
0
 
LVL 13

Assisted Solution

by:Dustin Saunders
Dustin Saunders earned 125 total points
ID: 41733089
Second that.  We moved from an Access app to SQL based, and the migration assistant does a beautiful job of importing everything for you, keeping identities (etc.)
0
 
LVL 37

Accepted Solution

by:
PatHartman earned 250 total points
ID: 41733096
I find the Migration Assistant (SSMA) to be much more difficult to use than the old upsizing wizard.  Yes I know "it does so much more" but mostly, I don't care about that.  I just want it to copy the schema and data and relationships.  Anyway, make sure you set the defaults for data types or you'll end up with tables you can't use unless you change your ODBC driver.  In particular, make sure that dates are converted to DateTime rather than the SSMA default of DateTime2 since the default ODBC driver sees DateTime2 as text so it doesn't work as a date.

Before you start the upsizing process, make sure that your relationship are correctly defined and all your field lengths and types are correct.  Make sure your yes/no data types have a default of yes or no because SQL Server converts them to a data type that allows nulls and that will cause a problem.  I tend to run the upsizing wizard multiple times.  I always go back to Access to fix the problems and then delete the SQL side tables and run the upsizing again.
1
 

Author Closing Comment

by:RIAS
ID: 41733100
Cheers!
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

710 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