Middle-Tier access

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Sid
Posts: 6
Joined: Mon 30 Jan 2012 21:54

Middle-Tier access

Post by Sid » Thu 14 Apr 2022 15:27

We have a large application developed in Delphi 2007. We use SDAC components heavily to connect to MS SQL Server in a 2-Tier Client-Server environment.

Now, we want to change our apps to a 3-Tier Architecture access to avoid exposing SQL Server to the Internet ( so it is only exposed to the middle-tier access behind the firewall ). The question is, is there an easy way to convert these to 3-Tier approach, where TMSConnection on the client app can point to some proxy remote Server in the middle-tier and all the DB requests are transacted through the middle-tier with the MSSQL Server?

Any existing solution that requires bare minimum of changes for the SDAC components?

Can you suggest any other approaches/ frameworks?
I know some out there like RemObjects Data Abstract or Delphi DataSnap or TMS Software, but these need complete restructuring of the apps.

Post Reply