3-tier development with FM and SQL server?

[El_Pablo]

Hi,

Would it be a good approach to

- create the database in SQL Server.

- create the business access layer in a FM file.

- and create the presentation layer in a FM file.

Why SQL server? Because it's a powerful database system and a lot of company use this technology.

Why FM for BAL? Because this way it's easier to add some calculation over SQL fields.

Why FM for PL? Because, IMO, it's one of the best RAD (Rapid Application Development) software.

Is this development method is a good approach?

Now a technical question.

If I create the BAL in FM10A doing all the necessary external connection. Can FM8 server host this file?

Thanx for any advice!

[Greg G]

Your separation model is fine. I think a lot depends on how you like to work and how you may need to deploy your DB. SQL is great and very powerful but unless you need that level of speed and power you may find it easer to develop some solutions entirely in FMP. Either way it should work.

From my understanding, if you are using FMP10A you need to use FMP 10 Server as well to host the files.

Good luck!

Greg

[El_Pablo]

Actually, you can host FM10 with FMS8. Except I'm not sure about the external data connection.