Navision database to SQL Server database

sridhar

Is it possible to migrate from Navision database to SQL Server database?

admoretutsie

L would like to believe its possible. Do your "Entire Backup" of the Navision database, it Tools -> Backup.That will give you a .fbk file. Now open the navision SQL OptionClient and create a new database, call it your anything reasonable. File -> databse -> New. You will input the SQL server to the new databse, and you need to be authenticated. After clicking "OK" and assuming you were allowed access, you will see a new Form were you specify the database name, and the location of the database files on the next tab (Databse Files). NB this should be filled for you after inputing the Datase NAme, and l would not suggest alterting the path if you really dnt understand whats going on. Click Ok, and your databse is up, and create a company in the databse you have just created.

Now restoring the .fbk file you created during backup. Whilist in the company you just created, Tools -> Restore and thats it, "retore the Entire BAck up". break for coffe and lunch and maybe supper depending on the size of your DB, becasue its going to take some time.

Good Luck!!!

bbrown

Use the Migrate.fob to test the dates before attempting a move to SQL.

ara3n

you'll run into date problem. sql cannot have dates earlier than certain year, and if users have entered dates for example 12/12/1500, you'll get the error.

sridhar

Thanks Friends, I will try it out..

kine

The whole process is described in Upgrade toolkit documentation (w1w1upgr.pdf) in chapter 7.