Progress to SQL

S

siraj

New Member
Hi all,
My company uses progress ERP. I want to have the same copy the progress database in MS SQL and periodical synchronization to SQL form progress to SQL. Could some sugest me tool/dataserver or method so that I can do this job and synchronization?
I uses Merant driver for ODBC connection and it works fine with Crystal Report.
Thanks in advance.
SIRAJ.
 
I use the SQL DTS from within the SQL Server Enterprise Manager.
I don;t copy the whole database just selected tables and then schedule them. Some larger tables take a long time and I schedule them for off hours or once a week.
I have done full imports of the database however due to the length of time it takes I chose to go with selected tables only.

If you have never used DTS (Data Transaformation Services) it has a nice graphic interface and is fairly easy to use. You can make up packages for different tables and schedule theim as appropriate. For example for job transactions I copy them daily. For employee tables I copy them monthly since employee turnover is low monthly is enough for my purposes.
 
You must log in or register to reply here.
Back
Top