Sybase to DB2
in [DB2]
|
From: Karlitos on 16 Jun 2010 15:59 Is there anybody who has convert a sybase database to a DB2 Iseries database ? I would like to know - the potential problems that could happen - tools that could exist - etc... Thanks a lot.
From: Henrik Loeser on 17 Jun 2010 04:36 On Jun 16, 9:59 pm, Karlitos <karl.har...(a)gmail.com> wrote: > Is there anybody who has convert a sybase database to a DB2 Iseries > database ? > > I would like to know > - the potential problems that could happen > - tools that could exist > - etc... > > Thanks a lot. Not to iSeries, but DB2 for Linux, UNIX, and Windows includes a "DB2 SQL Skin feature for applications compatible with Sybase ASE" (long horrible IBM name, see here: http://www-01.ibm.com/software/data/db2/linux-unix-windows/editions-features-sql-sybase.html). A migration toolkit helps to migrate the data, most of the DDL is justed replayed through that "SQL skin" layer against DB2. Apparently the process is mostly painless. The technology is based on a plug-in from ANTs (http://www.ants.com). Maybe there is something similar for DB2 iSeries? Henrik
From: Gilroy Gonsalves on 17 Jun 2010 06:45 On Jun 17, 9:36 am, Henrik Loeser <henrik.loe...(a)gmail.com> wrote: > On Jun 16, 9:59 pm, Karlitos <karl.har...(a)gmail.com> wrote: > > > Is there anybody who has convert a sybase database to a DB2 Iseries > > database ? > > > I would like to know > > - the potential problems that could happen > > - tools that could exist > > - etc... > > > Thanks a lot. > > Not to iSeries, but DB2 for Linux, UNIX, and Windows includes a "DB2 > SQL Skin feature for applications compatible with Sybase ASE" (long > horrible IBM name, see here:http://www-01.ibm.com/software/data/db2/linux-unix-windows/editions-f...). > A migration toolkit helps to migrate the data, most of the DDL is > justed replayed through that "SQL skin" layer against DB2. Apparently > the process is mostly painless. > > The technology is based on a plug-in from ANTs (http://www.ants.com). > Maybe there is something similar for DB2 iSeries? > > Henrik Hi, Register youself for event given in the below link. You can raise questions to IBM labs http://www.ibm.com/developerworks/wikis/display/DB2/Chat+with+the+Lab It is "Easily moving from Sybase ASE to DB2" event from IBM labs. Thanks Gilroy
|
Pages: 1 Prev: 5 Reasons why In-memory analysis matters Next: Upgrade from DB2 LUW 9.5 to 9.7 failed |