Solved

Access table relationships

Posted on 2016-07-28
4
44 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
4 Comments
 
LVL 6

Assisted Solution

by:Manju
Manju earned 125 total points
Comment Utility
0
 
LVL 12

Assisted Solution

by:Dustin Saunders
Dustin Saunders earned 125 total points
Comment Utility
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 34

Accepted Solution

by:
PatHartman earned 250 total points
Comment Utility
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
Comment Utility
Cheers!
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

743 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now