Any suggestions on how to replicate from AS/400 to SQL Server 2000?
Data is stored on a AS/400, but applications use a SQL Server 2000 DB. Currently, DTS packages drop the SQL DB, rebuild the tables from a script, copy the data, and then rebuild the indexes as a nightly batch job. Is there a better way to do this? Also is there a clean way to replicate daily transactions as well?
Hi
Replicating from AS400 to SQL Server is not currently supported by replication. (Although it is possible the other way round SQL Server to AS400 DB2 via HIS).
Thanks
Nabila Lacey
No comments:
Post a Comment