• 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.
 
Consider Paul's rocket mass heater.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic