Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Import MS Access Database into DB2

 
Jan Jansen
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This may be an elementary question, but how do I go about importing an Access database into DB2? Thanks!
 
Abbas Alafoo
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I had a similar case when I needed to export SQL Server database to DB2.
I first generated the DDL commands, and executed them on DB2, then I exported each table data into a text file, and then imported that file in DB2.
I'm not sure if there is an easier way, but my trial did work.
 
Jan Jansen
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for your reply. I've decided to use a software that will convert the data from Access to DB2. It'll be much easier that way.
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!