db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "RaminMoazeni/DailyNotes" by RaminMoazeni
Date Thu, 01 Jun 2006 08:24:13 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by RaminMoazeni:
http://wiki.apache.org/db-derby/RaminMoazeni/DailyNotes

------------------------------------------------------------------------------
  ===== [5/30/2006] =====
- I sepnt some of my time today researching the feature differences between the Apache Derby
and the MySQL databases. I created a Feature Matrix posted in the "Notes" section. The purpose
of this Feature Matrix is to provide information about the features that the Target System
can offer. This will be helpful in deciding if the target system have the necessary features
needed for the Source System or not.
+ I sepnt some of my time today researching the feature differences between the Apache Derby
and the MySQL databases. I created a Feature Matrix posted in the "Notes" section of the MysqlDerbyMigration
page. The purpose of this Feature Matrix is to provide information about the features that
the Target System can offer. This will be helpful in deciding if the target system have the
necessary features needed for the Source System or not.
  
  The Feature Matrix is grouped into two categories for now: Data Integrity and Database Object.
The Data Integrity group shows Support of ACID transactions, savepoints, Foreign Key, locking
or Multiversion Concurrency Control (MVCC). The Database Object group shows Advanced database
objects like views, schemas, temporary tables.
  
@@ -64, +64 @@

  
  The following command is used to create the above dump:
  
- shell> mysqldump -u username -p passwd database_name [table];
+ shell> mysqldump -u username -p passwd database_name [table] > filename.sql
  
  Detailed information about the "mysqldump" utility can be found at:
  
@@ -72, +72 @@

  
  Now, I need to analyze the above dump and make necessary changes to the above statements
so that they can be executed on Apache Derby. Once the translation is done, the database can
be migrated.
  
+ ===== [5/31/2006] =====
+ 
+ I started off today with writing a piece of code that parses the data from the mysql dump.
I then started working on finding the comparison between MySQL and Derby's datatypes such
numeric types, string types, and Data and Time types. The document is posted in the "Notes"
section of the MysqlDerbyMigration page. 
+ 

Mime
View raw message