Database Conversion

[slimmer]

We are converting data from Sybase running on Sun Solaris box to DB2 running on the mainframe.

Is it possible to use MS Access to create the mainframe DB2 table structure, connect to Sybase and populate the tables. Then connect to the mainframe DB2 database and populate those tables from the ACCESS tables?

Any help will be appreciated.

 

[jrbarnett]

Hi,

Obviously installing the ODBC drivers for each on a workstation will let you connect via MS Access. You could do it that way, but it will take a while if you have lots of data to transfer.
If you have Sybase you probably have the PowerDesigner SQL modeler software, which you could use to reverse engineer the structure of the Sybase system and upload it to DB2. If you choose this method,
check it thoroughly as when I attempted to use it to transfer Sybase to SQL server it ignored referential integrity and I had to set it up manually again. Other database CASE tools may allow you to do this, but I don't know much about any of the others.

John