how to convert database.fdb to database.mdf

Business Central/NAV User Forum
1

hello all

we have navision database attached to navision server i need to convert this database to mdf format to attach with sql server i try to export all data from navasion database using data migration then creat new database attached to sql then from data migration import this data from xml file but not succeeded can any body help

2

As far as I know there is no direct way of converting it.

This how I would do it:

  1. Make a backup of you database selecting, in NAV client, Tools > Backup
  2. Run NAV Classic Client for SQL Server (finsql.exe) and create a new database on your SQL Server selecting File, Database, New
  3. Restore the backup made in step 1 above into this database selecting Tools > Restore
3

Of course that will only work if you don’t have any data issues in the fdb. Check out the upgrade toolkit, there should also be some instructions on how to make sure that all your data is good to go into SQL Server.

4

thank you too much