Re: Performance question and SQL SERVER

Very interesting thanks. I think I will look into doing on my own. Rich, I
think that they have bought the product so it's hard to tell them to throw
it away. It's like with sports teams, only the Yankees can throw away
someone, other teams have to live with their 'stars'.


On Wed, May 29, 2013 at 9:11 AM, Richard Schoen <richard@xxxxxxxxxxxxxxx>wrote:

Usually for doing reporting or other tasks that could drag down the main
system.

There are several replication tools out there.

SQL has SSIS for doing replication.

If you're open to commercial software our RPG2SQL Integration can help
with this process. You can write RPG programs to control the entire
import/export process.

We've seen several customers do the opposite where they wanted to pull in
transaction data to the iSeries and report on it.

We also have a new Smart Reporting component that can be used to quickly
write reports against IBM i data which is much simpler to use than
something like Crystal.

Feel free to contact me offline to further discuss.

Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business
Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT


------------------------------

message: 6
date: Wed, 29 May 2013 08:38:23 -0400
from: Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>
subject: Performance question and SQL SERVER

Has anyone ever ported AS400 data to a SQL Server? Why would you do that,
because of the company having some extra servers that can be used as either
Replication, or
to use for reporting tools based in Windows.

If so, are there tools or products for this or something one can do on
their own.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.