1 of 1 people found this helpful
SSMS = SQL Server Management Studio. EG, not "FileMaker or ODBC management studio"
It's suite of tools is only designed to work with SQL data sources, and FileMaker server reports back differently.
Thus, I'm not sure what you're trying to do, but SSMS is not compatible with FileMaker's schema.
I have added the filemaker database as a linked server in SQL Server Management Studio and I can query the database using openquery. So I think it is compatible?
I would be interested to know if anyone on the forums has used this approach before.
Openquery may work for queries (it's called openquery because it uses a standard communication, not a proprietary language), but FileMaker doesn't have any idea how to respond to some of the higher level SQL language schema commands.
So while you may have been able to get some things to work, you may not ever be able to get all things to work. Compatibility isn't based on one function working or not, it's the entire thing. I'll stick with my statement that SSMS is designed to manage SQL servers only.
What is your use case? Why is FileMaker Server not acceptable for managing hosted filemaker databases, and FileMaker Pro acceptable for making changes to database schema?