Need tool to synchronize IMS Db to Sybase.. 
Author Message
 Need tool to synchronize IMS Db to Sybase..

What tools are out there that synchronizes a hierarchial database
like IMS one with a relational database like Sybase?
(The Sybase is going into production, replacing the IMS one,
but some old applications will still use it until we finish migrating
the rest of the applications off the mainframes.)

The updates are not in real time and will probably be done
as some batch job at off hours.

And of all the avaliable tools, what is your input and evaluation
on those tools?

Thanks in advance,

William Ma




Thu, 09 Jul 1998 03:00:00 GMT
 Need tool to synchronize IMS Db to Sybase..

Quote:

>What tools are out there that synchronizes a hierarchial database
>like IMS one with a relational database like Sybase?
>(The Sybase is going into production, replacing the IMS one,
>but some old applications will still use it until we finish migrating
>the rest of the applications off the mainframes.)
>The updates are not in real time and will probably be done
>as some batch job at off hours.
>And of all the avaliable tools, what is your input and evaluation
>on those tools?

Take a look at SQL Workshop from Analytical Solutions, Inc.  It is a
complete development environment for Sybase/SQL Server.  One of the
utilities delivered with it is a Data Mover.   It enables you to
compare and update tables between 2 servers.  The servers can even be
different (like in your scenario).  You will have to migrate 1 table a
time (ie. there is no script faciility), but there are not a whole
lotta of affordable tools that let you do what you are trying to do.

Mike Sachais
Analytical Solutions, Inc.
(770) 416-8821
Web Page: http://ourworld.compuserve.com/homepages/asi_software
CIS  - 74204,2246



Tue, 14 Jul 1998 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. 17702-KY-FRANKFORT-IMS-IMS DB/DC-CICS-DB2-PROGRAMMER ANALYST

2. 17702-KY-FRANKFORT-IMS-IMS DB/DC-CICS-DB2-PROGRAMMER ANALYST

3. 17702-KY-FRANKFORT-IMS-IMS DB/DC-CICS-DB2-PROGRAMMER ANALYST

4. 17702-KY-FRANKFORT-IMS-IMS DB/DC-CICS-DB2-PROGRAMMER ANALYST

5. 17702-KY-FRANKFORT-IMS-IMS DB/DC-CICS-DB2-PROGRAMMER ANALYST

6. 17702-KY-FRANKFORT-IMS-IMS DB/DC-CICS-DB2-PROGRAMMER ANALYST

7. IMS-DB and IMS-DC or DL/1

8. TN-IMS DB/DC COBOL/ Sybase/C++

9. IMS DB/DC / Sybase / C++

10. Need input on synchronizing SQL server with text based DB

11. Synchronizing SQL DB with a Access DB?

12. synchronize production db and reporting db?


 
Powered by phpBB® Forum Software