Re: Performance question and SQL SERVER

[Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>]

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.