Import and export data - Navision SQL Server Option

Freaky · 2009-09-04

Hi Guys,
Am trying to export tables from one database to another using microsoft SQL Server 2008 and Navision SQL Server Option. However, I am getting read-only error on the destination database. The two databases are exactly the same. My aim is to copy data from one to another. Any ideas how we can achieve this.
Please help!!!

Alex_Chow · 2009-09-04

Don't write data directly into SQL! Always go through NAV front end interface.

Slawek_Guzek · 2009-09-04

Freaky wrote:

Hi Guys,
Am trying to export tables from one database to another using microsoft SQL Server 2008 and Navision SQL Server Option. However, I am getting read-only error on the destination database.

Apart from you should not write directly at SQL level as per very wise Alex advice, it is most probably SQL level security issue.

Check if login or user used to connect to destination database has sufficient rights to this database. Check this as SQL level - as under normal circumstances NAV users are granted only public level access to NAV database, and NAV handles security using application roles permissions and not logged user permissions.

Slawek

Import and export data - Navision SQL Server Option

Comments

Categories