SQL to FDB, FDB to SQL

Cobbler

Hi All,

I've a question. How can I convert an SQL database to a native (.FDB) database? And how can I create a brand new native FDB.

What I did up to now:
- created a full backup from the current SQL database (with finsql.exe)
- ran fin.exe and created a new database
- restore the previously created .fbk backup file to this database

I found that new database in the C:\Program Files\Microsoft Business Solutions-Navision\Client\. But it hasn't got any extension (it seems). I guessed it will has .fdb extension.

What is the problem with my method?

Anyway the Nav is able to open this new database, so it works.
And if I add an .fdb extension to that new database it will be okay as well.

Thanks in advance!

vikram7_dabas

While taking back u haven't write the extension which is .fbk

kine

NAV will not add the extension for you. You need to enter it manually when creating the file...

Cobbler

Okay, so the SQL to FDB half topic is solved.

But what is about vica versa? I mean FDB -> SQL.

kine

1) You must be sure that all date values are correct for SQL. You need to use migrate.fob from upgrade toolkit to check that (and correct wrong dates like 10.9.0007 etc.)
2) Make a Nav backup (.fbk) - fin.exe
3) Create new SQL db - finsql.exe
4) Restore the backup - finsql.exe

Cobbler

Er.. what is upgrade toolkit? Is it a separate CD, that contains the migrate.fob?

kine

It is a package, which you can download from partnersource. It includes documentation how to upgrade, needed objects (migration and upgrade toolkit).

Cobbler

Okay, thanks to all for your helps.