Convert FoxPro to MS SQL Server and keep database relations

Question

We have a custom built application that utilizes FoxPro for a database.  The application is old and the creators are no longer around.  I want to merge (and convert if possible) this database with our MS SQL server database.  I have been reading that it's possible to import data, but can I convert the entire database structure without losing functionality?

Or would I be better off starting from scratch?

Thank you for looking and pondering.

Answer 1

It is possible to migrate table structure, data and relations using DBConvert software  .  UI should be recreated manually though.

Answer 2

Fantastic!  We are looking recreating the UI with ASP.net.  Unless there are any other recommendations?

Answer 3

I guess, ASP.NET + MS SQL backend would be the best choice