Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 3

Displaying posts with tag: MS-Access (reset)

Converting MS Access to MySQL with relationships
+1 Vote Up -0Vote Down

I have used tools like MySQL Migration Toolkit (*) and Bullzip’s Access To MySQL utility, both do a excellent job but without relationships. We can spend a lot of hours to identifying and creating relationships until now:

I have write a VBA script to identify MS-Access relationships and create MySQL code with SQL-CREATE sentences, it will be useful after migration process using any free tool:

'Put this function in new/existing MS-Access module.
'
' Version History:
'
' 2014-02-09 - Seamus Casey
' a modification to Ivan's handy Access to MySQL relationship/constraint generator
'
' changes include:
'  1) skip Access system tables (TableDefAttributeEnum.dbSystemObjec)
'  2) add support for cascading updates/deletes
'
 
Public Sub printRelations()
    Dim sql, fk As String
    Dim I, J As Integer
    Dim db As Database
    Dim Table As
  [Read more...]
A Certain Measure Of Innocence
+0 Vote Up -0Vote Down

Slowly getting there… The sign of eth is rising in the air!


The Sign Of Eth Is Rising In The Air
+0 Vote Up -0Vote Down

Brief pause of that Sudoku series :  I’m working on my object-relational mapping framework code-named Eth.

It’s vaguely similar to Glorp but much simpler and not as intelligent as Glorp.  This time, the resurrection of my framework is more like… a rewrite from scratch.  It all started on VAST, then I ported it to Dolphin then Squeak and now Pharo.  Hopefully, now I will spend more time writing it than porting it! Also, it will exclusively support Pharo.  I also decided to write some SUnit tests to make sure I can properly handle PostgreSQL, MySQL and Interbase for the first version.  But I am also planning on supporting SQL Server, Oracle, DB2,

  [Read more...]
Showing entries 1 to 3

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.