Convert Access To DB2

by

Want to convert Access to DB2 ?

Using DBCopier, a native GUI software, a Access to DB2 converter, you can convert Access to DB2 easily and fast.

  • Step by step, just a few mouse clicks.
  • Support schedule and automate db conversion.
  • Supports Windows 10, 11, 2003, 2008, 2012, 2016, 2019, 2022.
  • Can work without Microsoft Access installed.

Download DBCopier Download DBCopier

Here’s how to.

Convert Access to DB2

Choose source Access database and logon.

convert Access  to DB2 - Choose Access and logon

Choose target DB2 database and logon.

convert Access  to DB2 - Choose DB2 and logon

Click “Wizard – Import All Tables” at task dialog.

convert Access  to DB2  - Task Window

then show the wizard.

1. Open source Access .

convert Access  to DB2  - Open source database

2. List target DB2 tables.

convert Access  to DB2  - list target tables

3. Select DB2 tables to convert.

convert Access  to DB2  - select tables

4. convert Access to DB2.

convert Access  to DB2  - convert

Download DBCopier Download DBCopier

Save/load session of converting Access to DB2

You can save/load session to run “Access to DB2” conversion repeatly.

1.Save Session.

Click “Save Session” button, then enter a session file name.

convert Access to DB2 - save session

click “OK” button.

2.Load Session.

Click the “Open Saved Session” in task window, select a session file.

convert Access to DB2 - load session

then show the wizard form, click a few “Next” to convert Access to DB2.

convert Access to DB2 - start session

Download DBCopier Download DBCopier

Run in command line for converting Access to DB2

You can run “Access to DB2” conversion in command line.

When you save session, you can click “Save & Make Batch File”.

convert Access to DB2 - save session

The “Save & Make Batch File” form shows.

convert Access to DB2 - create batch file

Click “OK” button, you’ll create a batch file, in Windows, like this:

C:
cd "C:\Users\pansh\AppData\Local\Programs\DBCopier"
DBCopier task="C:\Users\pansh\Documents\test.ula" logfile="C:\Users\pansh\Documents\test.log"

You can run this batch file in command line.

Download DBCopier Download DBCopier

Run as scheduled task for converting Access to DB2

You can run “Access to DB2” conversion automatically at specific time.

On Linux/macOS, you can use Crontab.

For macOS, How to Fix Cron Permission Issues in macOS.

On Windows, in “Save & Make Batch File” form, you can click “Create & Schedule Task” to set a scheduled task.

Access to DB2 - create batch file

And then, with scheduled task wizard, step by step.

convert Access to DB2 - scheduled task application

You’ll see created task listed in scheduled task list.

convert Access to DB2 - scheduled task list

Download

Here you can download DBCopier, and buy DBCopier.

30-day free trial Download DBCopier