LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 02-08-2007, 04:06 PM   #1
crashsystems
Member
 
Registered: May 2006
Location: Tennessee et. al
Distribution: Debian Sid, Etch
Posts: 138

Rep: Reputation: Disabled
Migrating db relationships from Access to MySQL


I currenty have a MS Access db app that I'm migrating to a MySQL back end while keeping the interface in Access (118 tables, 20k + entries). I've used the MySQL migration toolkit to get the data out of Access without any problems. However, I can't seem to get the relationships out of Access. If nothing else, I could manualy input them into MySQL, but I'd rather not do that if I don't have to. I've searched online, and coulden't find much. I followed some instructions for making the Access relationships table available to outside programs, but with no luck. Does anyone have any sugjestions?
 
Old 02-10-2007, 10:46 AM   #2
mrtwice
Member
 
Registered: Feb 2002
Distribution: xubuntu 8.10
Posts: 225

Rep: Reputation: 31
Short Answer:
I doubt you can migrate the relationships.

Long Answer:

I have used ACCESS some in the past, but I am not an expert by an means. With that disclaimer, as far as I can tell, "relationships" in ACCESS are nothing more than a convenient way to define your foreign key relationships so that the GUI tools provided in Access can automatically link tables for you. In the end, all of the queries that you use still have 'JOIN' statements in them so that the SQL engine knows how the tables are linked.

Therefore, I doubt that you can migrate the relationships as MySQL doesn't really know anything about "relationships" as the ACCESS Gui defines them. Rather, you just need to create foreign keys in MySQL which will define the relationships between your tables.
 
Old 02-10-2007, 12:21 PM   #3
crashsystems
Member
 
Registered: May 2006
Location: Tennessee et. al
Distribution: Debian Sid, Etch
Posts: 138

Original Poster
Rep: Reputation: Disabled
Ok, that makes sence. Thanks for your help.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: Managing Many-to-Many Relationships with PL/pgSQL LXer Syndicated Linux News 0 07-04-2006 10:54 AM
LXer: Golden's Rules: Migrating from SQL Server to MySQL LXer Syndicated Linux News 0 05-08-2006 06:22 PM
Nessus Plugin Variable Relationships BoarderX Linux - Software 1 04-20-2005 07:06 PM
mysql relationships question czarherr Programming 2 03-04-2005 12:57 AM
MySQL Relationships Question? RecoilUK Linux - General 1 08-02-2001 06:05 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 04:51 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration