Importing database into SQL server from Navison

ayamas

Hi guys,
Can anyone pls tell me is there any way by means which we can import data in SQL database from navision?
Thanks in advance

vivektaurian

hi,

1.First Take the backup of the Navision Database.
2.Start SQL Server option from programme files.
3.Create New Database.
4.now restore the backup which u have made earlier.

I think that ur problem is solved

kine

1) I am not sure, if I understand... you need to import data from some SQL server into Navision? Are you using SQL DB for Navision or Native DB?

2) If you are using Native db and you want to read data from MS SQL, you can use ADO Automation for reading the data. Search MIBUSO for ADO, there are examples how to do that.

3) If you are using MS SQL server for Navision, you have more options - you can use ADO as in point 2, or you can create some SQL View in the Navision DB and connect it as Linked table in Navision. In this case, you will access the data directly through new table in Navision (you can use linked server in MS SQL to read data from another server). But in this case, you need more knowledge about MS SQL...

ayamas

No kine.I want to get the data into SQL server from Navision.I think that the method suggested by vivek is much more feasible.

kine

Ah, you need to migrate from Native DB to SQL DB... :-)

Than one step is needed - using Migrate.fob from upgrade toolkit. It will check all data fields if there are correct data, else you can have problems when restoring backup on MS SQL... See upgrade toolkit for info how to migrate to MS SQL.

ashishgupta

Dear Kine,
What problems can be there in the solutions given by Vivek.

kine

Problem of incorrect Date value. SQL support date >=1.1.1753. Older date cannot be used. But Navision is able to use date like 1.1.0005 etc. and the database is full of such values, because the values are entered by mistake (for example user enter 0101005 instead 010105).