How to split Navision tables amongst different SQL database

melbourne

Hi,

I am looking for a document that defines how to split Navision tables amongst different SQL database files.

Regards

DenSter

There's nothing you can do from within NAV to accomplish that. The only way you can do that is to use SQL Server tools. Beware though that when you design and save a table from within NAV, your settings for that table may be lost.

Marije_Brummel

For what I have heard it should be possible to do an alter table in SQL without having problems with tabledesign afterwards.

I have not tested it yet and I would strongly recomend doing that before proceeding to apply this in a live database!

ara3n

Yes, I've seen people unchecking "Not NULL" property on tables and after saving the table in Navision, the property stays in SQL.