This is kind of an exotic situation: We have a very specialized and old .NET application (without sources) that connects to a MS SQL Server database. As there are certain restrictions for the "Express" version of MS SQL, I thought that we could perhaps use a better and free database like Postgresql.
As we can't change the application so that it directly talks to Postgresql instead of MS SQL, is there a way to "wrap" the Postgresql DB so that it looks and behaves like an MS SQL Server? I think of something like an interface application that translates between the two dialects while being completely transparent to the .NET application.
I know, this is ugly, but it would come in very handy until there's a new implementation (which will take at least 2 years from now). Besides that, it would allow the whole shebang to be run on a linux system.
