Migrating from Access/SQLServer
I am considering migrating from from access SQL Server to FileMaker Pro and had a couple of questions.
My first question is does FileMaker Pro have the concept of a linked external table?
If so, would it be better to design a new database such that the data was still stored in the original SQL Server tables, or if possible import the data into new FileMaker Pro tables?
Since I have no experience with FileMaker Pro my concern of course is that I would literally have to start over again and certainly cannot do that since the data in the access SQL Server database has been being generated for many years and encompasses a great deal of valuable information.
Has anyone out there done this sort of conversion before? If so, do you have any tips or suggestions that you might offer?
Any help would be appreciated!
Thanks in advance.