Solved

Access table relationships

Posted on 2016-07-28
4
52 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
ID: 41733072
0
 
LVL 12

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 34

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

929 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

18 Experts available now in Live!

Get 1:1 Help Now