sql server 2005

aamoll

how to import database insql server 2005

vijay_g

what's your database file type is it .mdf or .fdb?

aamoll

database file is .fdb

tanmaykothari

Dear Amol
try this

First create .fbk file. then restore it on SQL

kriki

If you don't know this, it is better to get some assistance from someone who does and let you explain it.

rranjanerp

HELLO i have created .fbk file from my native database .fdb by taking bakup.
now when i m trying to restore bakup ..it is showing error...

i right click on databse --> tasks-->restore--> databse ...here there is option for selecting .bak file ..i select all files than my .fbk file ..error comes

is there otherprocess to restore ..? please help ..i hav native databse but no sql database.. i want to connect my nav (.fdb) database to sql server 2005 . nav version is 2009.

pawanp

What is the error that you are getting????

You need to import Migrate.FOB in your FDB database and run FieldCheck codeunit to remove all junk values which SQL doesnt support. You can find Migrate.FOB in the Installation DVD.

rranjanerp

Dear Pawanp,

actually i get the the error " an exception ocuured .... attached here..Also i could not find the migrate .fob object in my dvd. is it a table ? can i get this object from other source ? there is no codeunit by name "field check " i can see the codeunit "ADCS Get Field Value"i have earlier done the restoration of .fbk file in sql server. why its showing error here..i think u r right that i wil have to remove the things which sql does not support ...plz explain the best option possible..attached is the error..

vaprog

In the NAV Upgrade toolkit are step by step instructions on SQL migration. Follow those steps instead of trying silly things like treating a NAV backup file as a SQL Server backup file.