Claris FileMaker vs. Microsoft SQL Server

I think FileMaker [Pro] is a great solution for a small business wanting to take the next step from managing data with Excel spreadsheets to actually using a database. It is very intuitive to use and manage. A tech-savvy user can learn to use FileMaker [Pro] very easily without advanced skills as a developer.

Incentivized

Microsoft SQL Server is ideal for highly available SQL workloads by using SQL Server Always On availability groups. Microsoft SQL Server might not be appropriate for solutions which require a very low resource footprint, since it requires significant CPU cores and RAM memory as well as high IOPS, always depending on the usage scenario.

Incentivized

• The relational database management system makes the program highly customizable to fit the needs of any product. You can add a ton of information to each record and update your inventory on a regular basis with an Excel import or manually inside of the record. It has the capability to incorporate barcoding, which can manage your available inventory with ease.
• The scripting language allows FileMaker to automatically calculate complex algorithms automatically or generate report outs with the click of a button. This allows for greater UI, especially with active users who are not familiar with writing code. Almost all of our internal data is linked to the FileMaker database
• The server license allows many users to update the database in real time, which is handy if your inventory is constantly changing. We have users with Macs, PCs, iPhones and handheld tablets linked to our FileMaker database and they are updating the information constantly throughout the day.
• If you invest some time into formatting and scripting the database, there is a high ease of use for users without knowledge of any programming or FileMaker itself.

Incentivized

• Easy to configure and use with Visual Studio and Dot Net
• Easy integration with MSBI to perform data analysis
• Data Security
• Easy to understand and use
• Very easy to export database and tables in the form of SQL query or a script

Incentivized

• I had some big complaints about how to edit calculations and scripts, and not being able to print/export PDF from server but with the last 2 versions I can't complain any more. Those got added.
• Syncing records between iOS and Filemaker Server still requires a developer to accomplish. Although I make money doing it for others I wish there was some "central" method of syncing that everyone can follow.

• The import/export process can be tricky to follow with lots of steps and could be better for importing flat files
• Obtaining help from Microsoft is cumbersome and often other internet sources are better and quicker
• The documentation is not great and again it's generally better to obtain help elsewhere if needed

Incentivized

It it not really up to me but my opinion does have some weight in the decision and the reason I would renew my use FileMaker Pro 8.5 is because I am finally getting used to it! Now that I have been working with the program, tasks have become quicker and projects are getting done faster. File Maker Pro 8.5 really is a versatile tool and I think we are just scratching the surface with it's abilities.

Incentivized

I think it is unlikely that sql server has disappointed someone, it is likely that someone will come initially discouraged if the needs and problems that occur are very challenging, but definitely have a SQL oriented system means having a solid base to work and on which maintain the their data securely

Incentivized

It's almost what it should be after so may years and with Apple's longevity and strength behind it. For people who earn their living based on efficiency I think there are too many developer obstacles that waste time and therefore money.

Incentivized

SQL Server mostly 'just works' or generates error messages to help you sort out the trouble. You can usually count on the product to get the job done and keep an eye on your potential mistakes. Interaction with other Microsoft products makes operating as a Windows user pretty straight forward. Digging through the multitude of dialogs and wizards can be a pain, but the answer is usually there somewhere.

Incentivized

mostly never issues and if there are they are resolved fast

Incentivized

Its does not have outages.

Incentivized

for the most part but lots of error messages if you type something h correctly

Incentivized

SSAS data cubes may some time slow down your Excel reports.

Incentivized

The forums are great with lots of helpful experts and the staff monitor them to provide help where needed. There have been a couple of unique technical issues I've had to deal with that I haven't been able to get resolved so I chose to score this a 9 instead of a 10.

Incentivized

We managed to handle most of our problems by looking into Microsoft's official documentation that has everything explained and almost every function has an example that illustrates in detail how a particular functionality works. Just like PowerShell has the ability to show you an example of how some cmdlet works, that is the case also here, and in my opinion, it is a very good practice and I like it.

Incentivized

easy to follow along and was able to jump in right away

Incentivized

It was good

Incentivized

very hands on and detailed training

Incentivized

Suggest you use an iterative R.A.D. or AGILE development approach. (i.e. rather than writing a gigantic spec for a system, then building it). FileMaker facilitates quick prototypes. Developing an example, then allowing users to "try it out" is a snap.

Incentivized

Other than SQL taking quite a bit of time to actually install there are no problems with installation. Even on hardware that has good performance SQL can still take close to an hour to install a typical server with management and reporting services.

Incentivized

FileMaker Pro is the chaotic, cumbersome and non-integratable little sibling of MS Access. And even MS Access can't be taken serious in a medium sized company. FileMaker Pro can not even be compared to serious products like OutSystems and Sitecore. It's also not free... whereas at least MS Access can be used free, even if your company is (really) small.

Incentivized

Microsoft SQL is slower than MySQL and Access but far more feature-rich and reliable. Access is almost obsolete nowadays, so not too many people are considering it, but unless budget or an open-source ethos is a factor, Microsoft SQL is superior in every way. Many commonly used tools, like Crystal Reports, support it.

Incentivized

it's most definitely does as we are a unique business to use this for scholarship awarding

Incentivized

SQL server does handle growing demands of a mid sized company.

Incentivized

• Positive impact for my company is that we have designed a solution that meets the needs of our very custom processes.
• My company is in the process of expanding rapidly and with that the need for new tools are need quickly. With most languages (like Java or .Net), it could take weeks to develop the same tool it takes us 3 days to make in Filemaker.
• The most negative impact however is that at times Filemaker will just become overwhelmed and we have no choice but to restart the server which hosts the application.

Incentivized

• Increased accuracy - We went from multiple users having different versions of an Excel spreadsheet to a single source of truth for our reporting.
• Increased Efficiency - We can now generate reports at any time from a single source rather than multiple users spending their time collating data and generating reports.
• Improved Security - Enterprise level security on a dedicated server rather than financial files on multiple laptop hard drives.

Incentivized