[stackoverflow] [progress Openedge Abl] How Can I Keep A Progress Database And A Mssql...

[Johan Vergeer]

At the moment I am working on a project to convert our Progress OpenEdge systems to .NET

So the idea is to create all the tables in .NET using Entity Framework. This should be a clean database that is designed from the ground up.

The application is too big to convert everything in one time so there will be a transition process.

What I would like to do is create some kind of hooks to update the data in one database when the other has changed.

Example

Progress articles table


+--------------+----------------+
| artnr | INTEGER |
| artnaam | CHARACTER |
| artoms | CHARACTER |
| artkl | CHARACTER |
+--------------+----------------+

MSSQL articles table


+--------------------+----------------+
| Id | int |
| ArticleName | varchar |
| ArticleDescription | varchar |
| ColorId | int |
+--------------------+----------------+

Continue reading...