4 Replies Latest reply on May 14, 2010 8:40 AM by Robman

    Migrating from Access/SQLServer

    Robman

      Title

      Migrating from Access/SQLServer

      Post

      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.