Relational Databases Questions
User at MH

I work for a healthcare company with less than 1,000 employees.

I am new to FileMaker Pro but my company uses FileMaker Pro (FM Pro) as the frontend development tool. More and more applications will be built using FM Pro.  

In the long run : 

1. Is FM Pro Embedded DB or MS SQL Server a better choice in the long run for the backend database?

2. What are the pros and cons of using these two databases if we must use FileMaker Pro as the front end tool?

3. If MS SQL Server has been chosen, will there be any compromise with FileMaker Pro on areas such as functionalities, features, programming methods, etc?

Thanks! I appreciate your help. 

Jeremy CoxIn general, I think that because FM is a closed system that uses its internal DB… more »
Martin KlierI have no experience with FileMaker, so I can't answer any FileMaker specific… more »
ChrichtianNealI have used FM Pro for a paperless construction site and it work seamlessly. … more »