• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 96
  • Last Modified:

Access table relationships

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
RIAS
Asked:
RIAS
3 Solutions
 
ManjuIT - Project ManagerCommented:
0
 
Dustin SaundersDirector of OperationsCommented:
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
 
PatHartmanCommented:
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
 
RIASAuthor Commented:
Cheers!
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now