Forum Discussion

Michael Simpson's avatar
Michael Simpson
Copper Contributor
Oct 10, 2017

Compatibility of MSSQL to current releases

There is an extensive World War II forum that was adminsitered using MSSQL. What are the limitation on trying to convert the MSSQL data schema into either the 2014 or 2016 SQL releases.

  • Hi Michael,

     

    what is the current SQL Server version you are using? Are there any "special" features you are using or just plain DB-Engine functionality?

     

    Wolfgang

    • Michael Simpson's avatar
      Michael Simpson
      Copper Contributor

      Unfortunately I do not have an identification on the MS SQL server version.  The developer, Scott Burris, originally designed a World War II Army Air Forces database back in 1998. His system was managed through his web hosting company.  About two years ago, the company dropped support of MS SQL.

       

      I am the President of the Heritage League of the Second Air Division - USAAF, a non-profit organization dedicated to preserving the legacy of the fourteen B-24 Liberator bomb groups that were part of the Eighth Air Force.  What we're hoping to do is to preserve the almost 15GB of data that Scott's collected between 1998 and 2015.  We have several members of our executive staff that are familiar with relational databases using Apple's FileMaker Pro.

       

      What we're hoping to accomplish is to convert the data in the MS SQL format into MySQL which our website hosting company provides.  Any suggestion or ideas would be greatly appreciated.

      • Douglas Rapp's avatar
        Douglas Rapp
        Copper Contributor

        Hello

         

        There are a group of us members of the forum that would like to continue the forum and support it both financially and to administer the forum. Could you please contact me at 260-402-7317 or contact at douglasrapp@me.com. Thank you!

         

        Doug

Resources