× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I have never used it but MS SQL has a way to just point to a remote database and not replicate the data. It looks like an MS SQL table to a .net developer but contains no data. A request to MS SQL for data gets sent to DB2 which responds to MS SQL which responds to the application. Still better to go direct to DB2 but does let the developer use their familiar database access

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Wills
Sent: Friday, October 05, 2012 3:25 PM
To: Midrange Systems Technical Discussion
Subject: Re: replicating an I-series home-grown application to a .net platform

To be honest, it IS easier to work with SQL Server because of the tight integration that MS has built between the two. HOWEVER, a properly written interface between the two will have no noticeable difference between the two in terms of speed. I have an ASP.NET app that is 100% IBM i database driven. It is fast.

If your .NET developers won't use the IBM i backend, they are lazy.
Point them to me if they say otherwise. ;-)

--
Mike Wills
http://mikewills.me


On Fri, Oct 5, 2012 at 9:58 AM, John Yeung <gallium.arsenide@xxxxxxxxx> wrote:
I will say that I agree with you
100% that it would be simpler to just read the actual i data. I don't
think it's a convincing argument to say "well, SQL Server code is so
much simpler than RPG code" because you don't have to use RPG to read
the data on the i! There are many ways to get at data on the i
without having a separate copy of it, some of which are comparable to
what you'd write for SQL Server, including using .NET languages and
tools. (And some which I think some developers would find even
easier. For that matter, some developers would find RPG easier
anyway, depending on the nature of the application and the data that
needs to be retrieved.)
--
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.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.